Sqlserver.exe is consuming all resources

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Sqlserver.exe is consuming all resources

Author

Topic

pras2007
Posting Yak Master

216 Posts

Posted - 2011-03-17 : 09:52:05

All,

I noticed today that sqlserver.exe has a high CPU Utilization and is consuming a lot of memory based on the “Windows Task Manager”. Below are the specs. on the OS and SQL Server:

OS
- Windows Server 2003
- Standard x64 Edition
- Server Pack 2

SQL Server
- SQL Server 2008
- Enterprise Edition 64 bit
- Service Pack 2 (10.0.4000.0)

Got the following metrics of the server using Perfmon:

Processor
% Processor Time: 92.407

SQLServer:Buffer Manager
Buffer cache hit ratio 99.788
Page reads/sec 1728.422
Total pages 1634156

I don’t know how to resolve this type of issue, does anyone knows how? How can I find out which process is using all the resources on my server?

Please advice.

Thanks.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-03-17 : 09:56:15

It should use the memory that way.

The high CPU is probably a bad query or a missing index.

Run sp_who2 to find what process is consuming the most cpu, or run a profiler trace.

Then you'll need to examine the query/queries in question, for optimization.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources