Original: SQL Server R2 Performance counter detailed list (ii)
SQL Server Buffer Partition object: provides counters to monitor how SQL Server uses available pages
SQL Server Buffer Partition counters |
Description |
Free list Empty/sec |
The number of times per second that an available page was requested but could not be supplied. |
Free list Requests/sec |
The number of times per second that an available page is requested. |
Free pages |
The total number of pages for all available lists. |
SQL Server CLR objects:monitoring the execution of the common language runtime (CLR) in Microsoft SQL Server
CLR Counters |
Description |
CLR Execution |
Total execution time in the CLR (microseconds) |
SQL Server Cursor Manager by Type object: object provides counters (grouped by type) to monitor cursors
Cursor Manager by Type counter |
Description |
Active Cursors |
The number of active cursors. |
Cache hit Ratio |
The rate of cache hits and lookups. |
Cached Cursor Counts |
The number of cursors for the given type in the cache. |
Cursor Cache Use count/sec |
The number of times each cached cursor is used. |
Cursor Memory Usage |
The amount of memory (in kilobytes) that the cursor occupies. |
Cursor requests/sec |
The number of SQL cursor requests received by the server. |
Cursor worktable Usage |
The number of worksheets used by the cursor. |
Number of active cursor plans |
The number of cursor plans. |
Each counter in the object contains the following instances:
Cursor Manager Instance |
Description |
_total |
Information for all cursors. |
API Cursors |
API cursor information only. |
TSQL Global Cursors |
Transact-SQL global cursor information only. |
TSQL Local cursor |
Transact-SQL local cursor information only. |
SQL Server Cursor Manager Total object: counters for monitoring cursors
Cursor Manager Total counter |
Description |
Async Population Count |
The number of cursors that are populated asynchronously. |
Cursor Conversion rate |
The number of times the cursor is converted per second. |
Cursor Flushes |
The total number of run-time statements recreated by the cursor. |
SQL Server Database mirroring objects: contains performance counters that report on SQL Server database mirroring
name |
Description |
Bytes received/sec |
The number of bytes received per second. |
Bytes sent/sec |
The number of bytes sent per second. |
Log Bytes received/sec |
The number of log bytes received per second. |
Log Bytes Redone from Cache/sec |
The number of redo log bytes obtained from the mirrored log cache in the last second. This counter is used only on the mirror server. This value is always 0 on the principal server. |
Log Bytes Sent from Cache/sec |
The number of send log bytes obtained from the mirrored log cache in the last second. This counter is used only on the principal server. This value is always 0 on the mirror server. |
Log Bytes sent/sec |
The number of log bytes sent per second. |
Log Compressed Bytes rcvd/sec |
The number of compressed bytes received for the log in the last second. |
Log Compressed Bytes sent/sec |
The number of compressed bytes of the log sent in the last second. |
Log Harden Time (ms) |
The time, in milliseconds, that the log block waits for the disk to be forcibly written in the last second. |
Log Remaining for Undo KB |
The total number of log bytes (KB) waiting to be scanned by the new mirror server after the failover. This counter can only be used on the mirror server during the undo phase. After the undo phase is complete, this counter is reset to 0. This value is always 0 on the principal server. |
Log scanned for Undo KB |
The total number of bytes of log (in kilobytes) that have been scanned by the new mirror server since the failover began. This counter can only be used on the mirror server during the undo phase. After the undo phase is complete, this counter is reset to 0. This value is always 0 on the principal server. |
Log Send Flow Control Time (ms) |
The time, in milliseconds, that a log stream message waits for a send flow control in the last second. In database mirroring, sending log data and metadata to a mirror partner is the most data intensive operation and may monopolize the database mirroring and Service Broker send buffers. Use this counter to monitor the use of this buffer for database mirroring sessions. |
Log Send Queue KB |
Total number of bytes of log that have not been sent to the mirror server (KB). |
Mirrored Write transactions/sec |
The number of transactions written to the mirror database in the last second and waiting for the log to be sent to the mirror database for submission. This counter is incremented only if the principal server is sending log records to the mirror server. |
Pages sent/sec |
Number of pages sent per second. |
receives/sec |
The number of mirrored messages received per second. |
Redo bytes/sec |
The number of log bytes rolled forward in the mirrored database per second. |
Redo Queue KB |
The total number of bytes (KB) of the mirror log that is currently applied to the mirror database for roll forward operations. This data is sent from the mirrored database to the principal database. |
send/receive Ack time |
The time, in milliseconds, that the message waits for a partner acknowledgment in the last second. This counter is useful when addressing issues that may be caused by network bottlenecks, such as unexplained failovers, large send queues, or long transaction latency. In these cases, you can analyze the value of this counter to determine whether the problem is caused by the network. |
sends/sec |
The number of mirrored messages sent per second. |
Transaction Delay |
The delay time to wait for an unterminated commit acknowledgement. |
SQL Server Databases objects: Monitoring bulk Copy operations, backup and restore throughput, and transaction log activity
SQL Server Databases counters |
Description |
Active Transactions |
The number of active transactions for the database. |
Backup/restore throughput/sec |
Read/write throughput for the backup and restore operations of the database per second. For example, when you use multiple backup devices in parallel or use a faster device, you can measure the performance changes in database backup operations. The throughput of a database backup or restore operation can determine the process and performance of backup and restore operations. |
Bulk Copy rows/sec |
The number of rows that are bulk copied per second. |
Bulk Copy throughput/sec |
The amount of data in kilobytes per second that is bulk copied. |
Data File (s) Size (KB) |
The cumulative size (in kilobytes) of all data files in the database, including any autogrow. It is useful to monitor this counter, for example, to determine the exact size of tempdb . |
DBCC Logical Scan bytes/sec |
The number of logical read scan bytes per second of the Database Console command (DBCC). |
Log Bytes flushed/sec |
Total number of log bytes flushed. |
Log Cache hit Ratio |
Percentage of log cache reads that are satisfied by the log cache. |
Log Cache reads/sec |
The number of reads executed per second through the Log manager cache. |
Log File (s) Size (KB) |
The cumulative size (in kilobytes) of all transaction log files in the database. |
Log File (s) used Size (KB) |
The cumulative size of all log files in the database. |
Log Flush Wait time |
Total wait time (in milliseconds) to refresh the log. |
Log Flush waits/sec |
The number of commits per second waiting for log refreshes. |
Log flushes/sec |
Number of log refreshes per second. |
Log Growths |
The total number of times the database transaction log grew. |
Log shrinks |
The total number of times the database transaction log shrank. |
Log truncations |
Total number of database transaction log truncation. |
Percent Log used |
The percentage of space used in the log. |
repl.pending xacts |
The number of transactions in the publication database transaction log that have made replication tokens but have not yet been delivered to the distribution database. |
Repl.Trans.Rate |
The number of transactions per second that are read from the publication database transaction log and delivered to the distribution database. |
Shrink Data Movement bytes/sec |
The amount of data moved per second by an auto-shrink operation or by a DBCC SHRINKDATABASE or DBCC SHRINKFILE statement. |
transactions/sec |
The number of transactions started per second for the database. |
Write transactions/sec |
The number of transactions written to the database and committed within the last second. |
SQL Server R2 Performance counter detailed list (ii)