How to eliminate the parsing time of a SP

  • One of SP getting more time to parase

    SQL Server parse and compile time:

    CPU time = 38687 ms, elapsed time = 40321 ms.

    How to eliminate the parasing time and what are the ways I can able to find the reason behind the parsing time.

    ?

    Thanks in advance

  • Compile time is a result of resources available and the complexity of the query. The more complex the query, the longer it will take. Also, if the query is in use, a recompile will be blocked until execution completes.

    A lot more information would be needed to help you out with this one.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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