将XML execution plans转换为图形界面GUI

最新推荐文章于 2023-03-09 17:10:09 发布

OnlyQi

最新推荐文章于 2023-03-09 17:10:09 发布

阅读量2.2k

点赞数

分类专栏： SQL Server数据库

SQL Server数据库专栏收录该内容

128 篇文章 0 订阅

订阅专栏

Take your XML execution plan and save it to a file with a file extension of sqlplan (such as MyQuery.sqlplan) and double click on it. It will open in the SQL Server Management Studio and show you the plan in the GUI plan viewer making it much easier to read than the XML version.

很简单但是很巧妙。。。比如用下面的sql查询session的内存使用量时，dm_exec_query_plan

中的query_plan就是xml，读起来很不方便。用上面的小窍门换成图形界面后，就方便多了。

SELECT mg.session_id, mg.requested_memory_kb, mg.granted_memory_kb, mg.used_memory_kb, t.text, qp.query_plan 
FROM sys.dm_exec_query_memory_grants AS mg
CROSS APPLY sys.dm_exec_sql_text(mg.sql_handle) AS t
CROSS APPLY sys.dm_exec_query_plan(mg.plan_handle) AS qp
ORDER BY 1 DESC OPTION (MAXDOP 1)