-
Type:
Task
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Execution
-
None
-
None
-
None
-
None
-
None
-
None
-
None
At the moment, $planCacheStats reports the planCacheShapeHash / planCacheKey, while $queryStats reports the 'queryShapeHash'. As such, there is no way to correlate the information reported by both.
This ticket requests extending $planCacheStats to include the top N queryShapeHash values for each plan cache entry (where 'N' can be some constant like 5 or 10). How we decide what the 'top N queryShapeHashes' are is an open question, but it should be relatively cheap to do.
The ability to correlate these two sources would provide insight into what data access plans are used to answer which queryShapes.