Add alarm for open database transactions using DBCC OPENTRAN
Sometimes an application hangs & open transaction. If this is not resolved then eventually it will cause the log file to grow and use all the space on the drive, because SQL cannot clear out the committed transactions. Can a new alert be added for open transactions in each database using the DBCC OPENTRAN function?
Enhancement request number SES-17 has been submitted to Development for consideration in a future release of Spotlight on SQL Server Enterprise.