Post reply

DB server comes to a crawl every two weeks

  • January 3, 2014 at 3:02 pm

    #1677453

    MysteryJimbo (1/3/2014)

    You can export the execution plan from the buffer cache using this dmv. You can find many examples of the queries if you google this dmv.

    http://technet.microsoft.com/en-us/library/ms189747.aspx

    Export the execution plan of a proc now and compare with when performance is slow.

    Assuming your problem is all procs and queries I don't think this is going to make much difference. However it's a good tool for you to have in your arsenal.

    Thanks for the link. I'l give it a go.

    -Todd

Viewing post 16 (of 15 total)

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