bartread/getexecutionplanforhandle.sql

Created January 4, 2017 07:42

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/bartread/29de7896f062ba840db05cd3606ec4e2.js"></script>
Save bartread/29de7896f062ba840db05cd3606ec4e2 to your computer and use it in GitHub Desktop.

Download ZIP

Get XML execution plan for plan handle

Raw

getexecutionplanforhandle.sql

	USE master;
	GO
	SELECT * FROM sys.dm_exec_query_plan (YOUR_PLAN_HANDLE_HERE);
	GO

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment