how sql sentry assist me for performance stored procedure?

nhmidi 2014-09-19 15:36:51

Aaron Bertrand 2014-09-19 16:00:29
Plan Explorer presents quite a bit of information about where to look for potential optimization. Unfortunately it's difficult for anyone else to translate these indicators to anything specific because you've anonymized the plan – this means we don't really understand any of the tables involved nor can we see the text of any of the statements involved. It's also an estimated plan from the looks of it, which is missing many key runtime metrics. Any chance you could upload an actual, post-execution plan that is not anonymized?