how do I bring up the histogram statistics
2016-09-12 04:16:19
how do I bring up the histogram statistics on the index Analysis
r_prakaash 2016-09-12 15:45:12
Hi Aaron, Thanks for your quick reply. It says unable to collect execution plans because Command Text is empty. I actually loaded the query from the ssms in the first place.
2016-09-12 15:47:33
You can right-click the statement in the Statement tree and select "Copy Statement to Command Text." Or just create a New Plan Explorer Session, copy your query from Management Studio, paste it into the Command Text window, and generate a new Actual Plan.
2016-09-12 16:02:53
Got it. Thanks again. coming back to my original question. though I was able to bring up the index analysis, I am still not able to pull my histograms. any button or it works only on a particular scenario may be?
BTW, This tool really have made my impressions very high on SQL Sentry overall as a management tool. It is something unbelievable for a company to release such a useful product free of cost. I will certainly recommend this to my business.
2016-09-12 16:05:41
Have you had a chance to watch the webinar? In order to see a histogram, you need to tell us which histogram you want to see (we can't show them all at once). So you need to go to the Index Analysis tab, select an index-related operation in the drop-down, and then select either an index or a column. Then you will see the histogram for that column (or the leading key in the index).
2016-09-12 15:31:04
In order to capture Index Analysis data, you need to generate an actual or estimated plan from within Plan Explorer. If you open a plan captured from SSMS, or from an older version of Query Analysis, that data is simply not there to view.
2016-09-12 16:14:35
Thanks a lot Aaron. I will watch the Webinar.