SQL Server Performance Forum – Threads Archive
CPU usage 50-80%One of SqlServers uses 50-80% of CPU. What can be the reason for it?
It runs on Windows Server 2003, 2 GB RAM, 2.79 GHz.
Memory Usage of sqlserv.exe 1,427,016K.
Web applications, that bases on databases on this server, are very slowly. Any ideas will be appreciated.
http://www.sql-server-performance.com/performance_monitor_counters.asp says Generally speaking, if the total CPU utilization of your server exceeds 80% for continuous periods (over 10 minutes or so), then you may have a CPU bottleneck. Some potential solutions to a CPU bottleneck are to reduce the server load (tune those queries), get faster CPUs, or get more CPUs You have to worry only if it is exceeding the 80%. Do you have dedicated server for sql server? —————————————-
Cast your vote
http://www.sqljunkies.com/Article/7F8518F9-FDAA-4FF3-8FC5-25E8946C8D0C.scuk a good note to what to check and resolve. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.