Simulated Buffer Pool Statistics
This topic shows detailed information about Statistics - Simulated Buffer Pool Statistics
.
Statistics - Simulated Buffer Pool Statistics
The field labels shown in the following sample layout of Statistics - Simulated Buffer Pool Statistics
are described in the following section.
---- HIGHLIGHTS -------------------------------------------------------------------------------------------------
INTERVAL START : 11/12/14 21:33:43.65 SAMPLING START: 11/12/14 21:33:43.65 TOTAL THREADS : 41.00
INTERVAL END : 11/12/14 21:45:00.00 SAMPLING END : 11/12/14 21:45:00.00 TOTAL COMMITS : 2593.0K
INTERVAL ELAPSED: 11:16.350028 OUTAGE ELAPSED: 0.000000 DATA SHARING MEMBER: N/A
SIM BP CUR PAGES IN USE CUR SEQ PAGES IN USE SYNC READ I/O (R) SYNC GBP READS (R) PAGES MOVED INTO SIM BP
MAX PAGES IN USE MAX SEQ PAGES IN USE SYNC READ I/O (S) SYNC GBP READS (S) TOTAL SYNC I/O DELAY
ASYNC READ I/O ASYNC GBP READS
------ ------------------ -------------------- ------------------ ------------------- -----------------------
BP8 2077148.09 108280.75 25602267.00 0.00 33399137.00
2077152.00 113140.00 303521.00 0.00 2:53:53.887488
3471925.00 0.00
BP19 9999.83 2091.49 444527.00 0.00 8181054.00
10000.00 2304.00 0.00 0.00 2:48.717001
31990.00 0.00
BP21 2087151.56 14232.85 3557658.00 0.00 7269201.00
2087152.00 15309.00 29.00 0.00 1:33:27.140580
514.00 0.00
BP23 2087151.47 428373.09 3746564.00 0.00 9301079.00
2087152.00 455354.00 839.00 0.00 1:04:06.941451
71096.00 0.00
BP26 2000.00 0.00 182189.00 0.00 3311185.00
2000.00 35.00 0.00 0.00 1:18.368918
4.00 0.00
- SIM BP
-
The buffer pool ID.
Field Name: QBSPBPID
- CUR PAGES IN USE
-
The number of simulated buffers currently in use in the simulated buffer pool.
Field Name: QBSPIUS
- MAX PAGES IN USE
-
The highest number of simulated buffers that were in use in the simulated buffer pool.
Field Name: QBSPHUS
- CUR SEQ PAGES IN USE
-
The number of simulated buffers currently in use for sequential pages in the simulated buffer pool.
Field Name: QBSPSUS
- MAX SEQ PAGES IN USE
-
The highest number of simulated buffers that were in use for sequential pages in the simulated buffer pool.
Field Name: QBSPHSU
- SYNC READ I/O (R)
-
The number of pages found in the simulated buffer pool for a random request that could have avoided a synchronous read I/O from disk.
Field Name: QBSPDRR
- SYNC READ I/O (S)
-
The number of pages found in the simulated buffer pool for a sequential request that could have avoided a synchronous read I/O from disk.
Field Name: QBSPDRS
- ASYNC READ I/O
-
The number of pages found in the simulated buffer pool for a prefetch request that could have avoided an asynchronous read I/O from disk.
Field Name: QBSPDRA
- SYNC GBP READS (R)
-
The number of pages found in the simulated buffer pool for a random request that could have avoided a synchronous read from GBP.
Field Name: QBSPGRR
- SYNC GBP READS (S)
-
The number of pages found in the simulated buffer pool for a sequential request that could have avoided a synchronous read from GBP.
Field Name: QBSPGRS
- ASYNC GBP READS
-
The number of pages found in the simulated buffer pool for a prefetch request that could have avoided an asynchronous read from GBP.
Field Name: QBSPGRA
- PAGES MOVED INTO SIM BP
-
The number of pages logically moved into the simulated buffer pool from the virtual buffer pool.
Field Name: QBSPMVI
- TOTAL SYNC I/O DELAY
-
The total time waiting for synchronous read I/O from disk for pages found in the simulated buffer pool.
Field Name: QBSPDTM