Ent : SQL Server 2008 SP17
: Windows Server 2008 Ent.Edt
While troubleshooting a performance issue for a Query (SP) I came across this weired thing that the Query Plan handle is not matching
across all the Query related system DMV’s.
Senario with a simple query
For each executing Query a plan handle is generated in sys.dm_exec_connections (Column most_recent_sql_handle).Based on the sql_handle the
View Complete Post