Home / server / Questions / 25731
Accepted
ConcernedOfTunbridgeWells
Asked: 2009-06-16 01:36:33 +0800 CST

Is there a data dictionary view that allows one to monitor log usage by Process ID?

  • 772

What (if any) data dictionary views on SQL Server 2005 allow one to monitor log space usage on active queries by Process ID?

sql-server sql-server-2005 logging

1 Answers

  1. Best Answer

    I'm not aware of features in data dictionary. There are 3rd party tools which will read the transaction log real-time. Years ago I used a 3rd party tool, Log Explorer, to determine processes consuming log space. Looks like ApexLog does the same thing, but I haven't tried it.

    • 1