SQL Server Performance

Batch Requests/Sec??

Discussion in 'Performance Tuning for DBAs' started by pchee373, Sep 27, 2005.

  1. pchee373 New Member

    I know that this is a very general question and that it would depend on alot of other variables. What is the maximum batch requests/sec for SQL Server before it starts acting up. Based on a quad p4 Xeon 4GB RAID10 with 15k drives?

  2. satya Moderator

    http://www.sql-server-performance.com/performance_monitor_counters_sql_server.asp<i><br />To get a feel of how busy SQL Server is, monitor the SQLServer: SQL Statistics: Batch Requests/Sec counter. This counter measures the number of batch requests that SQL Server receives per second, and generally follows in step to how busy your server's CPUs are. Generally speaking, over 1000 batch requests per second indicates a very busy SQL Server, and could mean that if you are not already experiencing a CPU bottleneck, that you may very well soon. Of course, this is a relative number, and the bigger your hardware, the more batch requests per second SQL Server can handle. <br /><br />From a network bottleneck approach, a typical 100Mbs network card is only able to handle about 3000 batch requests per second. If you have a server that is this busy, you may need to have two or more network cards, or go to a 1Gbs network card. <br /><br /><br />Some DBAs use the SQLServer<img src='/community/emoticons/emotion-2.gif' alt=':D' />atabases:Transaction/Sec:_Total to measure total SQL Server activity, but this is not a good idea. Transaction/Sec only measures activity that is inside a transaction, not all activity, producing skewed results. Instead, always use the SQLServer: SQL Statistics: Batch Requests/Sec counter, which measures all SQL Server activity. [7.0, 2000] Updated 4-16-2004<br /></i><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>

Share This Page