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:42 am

    #1542901

    GilaMonster (9/27/2012)

    The stored procedures are not being recreated. They're being executed.

    Find the worst performing code, tune it. Repeat until performance acceptable.

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    Gila,

    thanks for replay.

    Website is using procedures for showing data, that part works OK.

    The problem is that current queries are scripts for creating procedures, not for executing them.