...解体系全体负载情况,如每秒中的事件数/语句数,每秒/每事件物理读写次数(Physical Reads/Writes), 逻辑读写次数(Logical Reads/Writes),SQL语句的剖析(Parse),独特是硬剖析次数等。
基于14个网页-相关网页
session logical reads 逻辑读请求数
BUFFERPOOL - Physical reads, logical reads and timing information.
BUFFER POOL——物理读、逻辑读和定时信息。
The value for "Rows read" is the lowest with parameter markers, but this is not really important, as the "Buffer pool index logical reads" go up in this case.
在有参数标记时的 “Rows read” 值最小,但实际上这并不重要,因为此时 “Buffer pool index logical reads” 值较高。
While the amount of logical ISAM instructions we have performed is at 6 million reads, the number of lock requests (which is a physical indicator of what was read) is at 59 billion.
而我们执行的逻辑ISAM指令的数量是6百万次读取,锁请求数是(就是所读取的物理指示器)是590亿。
应用推荐