How to check the memory allocated/requested by a SQL query to execute in spotlight?
说明
User is looking for output of this query in Spotlight: SELECT mg.granted_memory_kb, mg.session_id, 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)
解决办法
Product change included in the current release of Spotlight on SQL Server Enterprise. Latest version of Spotlight can be downloaded from here.
