My SQL Server 2005 is installed in Windows Server 2003. CPU usage is always 90-100%. If more users connect to this SQL server using their local Management Studio, then the server will become very slow. Can you please tell me how to decrease CPU usage on this SQL Server – is there a step-by-step process you can share?
March 16, 2008 10:26 PM
March 16, 2008 11:29 PM