Post reply

Performance Tuning - Getting the SQL being executed

  • January 31, 2014 at 11:12 am

    #289014

    A short piece that shows how to join back to the DMVs and get the code running for a particular execution plan you think is problematic.

    Set up a scenario, query for an execution plans, get the SQL back from the DMVs so you can tune it.

  • March 18, 2014 at 1:42 pm

    #1698176

    Do you still need something for this? I am working on a script that can be ran continuously (sql agent job) that will monitor executing queries and analyze their execution plan and alert back if anything may need tuning.

    Thank You,

    Nick

  • March 18, 2014 at 2:08 pm

    #1698185

    I do, and I'd love to see a few variations of how to do this in separate articles, but if you have something that's focused on getting the queries that are problematic, that would be great.

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

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