| Parameters |
Description |
| Connections |
The user connection counter identifies the number of users connected to the SQL Server. |
| Number of Errors |
Number of errors per second. |
| Batch Requests |
Number of SQL batch requests received by server. |
| Longest Transaction Time |
The longest running time of any transaction in seconds. |
| Backup Device Throughput |
Read/write throughput for a backup device. |
| SQL Compilations |
Number of SQL compilations. |
| SQL Re-Compilations |
Number of SQL re-compiles. |
| Replication Merge Conflicts |
The number of conflicts per second occurring during the merge process. |
| Memory Manager Details |
|
| Target Server Memory (MB) |
Total amount of dynamic memory the server is willing to consume. |
| Total Server Memory (MB) |
Total amount of dynamic memory the server is currently consuming |
| SQL Cache Memory (MB) |
Total amount of dynamic memory the server is using for the dynamic SQL cache |
| Optimizer Memory (MB) |
Total amount of dynamic memory the server is using for query optimization |
| Connection Memory (MB) |
Total amount of dynamic memory the server is using for maintaining connections |
| Buffer Manager Details |
|
| Lock Memory (MB) |
Total amount of dynamic memory the server is using for locks |
| Granted Workspace Memory (MB) |
Total amount of memory granted to executing processes. |
| Memory Grants Pending |
Current number of processes waiting for a workspace memory grant |
| Buffer cache hit ratio |
Percentage of pages that were found in the buffer pool without having to incur a read from disk. |
| Checkpoint pages/sec |
Number of pages flushed by checkpoint or other operations that require all dirty pages to be flushed. |
| Lazy writes/sec |
Number of buffers written by buffer manager's lazy writer |
| Page life expectancy |
Number of seconds a page will stay in the buffer pool without references. |
| Page writes/sec |
Number of physical database page writes issued. |
| Page reads/sec |
Number of physical database page reads issued. |
| Total pages |
Number of pages in the buffer pool |
| Database pages |
Number of pages in the buffer pool with database content. |
| Free pages |
Total number of pages on all free lists. |
| Plan and Job Details |
|
| Cache Hit Ratio % |
Ratio between cache hits and lookups |
| Cache Pages |
Number of 8k pages used by cache objects |
| Cache Object Counts |
Number of cache objects in the cache |
| Active jobs |
Number of running jobs. |
| Failed jobs |
Number of failed jobs. |
| Queued jobs |
Number of jobs queued. |
| Job Success Rate |
Percentage of successful jobs from the total number of executed jobs |
| Lock and Latch Details |
|
| Lock Requests/sec |
Number of new locks and lock conversions requested from the lock manager. |
| Lock Timeouts/sec |
Number of lock requests that timed out |
| Lock Wait Time |
Total wait time (milliseconds) for locks in the last second. |
| Deadlocks/sec |
Number of lock requests that resulted in a deadlock. |
| Average Lock Wait Time |
The average amount of wait time (milliseconds) for each lock request that resulted in a wait. |
| Average Latch Wait Time |
Average latch wait time (milliseconds) for latch requests that had to wait. |
| Latch Waits/sec |
Number of latch requests that could not be granted immediately and had to wait before being granted. |
| Database Details |
|
| Active Transactions |
Number of active update transactions for the database. |
| Transactions/sec |
Number of transactions started for the database. |
| Log Cache Hit Ratio |
Percentage of log cache reads that were satisfied from the log cache. |
| Log File(s) Size (MB) |
The cumulative size of all the log files in the database. |
| Log File(s) Used Size (MB) |
The cumulative used size of all the log files in the database. |
| Log Growths |
Total number of log growths for this database. |
| Log Shrinks |
Total number of log shrinks for this database. |
| Data File(s) Size (MB) |
The cumulative size of all the data files in the database |
