sqlservr.exe hogging CPU - SQL Server Forums

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 2000 Forums

SQL Server Administration (2000)

sqlservr.exe hogging CPU

Author

Topic

ianpotts
Starting Member

4 Posts

Posted - 2005-12-05 : 13:46:24

Hi,

I have a sqlservr.exe process that is using 60 - 100% of CPU. Eventually it cause loss of connection to DB.

Any Ideas?

Thanks
Ian

Kristen
Test

22859 Posts

Posted - 2005-12-05 : 14:59:58

Find what particular query is hogging the CPU, and see about reducing the effort it takes.

Also check if it is actually CPU bound, or thrashing the RAM or Disks, or if the CPU activity is genuinely SQLSERVR.EXE or something else.

Kristen

activecrypt
Posting Yak Master

165 Posts

Posted - 2005-12-06 : 00:23:16

Hi,
Ensure
1). Latest SP is their
2). Installed latest Hot Fixes
3). Latest MDAC version is their
4). Run Profiler against a long running SP/T-SQL or T-SQL with a complex calculation

:-)
Regards

Andy Davis
Activecrypt Team
--------------------------------------------
SQL Server Encryption Software
http://www.activecrypt.com

Kristen
Test

22859 Posts

Posted - 2005-12-06 : 03:40:33

"1). Latest SP is their"

I would suggestion caution on installing SP4 unless proper testing has been performed. SP4 changed the way that the query plan is generated in some instances, and this can make some queries perform FAR worse. Admittedly this only applies to poorly formed queries, although the first you may know that you have a "poorly formed query" is when performance takes a nose dive after installing SP4

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources