Cumulative update informationThis issue is fixed in the following updates:
- Cumulative Update 8 for SQL Server 2014 SP1
- Cumulative Update 1 for SQL Server 2016
- Cumulative Update 2 for SQL Server 2012 Service Pack 3 (SP3)
- Cumulative Update 11 for SQL Server 2012 Service Pack 2 (SP2)
SELECT * FROM sys.syslockinfo L, sys.dm_tran_active_transactions T WHERE L.[req_transactionUOW] = T.[transaction_uow]
How to enable trace flag 3924
You can enable trace flag 3924 at startup or in a user session. This trace flag has either global-level or session-level effects. To enable trace flag 3924, use the DBCC TRACEON command or use –T 3924 as a startup parameter.
If DBCC TRACEON\TRACEOFF is used, this does not regenerate a new cached plan for stored procedures. There could be plans in the cache that were created without the trace flag.
For more information about how to enable or disable trace flags and about global and session-level trace flags, see the following topics in SQL Server Books Online:
Article ID: 3145492 - Last Review: Aug 16, 2016 - Revision: 1