1
kudos
spam Kudos Remove

Query to obtain every dependent object of a compiled plan when you pass a valid plan_handle in as a parameter
published 732 days, 13 hours, 39 minutes ago posted by sasa 742 days, 1 hour, 29 minutes ago
Saturday, February 06, 2010 12:20:08 AM GMT Wednesday, January 27, 2010 12:30:08 PM GMT
Query to obtain every dependent object of a compiled plan when you pass a valid plan_handle in as a parameter
Every database object will have a sort of dependency between them, such as a stored procedure to run few queries against a table. Similar to this whenever a SP or query is executed then a compiled plan will be generated by the SQL query optimizer, to note about there are two main types of plans in the Object and SQL plan cache stores: compiled plans and execution plans. For every execution context for better optimization such compiled plans are considered valuable memory objects, since they can be...(read more)
category: News | clicked: 1 | | source: sqlserver-qa.net | show counter code
tags: cache, DMV, dynamic, monitor, Performance, query plan, SQL Server, tempdb, TSQL

No comments yet, be the first one to post comment.

To post your comment please login or signup