ResourceWaits Data Collector

"ResourceWaits" Data Collector

For a detailed discussion of these metrics, see ProTop Real-Time - Latches and Resources (w) and ProTop Trends - Latches and Resources.

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_resrc     (temptable name)
resrcLkPct Lock% num Percent of time the resource is locked
resrcName Resource char Resource name
resrcReq Requests num Number of requests for that resource
resrcWts Waits num Number of times the process fails to get a latch because of excess spin