| Brian Moran 2002-11-11, 11:23 am |
| Are you familiar with DBCC OPENTRAN?
Displays information about the oldest active transaction and the oldest
distributed and nondistributed replicated transactions, if any, within the
specified database. Results are displayed only if there is an active
transaction or if the database contains replication information. An
informational message is displayed if there are no active transactions.
--
Brian Moran
SQL Server MVP
SQL Server Magazine Columnist
"Diane Lewis" <lewisdm@maritz.com> wrote in message
news:67d701c2899f$7d01cab0$35e
f2ecf@TKMSFTNGXA11...
> I am looking for a way to identify the longest running
> transaction -- ie the process that has held log space in
> either tempdb or a database for the longest amount of
> time.
|