Post reply

Tracking down re-compiles

  • November 2, 2006 at 2:10 pm

    #117355

    According to performance monitor, one of my SQL Servers has a high rate of compiles, with a significant percentage due to re-compiles.  However, running a trace on the SP:Recompile event shows very few re-compiles.

    For example,

    Perfmon will show 130 compiles / sec with 80% being re-compiles.  If I run a trace and include the SP:Recompile event, I will only see that event fired 2 or 3 times a minute.  I can live with 3 re-compiles a minute.  However, 80-100 recompiles a second deserves my attention. 

    How can I find out what is causing the re-compiles if the SP:Recompile trace event does not show it?

    Thanks,

    Gordon

    Gordon Pollokoff

    "Wile E. is my reality, Bugs Bunny is my goal" - Chuck Jones

  • November 3, 2006 at 4:20 pm

    #669937

    How much of your total SQL load is contained within stored procedures?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • November 10, 2006 at 9:02 am

    #671118

    The application is almost entirely sp based.

    Gordon Pollokoff

    "Wile E. is my reality, Bugs Bunny is my goal" - Chuck Jones

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply