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 (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – Get Current Database Name
Next Post
SQL SERVER – Introduction to Performance Monitor – How to Use Perfmon

Related Posts

5 Comments. Leave new

  • Hi Pinal,

    Is there any way to get this info using DMV ?

    Reply
  • Thanks for writing and explaining it in a simple way

    Reply
  • Sreedhar Vankayala
    August 16, 2011 2:26 am

    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

    Reply
  • 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

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

    Thank you
    Mallu

    Reply

Leave a Reply

Menu