my server is having some performance issue. i have capture the performance log and run with PAL, these are very great tools. but i need to find the article which describe the threshold for the performance counter. example, if processor % usage is more than 75% is consider critical, if > 60 % is less critical, if < 45% it is running optimal speed etc.. i need some microsoft article that spell out the performance counter. thanks.

Hi, I suggest you refer to the following articles to analyze your performance data: Understanding Perfmon Counters while troubleshooting SQL Server Performance Issues http://blogs.technet.com/b/vipulshah/archive/2006/11/30/understanding-perfmon-counters-while-troubleshooting-sql-server-performance-issues.aspx Interpreting CPU Utilization for Performance Analysis http://blogs.technet.com/b/winserverperformance/archive/2009/08/06/interpreting-cpu-utilization-for-performance-analysis.aspx Analyzing Storage Performance http://blogs.technet.com/b/cotw/archive/2009/03/18/analyzing-storage-performance.aspx Thanks. This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi, Do you need any other assistance? If there is anything we can do for you, please let us know. Thanks. This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.