January 31, 2014 at 11:12 am
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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
March 18, 2014 at 1:42 pm
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
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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply