Analysis Services
Analysis Server:Locks Object
The following table lists performance counters from the Microsoft® SQL Server™ 2000 Analysis Services Locks object. The Locks object counters provide information about latching and locking activity. They can be used to monitor the performance of latches and locks with Analysis Services.
| Latch object counters | Description |
|---|---|
| Current latch waits | Current number of threads waiting for a latch. These are latch requests that could not be given immediate grants and are in a wait state. |
| Current lock waits | Current number of clients waiting for a lock. |
| Current locks | Current number of locked objects. |
| Latch waits/sec | Rate of latch requests that could not be granted immediately. |
| Lock denials/sec | Rate of lock denials. |
| Lock grants/sec | Number of lock grants per second. |
| Lock requests/sec | Number of lock requests per second. |
| Lock waits/sec | Number of lock waits per second. These are lock requests that could not be given immediate lock grants and are in a wait state. |
| Unlock requests/sec | Number of unlock requests per second. |