Enhance sys.dm_exec_query_plan to accept database_id
This query is very expensive:
SELECT *
FROM sys.dmexecquerystats
CROSS APPLY sys.dmexecqueryplan(s.plan_handle);
This is because sys.dmexecquery_plan() obtains server-wide information.
0
votes
AdminMicrosoft SQL Server
(Product Manager, Microsoft Azure)
shared this idea
Upvotes: 3
<=-=Feb 21 2008 2:14PM=-=>Dear Customer,
Thank you for reporting the issue. We prioritized it and it could not fit on our SQL 2008 schedule. We are tracking it for the next release.
Sincerely,
Yavor Angelov
Program Manager
SQL Relational Engine