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
DBAWork, Database support, Database services, Oracle ADF
January 13, 2012 at 6:51 am
Very Nice Blog, Thanks for sharing, Please continue this, as we have many counters to discuss
January 25, 2012 at 10:08 am
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…..
January 25, 2012 at 10:30 am
Thanks for providing a nice topic for a blog. I will let you know when i will drop a article on this.
January 28, 2012 at 7:54 am
your wordpress amazing…
and….thank you have given information which very good for this.
greet blogger
April 25, 2012 at 11:37 am
Thank you … stay tunned for more
February 2, 2012 at 3:57 am
blogwalking for the day!!!!!!!! cools n nice blogs”””” click here! thanks,,,,,,,,,
April 25, 2012 at 11:37 am
thank you
February 6, 2012 at 6:39 am
Nice Blogs, really use full
Thank You
April 25, 2012 at 11:37 am
thank you shradha
November 7, 2012 at 4:07 pm
This is very nice one, this will help us while creating application in Oracle ADF