BigBGuesstimator Data Collector

"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
tt_bigb     (temptable name)
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