how do I bring up the histogram statistics

how do I bring up the histogram statistics on the index Analysis

avatar image By r_prakaash 1 asked Sep 12, 2016 at 04:16 AM
more ▼
(comments are locked)
avatar image r_prakaash Sep 12, 2016 at 03:45 PM

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.

avatar image Aaron Bertrand ♦ Sep 12, 2016 at 03:47 PM

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.

avatar image r_prakaash Sep 12, 2016 at 04:02 PM

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.

avatar image Aaron Bertrand ♦ Sep 12, 2016 at 04:05 PM

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).

10|10000 characters needed characters left

1 answer: sort voted first

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.

avatar image By Aaron Bertrand ♦ 1.7k answered Sep 12, 2016 at 03:31 PM
more ▼
(comments are locked)
avatar image r_prakaash Sep 12, 2016 at 04:14 PM

Thanks a lot Aaron. I will watch the Webinar.

10|10000 characters needed characters left
Your answer
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x641
x455
x24

asked: Sep 12, 2016 at 04:16 AM

Seen: 90 times

Last Updated: Sep 12, 2016 at 04:14 PM