"BigBGuesstimator" Data Collector
For a detailed discussion of these metrics, see ProTop Real Time - BigB Guesstimator (B).
To set up an alert on a metric listed here, make note of the Data Collector name at the top of this page, the Alertable Metric and Data Type from the table below and visit Alert Configuration.
|Alertable Metric||ProTop RT Label||Data Type||Description|
|bigb||BigB (-B)||num||Number of memory blocks assigned at database server process startup|
|bigbGB||BigB (GB)||num||Amount of memory assigned to database buffers as expressed in gigabytes|
|db-pct||% DB Size||num||Amount of memory, in gigabytes, as a percentage of the size of the database|
|dbSize||DB Size (GB)||num||Database size expressed in gigabytes|
|hpct||Hit%||num||Number of record reads from memory buffers as a percentage of all reads|
|hr||Hit:1||num||The number of database reads from buffers per single disk read. "999999" means no OS reads|
|mpct||Miss%||num||Number of record reads from disk as a percentage of all reads|
|osr||OS Reads||num||Number of OS reads fetching records from the database|
|xnote||Note||char||Just a note ... usually shows the value of -B|
|xpct||Pct||num||Percentage of data blocks, with 100% being the current -B value|