Ideally, there should be no Log pages read.
理想情况下，应该没有日志页面读。
When there are too many log pages read, it means a bigger LOGBUFSZ is needed.
当log pages read太多时，意味着需要一个较大的 LOGBUFSZ。
An ideal value would be zero log pages read while seeing a good number of log pages written.
理想情况下，“log pages read”的值应为0，而“log pages written”的值应很大。
The ratio of the number of Log pages read to the number of Log pages written should be as small as possible.
日志页面读数目与日志页面写数目的比值应尽可能小。
If you see a large number of LOG pages read, it indicates that the value of the LOGBUFSZ database parameter should be increased.
如果看到了较多数目的日志页面读，就表示应该增加LOGBUFSZ数据库参数的值。
Log pages read is the number of log pages read from disk by the logger, while log pages written is the number of log pages written to disk by the logger.
日志页面读(log pages read)是日志记录器(logger)从磁盘读取的日志页面的数目，而日志页面写(log pages written)是日志记录器(logger)写入磁盘的日志页面的数目。
Thus, the read operations compete with log writing and the write operation for data pages from the buffer pool.
因而，读操作与日志写和缓冲池中的数据页的写操作之间存在竞争。
When you run queries for very large audit log tables, you can end up with a situation where your database system has to read thousands of pages into the bufferpool to compute the result.
当您在大型审核日志表格中运行查询功能时，您可能会在您的数据库系统不得不向缓冲池读入数千页面以进行计算时而结束。
When you run queries for very large audit log tables, you can end up with a situation where your database system has to read thousands of pages into the bufferpool to compute the result.
当您在大型审核日志表格中运行查询功能时，您可能会在您的数据库系统不得不向缓冲池读入数千页面以进行计算时而结束。
应用推荐