topic sqlservr.exe hogging database CPU in Windows Server 2003

sqlservr.exe hogging database CPU

Elko — Tue, 16 Mar 2010 10:37:25 GMT

Hi,
I have windows 2003 + mssql2005 installed on server and sqlservr.exe is hogging my server cpu.

Service pack is installed, antivirus is up to date ( Symantec ) ...any hint is more than welcome

Thank you in advance,

Best regards,
Elko

Re: sqlservr.exe hogging database CPU

Prokopets — Wed, 17 Mar 2010 05:52:43 GMT

1. Maybe database heavily loaded? Or, database ir incorrectly written (i.e. stored procedures, etc)
2. Antivirus + SQL Server=Bad idea. Try temporarily disable your antivirus.

Re: sqlservr.exe hogging database CPU

Elko — Wed, 17 Mar 2010 06:38:50 GMT

It is not big database cca 5 GB and cca 20000 records, nothing big... I think I do not have virsus as Symantec ( I hope it is correct report ) does not report anything.

How do you mean, antivirus+mssql = bad idea, what to install on DB as protection ...it is windwos :):)

Thank you for reply

Best regards,
Elko

Re: sqlservr.exe hogging database CPU

Prokopets — Wed, 17 Mar 2010 06:56:56 GMT

If you insist to use antivirus at least try to exclude the sql data and logs folder from antivirus checking.

Re: sqlservr.exe hogging database CPU

Elko — Wed, 17 Mar 2010 12:54:29 GMT

Thanks, will do it.

Regards,
Elko