Index analysis is not working in my SQL sentry tool , Any experts ?
-
Index analysis is not working in my SQL sentry tool , Any experts ?
-
I've sent a message to someone who works for them. Hopefully you can get some help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Hi muzikfreakster, in order to use Index Analysis, you must generate an actual or estimated plan from within Plan Explorer - this is just one of the many pieces of information we gather for you that won't be present in a standard plan generated from SSMS.
And this is going to sound a little like "there's a hole in the bucket" but as the dialog suggests, in order to generate a plan from within Plan Explorer, you must populate the Command Text area (which doesn't happen by default if you didn't generate the plan in Plan Explorer, depending on the type of plan and how you opened it). You can right-click any statement in the statement grid and choose "Copy Statement (or All Statements) to Command Text" - once there is a valid set of T-SQL in the Command Text pane, you'll be able to generate estimated or actual plans based on those statements.
Or, for best results, just generate your plans from within Plan Explorer from the start, instead of generating them in Management Studio and opening them in Plan Explorer.
Let me know if you have any further issues (abertrand@sentryone.com).
Cheers,
Aaron Bertrand, SentryOne -
Thank you Grant Fritchey and aaron.bertrand
If I see this as the culprit , what can i conclude ?
aaron.bertrand I think SQL sentry tool is nice and i am still exploring . Do you have some nice doc on this tool which i can go through ?
-
I don't have enough information from that screen shot to conclude anything. Can you post the entire actual post-execution plan to answers.sqlperformance.com?
As for resources on learning Plan Explorer, the documentation is here, I built a demo/learning kit here, and Kevin Kline and I published a webinar on the 3.0 features (including Index Analysis) here.
-
aaron.Bertrand Appreciate it 🙂
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply