Subscribe to this blog
Archives: December 2011
View execution plan for a sproc in the wild
Got stored procedure problems? I feel sorry for you son.
Here's a quick query to pull the cached execution plan out of memory.
I italicized cached because it's not going to stay there forever.
I used this query to find the execution plan of a stored proc that had been…
Here's a quick query to pull the cached execution plan out of memory.
I italicized cached because it's not going to stay there forever.
I used this query to find the execution plan of a stored proc that had been…
0 comments, 775 reads
Posted in SQL Tact on 16 December 2011
Open_transaction_count in sys.dm_exec_sessions
This news may be a few months old, but it is worth noting that there is now a column called open_transaction_count in the sys.dm_exec_sessions in SQL Server 2012.
This should put away any need for you to use sys.sysprocesses for session information.
Beware, it can cause an ambiguity in existing…
This should put away any need for you to use sys.sysprocesses for session information.
Beware, it can cause an ambiguity in existing…
0 comments, 336 reads
Posted in SQL Tact on 16 December 2011