Technical FAQs

Ask a Question

Microsoft SQL 2000 Server is taking 100% of the CPU

Goals and Symptoms

The Microsoft SQL server service is using 100% of the CPU process and the computer is running slow. If the computer is rebooted everything will appear to run fine for a while and then the SQL process is back at 100%.

Causes and Fixes

This is caused by the Slammer Worm that affects computers with SQL 2000. This worm does not destroy data, it is just nuisance. It is designed to make SQL server eat up all of the CPU. To resolve this issue applying Microsoft's SQL Server Service Pack 3 or later.

Was this helpful?
What can we do to improve the information ?