SQL Server Performance Monitor Counters


As we are aware SQL server has certain counters which can be monitored to have better performance using SQL server. We will try to elaborate on all counters. These are counters we need to monitor on regular basis.

We will see what is meaning of Batch Requests/Sec counter, how to read it from SQL server.

To get a feel of how eventful SQL Server is, observer this SQLServer counter. This counter processes the number of batch demands that SQL Server receives per second, and largely follows in step to how hectic your server’s CPUs are. Usually speaking, over 1000 batch requests per second specifies a very eventful SQL Server, and could mean that if you are not already suffering a CPU bottleneck, that server may very well soon. Unquestionably, this is a comparative number, and the higher your server hardware, the additional batch requests per second SQL Server can serve.

From a network traffic jam approach, a classic 100 Mbs network card is only able to handle about 3000 batch requests per second. If you have a server that is this demanding, you may need to have two or more network cards, or go to a Gbs network card.

Several DBAs use the Transaction/Sec Total to measure total SQL Server commotion, but this is  a bad idea. Transaction/Sec only processes action that is inside a transaction, not all movement, producing crooked results. In its place, continuously use the SQLServer: SQL Statistics: Batch Requests/Sec counter, which events all SQL Server commotion.

One by one we will see all these counters

DBAWorkDatabase support, Database services, Oracle ADF

 

Advertisements

10 Responses to “SQL Server Performance Monitor Counters”

  1. Malia Kingry Says:

    Very Nice Blog, Thanks for sharing, Please continue this, as we have many counters to discuss

  2. As A Software Engineer I have used SQL server for my Java Programming…
    I just had one problem in SQL and that was in retrieving Image File frol Database … If you have any post on how to retrieve Image using Azax from SQL please let me know…..

  3. your wordpress amazing…
    and….thank you have given information which very good for this.

    greet blogger

  4. blogwalking for the day!!!!!!!! cools n nice blogs”””” click here! thanks,,,,,,,,,

  5. Nice Blogs, really use full
    Thank You

  6. This is very nice one, this will help us while creating application in Oracle ADF

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

%d bloggers like this: