Execution Plan Splitter — SQLYARD Tools
SQLYARD Free Tool
SQLYARD Tools

Execution Plan Splitter

SSMS chokes on execution plans over 10MB. Paste your plan XML, select which statements to split into separate files, and download valid .sqlplan files you can actually open.

How to use this tool
  • 1
    In SSMS, right-click your execution plan and choose Save Execution Plan As to get the .sqlplan XML file
  • 2
    Open the file in a text editor, select all, and paste the XML into the box below
  • 3
    Click Analyze Plan to detect all statements in the plan
  • 4
    Select which statements to group together, then download each as a valid .sqlplan file
Paste Execution Plan XML
File Size
Statements Found
Batches
Statements Detected — Select Split Points
Each checked statement becomes a separate .sqlplan download