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

  • September 27, 2012 at 7:39 am

    #1542899

    D.Post (9/27/2012)

    If you have access to SSMS 2008 you can right click on the instance name and select Activity Monitor.

    This will give you a good place to start troubleshooting.

    I checked current activity, and found that there is a lot of queries for creating of procedures.

    The problem is, that queries should not be executed at all. That stored procedures already exist on server for a long time. No need to run CREATE PROCEDURE query for them at all.

    I have no idea why these queries are executed on the first place :sick:

    So, in certain time, SQL Server executes a lot of same queries for creating of same procedures (procedures already exist on server) and CPU goes 100%.

    The queries which are executed in that time are useless, I don't need them at all, and don't know from where they are coming.

    How that could be possible?