2
votes
1answer
152 views

Can I restrict how many CPUs SQL Server 2005 uses?

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 ...
0
votes
1answer
109 views

Unusual CPU usage on SQL 2005 Mirror

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 ...
4
votes
1answer
5k views

How can a Perfmon “% Processor Time” counter be over 100%?

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 + ...
1
vote
2answers
604 views

SQL Server 2005 preferring a single core per cpu?

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 ...
0
votes
4answers
3k views

How to find CPU usage for SQL server 2005 database

How to find CPU usage for SQL server 2005 Server