Home Forums SQL Server 2005 Administering CPU 100%, current queries show "CREATE PROCEDURE ... " RE: CPU 100%, current queries show "CREATE PROCEDURE ... "

  • Restarting SQL is not a good idea as it flushes it's cache and when it restarts has to build the cache again which makes performance worse (usually)

    A good place to start would be here http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ - Chapter 3 High CPU Utilisation.