I have a SQL Server 2005 instance running on a production server. CPU load is relatively low in part thanks to some recent improvements in the code. I'm trying to work out if I could safely reduce the ...
We are running a mirror on SQL Server 2005 SP2 Enterprise edition for a few databases. These are running on VMWare with Server 2008 R2. On the mirror server, I see the CPU go up to 50% for about a ...
The counter, Process(sqlservr)\% Processor Time, is hovering around 300% on one of my database servers. This counter reflects the percent of total time SQL Server spent running on CPU (user mode + ...
HI folks, I've a SQL Server 2005 system, with 4 cpus in it each with 4 cores. It's currently mainly utilising just 4 cores, ie 4 hover around 90% utilisation at peak and the others closer to 30%. I'm ...
How to find CPU usage for SQL server 2005 Server