Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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.
