[BUG] Retrieved from Cache

[joshdbe]

Component

Desktop App (Windows)

SQL Performance Studio Version

1.1.0

Operating System

Windows 11

Describe the Bug

It seems to be reporting "Retrieved from Cache": False for all my queries, even when the plans have been cached and when they've been run exactly the same in SSMS (and have the same hash, plan handle, etc.) and SSMS shows them as cached.

Steps to Reproduce

1. Open PlanViewer.App
2. Click on Query Store
3. Pick any from the list
4. Click on Select
5. In properties window > Scroll down to Statement Info section

Expected Behavior

Retrieved from Cache should be True

Actual Behavior

Retrieved from Cache should shows False

Plan File

No response

Screenshots

[erikdarlingdata]

Thanks for the great bug report, @joshdbe! You were right — this was a parsing bug.

RetrievedFromCache is an attribute on the <StmtSimple> XML element, but the parser was reading it from the child <QueryPlan> element where it never exists, so it always defaulted to False.

Fixed in PR #89 (one-line fix in ShowPlanParser.cs). Will be in the next release.

[joshdbe]

Thank you for a prompt response.