Only one of the Selected Operations populates Index Analysis Grid and Histogram

phaje 2017-02-16 03:23:26

Just updated to the latest version of SQL Sentry Plan Explorer and pasted a query into the Command Text window and clicked Get Actual Plan. When I went to the Index Analysis tab there were several Clustered Index Seek and Clustered Index Scan operations shown in the Selected Operation dropdown, however only one of them (Node 24) populates the grid and histogram. Choosing any other operation blanks out the grid and histogram.

/storage/attachments/1864-tmpB566.pesession
phaje 2017-02-16 04:57:33
Okay, just noticed that underneath the dropdown there is a label that is almost the same as the text in the dropdown except instead of having the Node number in brackets at the end it has the number of Indexes. Node 24 says one index and all the rest say zero. (The others are all relating to the subscriber-end of a replicated database and the default for replication is not to replicate non-clustered indexes.)

I guess there is a bit of a perception issue here – in SQL Server Management Studio if I expand out the Tables' Indexes branches it shows the Primary Key, e.g. PK_xyz (Clustered), but SQL Sentry Plan Explorer doesn't seem to "count" that one. Is it not a "real" index?

Aaron Bertrand 2017-02-22 20:09:00
Actively investigating… can you verify what version of Plan Explorer you are using (Help > About)? This has to do with cross-database queries, and there is an active work item around this.
February 16, 2017
No Comments