Overview
Graphical Plans can be saved for later use by saving them in an XML format for future analysis.
Explanation
To save the Graphical Query Plan you can right-click in the Execution Plan window and select Save Execution Plan As… or you can select Save Execution Plan As… option from the File menu. These files are typically saved with a .sqlplan extension.
You can also look at the Query Plan in XML format using the Show Execution Plan XML… as shown below.
To open a previously saved XML formatted Query Plan in Microsoft SQL Server Management Studio from the File menu select Open… -> File and open the .sqlplan file that you saved.
Additional Information
- How to: Save an Execution Plan in XML Format article on MSDN
I am a technical and business professional based in Budapest, Hungary. I am working in the financial industry on the operations side, but also have test management experience in the educational software domain. My experience includes Microsoft SQL Server 2000-2012, IBM DB2 and MySQL database administration, troubleshooting, migration and development. My focus points are performance tuning and security. I am passionate about sharing my knowledge with the greater audience.
I hold MSc degree in Engineering and Management. I am married and I have a beautiful daughter.
LinkedIn account:
http://www.linkedin.com/in/nagytibor
Twitter account:
https://twitter.com/#!/tnagy_eeft