"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 |