0
votes
0answers
23 views

Virtual MS Sql Server not consuming enough CPU [migrated]

We have a Win2008 server 32 bit running as a virtual machine under ESX server. It has 6 CPU cores of 2Gz each and 4GB ram. It's running MS Sql Server 2008 R2 only. Problem: The server is heavily ...
1
vote
1answer
116 views

Will more memory help my CPU-peaking SQL Server 2008 R2

I'm supporting a system running against a SQL Server 2008 R2. The server is a single-CPU box with 8 GB of memory. As traffic has increased, the server has started saturating, peaking to 100% CPU ever ...
6
votes
5answers
1k views

SQL Server suddenly using only a small portion of CPU

We've got a Windows 2008 R2 server running SQL Server 2008. All of a sudden, the SQLServer process is refusing to go above 20% CPU usage. As of last week, when running a heavy query against the db it ...
0
votes
1answer
108 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
3answers
1k views

Can a SQL Server have a CPU bottleneck when Processor Time is under 30%

Is it in principle possible for the CPU to be the bottleneck on a SQL Server if the Performance Counter Processor:Processor Time is constantly under 30% on all cores? Or does low Processor Time ...
1
vote
1answer
41 views

How fine grained of an association can I make between SQL Server log files and CPU?

On a multi cpu, multi disk, server, I am looking to associate CPUs with particular log files. I am wondering if is possible, and how, to dedicate CPU power to specific log file work, in SQL Server ...
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