Discussion concerning the free SQL Sentry Plan Explorer
11/24/2011 4:01:41 PM
Gokhan
Posts: 9
|
Partition information missing from actual query plan, I can get the information from SSMS (how many partitions are affected and how many partitions there are), I was not able to find the information in the tool.
ThHank you
|
|
0
• permalink
|
11/28/2011 3:35:49 PM
Jason Hall
Administrator
Posts: 88
|
Hi Gokhan,
Thank you for bringing this to us.
I was hoping you might be able to send some examples of the functionality you're referring to in SSMS, along with a copy of the actual plan to support at sqlsentry.net.
We would like to look into the specifics of your request, and the best way to do that will be to actually see what you are seeing.
|
|
0
• permalink
|
11/28/2011 5:29:59 PM
Gokhan
Posts: 9
|
I attached the execution plan and screenshots showing partition info.
|
|
0
• permalink
|
11/29/2011 10:00:57 AM
Jason Hall
Administrator
Posts: 88
|
Gokhan,
Thank you for the additional information.
I'm having our product team look into getting it into a future release of Plan Explorer.
|
|
0
• permalink
|
11/29/2011 3:37:39 PM
GregGonzalez
Moderator
Posts: 145
|
I wanted to point out that we do show the "Partitioned" value on both the Plan Tree and Top Operations tab grids, just not in the tooltips. We'll be adding partition count and range info to both soon.
Greg Gonzalez
SQL Sentry
|
|
0
• permalink
|
11/29/2011 5:03:58 PM
Gokhan
Posts: 9
|
Cool, I still was not able to find actual partition count per table. Let's say the table has 100 partitions but the query only need to scan 2 of them, where do I see that value?
|
|
0
• permalink
|
1/20/2012 11:58:19 AM
GregGonzalez
Moderator
Posts: 145
|
UPDATE: "Partition Count" and "Partition Range" values are now shown in the tooltips, the Plan Tree grid, and the Top Operations grid for associated operations.
This was added in build 6.4.933, now available for download.
Greg Gonzalez
SQL Sentry
|
|
0
• permalink
|