SQL Server R2 Performance counter detailed list (ii)

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)