|
|
|
DIAGNOSTICS NODE_REQUEST_TIME
Enables tracking the cumulative time spent finding each index node in the index cache. The LockDump() function includes the node request times in its output. The average and total node request times are reported in milliseconds.
Example
Buffer request count profile:
Avg req time Tot req time Request count Block count Node offset Filno Type Filename
------------ ------------ ------------- ------------ ------------------ ----- ---- --------------------
NRQ: 3 605087 200000 67078 0x000000000033e000 26 R admin_sys_001_000001613.idx
NRQ: 1 298947 200000 33912 0x0000000000008000 21 R admin_sys_001_000001693.idx
NRQ: 0 13977 94150 1544 0x000000000033c000 26 I admin_sys_001_000001613.idx
NRQ: 0 7762 94149 740 0x000000000000c000 26 I admin_sys_001_000001613.idx
NRQ: 0 177 11701 11 0x00000000005fc000 26 I admin_sys_001_000001613.idx
NRQ: 0 64 269 0 0x00000000004f6000 26 L admin_sys_001_000001613.idx
NRQ: 0 60 269 0 0x00000000003c8000 26 L admin_sys_001_000001613.idx
NRQ: 0 60 269 0 0x00000000001f6000 26 L admin_sys_001_000001613.idx
NRQ: 0 57 269 0 0x00000000002b2000 26 L admin_sys_001_000001613.idx
NRQ: 0 56 269 0 0x00000000004ae000 26 L admin_sys_001_000001613.idx
