The Longest Running Version Store Transaction (Minutes) alert provides the time in minutes that the longest version store transaction is open and preventing version store cleanup. This alert occurs only on instances running SQL Server 2005 or above.

This alert is raised based on the diagnostic data collection interval specified in Server Properties. For more information, see Set general server options.

SQL  Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >