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

  • anthony.green (9/27/2012)


    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)

    It is production server. Users can't login, can't browse website and things become urgent. :unsure: