Post reply

Execution plan and SQL_ID

  • March 18, 2009 at 8:31 am

    #132414

    Hi,

    For MSSQLSERVER

    Here is a way to display an history of sql exec plan for a request

    thanks

    best regards

  • March 18, 2009 at 6:41 pm

    #962394

    History is not maintained once the execution plan is removed from the DMV they are not backed up anywhere. You can however make job that polls the data from DMV to to your table.

    Thanks.

    Mohit.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

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

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