InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 16:24:02 GMT20http://www.sqlservercentral.com/Forums/Topic493192-360-1.aspxAlso, you need to give us some configuration information. The significance of these numbers is heavily affected by how many processors*cores and how many volumes/spindles.Wed, 30 Apr 2008 15:03:26 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic493192-360-1.aspxHave you run a trace to capture the calls coming in to the server? Even if you identify a CPU problem, you need to figure out what's causing the problem.Wed, 30 Apr 2008 13:29:18 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic493192-360-1.aspxYour average CPU time looks good. When your CPU usage goes up to 100%, how long does it stay there for? If you are just seeing spikes up to 100 and then dropping back down right away, this is normal behavior. If you are seeing sustained 100% usage, you've got a problem. Are you seeing poor performance from the application during these high CPU periods?Wed, 30 Apr 2008 12:55:48 GMTJohn Rowanhttp://www.sqlservercentral.com/Forums/Topic493192-360-1.aspxHi,I have problem with my production server, the cpu usage goes to 100% 4-5 times everyday, which is very critical for us. i have taken few counters for a period of 24hrs. can any1 suggest me about the performance issue by looking this statistics.ThanksCOMPUTER Name:Production Average Minimum Maximum Memory: Pages/sec 324.740 0.000 4762.910Physical Disk: % Disk time 160.716 0.183 5275.256Physical Disk: Avg. Disk Queue Length 8.036 0.009 263.763Processor: % Processor Time 24.867 4.363 100.000System: Processor Queue Length 0 0 26SQL Server Buffer: Buffer Cache Hit Ratio99.698 76.514 99.893SQL Server General: User Connections 34 21 66SQL Server General:Transactions 2 0 23SQL Server General:Logins/sec 0.133 0 12.111Wed, 30 Apr 2008 12:44:01 GMTALIF-662928