Hi, Im trying to troubleshoot an SQL 2005 server which has sqlsrvr process @ 100%. Any Ideas?

Posted on 2011-10-14
Last Modified: 2012-05-12
Server 2003, Sql Server 2005 Process is constantly running @ 100%, and looking for some troubleshooting tips.  Thanks!
Question by:sarasotamac
    LVL 17

    Accepted Solution

    Firstly, check to make sure you don't have the SQL Slammer virus on your machine.  Highly unlikely, but not impossible.

    You will need to use SQL Server Management Studio - Log onto your SQL Server, and then expand "Management" and then double-click "Activity Monitor".

    You will see a whole bunch of Processes.  Things which are "AWAITING COMMAND" can be ignored, but hopefully you will see which process is taking up all the CPU - what host is causing it, and if you double-click the whole line, it will show you the command.  You can also kill the process to ensure that the CPU drops down back to normal.  If new processes spawn, then you may need to block the database user temporarily, or even take the affected database offline so that it doesn't interfere with other operation.

    SQL 2005 Activity Monitor
    If you do not have SQL Server Management Studio installed, please install it.  For SQL Express, use the SQL Server Management Studio Express.
    LVL 6

    Author Closing Comment


    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now