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.

Attachments

(Removed Image URL: /PubResEXPORT.nsf/2b87ee90be777fc085257c28006ee4ef/48d8a2c6b39833e2c125734d001606b1/fl_block_5/0.1AD6?OpenElement&FieldElemFormat=gif)


  • Last Revised: August 4, 2007

    Public

    All content © 1992-2007 Schneider Electric


Legacy KB System (APS) Data: RESL187891 V1.0, Originally authored by PhHa on 09/05/2007, Last Edited by PhHa on 09/05/2007
Related ranges: OS & related Third Party PRODUCTS for Power Mangement Systems, System Manager 4.0, System Manager 3.3
Was this helpful?
What can we do to improve the information ?