Hi I read Brad's article: http://www.sql-server-performance.com/2005/sql-server-performance-monitor-coutners/ The batch request per sec on our server is between 8million and 11 million but article states "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" Is the article very far out of date? or am i reading my data wrong? I collect the data fron the table: master .dbo.sysperfinfo I look forward to any advise. Thank you. Akthar
sorry i think the value there that i am looking at in sysperfinfo may be cumulative from the time the sql server was started... if anyone disagrees please advise... Akthar
sysPerfInfo is for SQL Server 2000 only. For SQL Server 2005, please use sys.dm_os_performance_counters. For your point, cntr_value is cumulative in both 2000 & 2005. http://msdn.microsoft.com/en-us/library/ms189806.aspx "... this will be a level or monotonically increasing counter.. " http://msdn.microsoft.com/en-us/library/ms187743(SQL.90).aspx "... this value is cumulative.." Hope this helps.
By the way, Welcome to the forums. (I forgot to welcome you at the last post.) Is this question related to SQL Server 2005? Your last(First) post was in SQL Server 7.0 and 2000 forum and this in SQL Server 2005 forum. But the heading and content refer to 2000. it will help our admins and moderators to move the post to the right place. Regards,
Akthar As suggested by Preethi it matters even the response between 2000 and 2005 version, due to the changes in underlying database engine.
Hi Preethi, Satya, Thanks for your advise. Yes, this is related SQL server 2000 version . Oh by the way, Satya, I attended your Liverpool, SQLBit Session on 'Tricks of Trade - DBA Tools' - i found it valuable. Thanks Akthar
Akthar In thsi case you have to be clear about CPU and Memory associated on thsi SQL instance. Thanks for attending, keep in touch.