SQL SERVER – Introduction to Three Important Performance Counters

Performance Counters are very important to evaluate. There are more than thousands of Performance Counters. Today I will cover three basic but very important Performance Counters.

Processor:% Processor Time
It reports the total processor time with respect to the available capacity of the server. If counter is between 50 to 70 % consistently, investigate the process which is taking long time.

PhysicalDisk:Avg.Disk Queue Length
It indicates wait time for processes to use disk resources. As a disk is reading and writing data some requests cannot be immediately filled, those requests are queued. If many simultaneous requests are waiting, investigate the process which is taking long time.

PhysicalDisk:Disk Read Bytes/sec and PhysicalDisk :Disk Write Bytes/sec
It report the number of bytes read from and written to the disk, respectively. Slow SELECT queries with high physical reads and low queue lengths demonstrates under performance of Disk read and write. Index optimization can reduce this problem.

You can watch above performance counters using windows perfmon utility.

SQL SERVER – Introduction to Performance Monitor

Reference : Pinal Dave (http://blog.SQLAuthority.com)

7 thoughts on “SQL SERVER – Introduction to Three Important Performance Counters

  1. Pingback: SQL SERVER - Introduction to Performance Monitor - How to Use Perfmon Journey to SQL Authority with Pinal Dave

  2. Pinal,

    Do we have to look more if we have multiple instances on the server and remote viewing (viewing from remote machine by connecting to the server)?

    Thanks

    Vankayala

    Like

  3. Thank you Sir..

    Whenever i hit search for any DBA related queries i prefer to read your blog at priority before than any.

    Thanks
    MOMEN

    Like

  4. IT’s very needful info.
    Can you proveide sytemcounters enabling and observing for —-“Log Bytes Flushed / sec”—- in mirro related counter.

    Thank you
    Mallu

    Like

  5. Pingback: SQL SERVER – WRITELOG – Wait Type – Day 17 of 28 | Journey to SQL Authority with Pinal Dave

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s