SQL Server R2 Performance counter detailed list (ii)

Source: Internet
Author: User
Tags failover flushes

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)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.