how do I bring up the histogram statistics

r_prakaash 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.
Aaron Bertrand 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.
r_prakaash 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.

Aaron Bertrand 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).
Aaron Bertrand 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.
r_prakaash 2016-09-12 16:14:35
Thanks a lot Aaron. I will watch the Webinar.