Monday, March 19, 2012

Current activity shows lots of SPID with open transactions...yet DBCC open tran shows no a

Anyone know why this is?
SQL Server 2000 sp3a.
There are about 200 spids in the database that show an open
transaction in the current activity window.
Yet, when I run a dbcc opentran on the database, it says no active
transactions.
An open transaction is one that has not yet commited correct? So
shouldn't it show up in DBCC opentran?
Thanks for any input."Sanctus" <mchi55@.hotmail.com> wrote in message
news:1175796327.218453.112050@.p77g2000hsh.googlegroups.com...
> Anyone know why this is?
> SQL Server 2000 sp3a.
> There are about 200 spids in the database that show an open
> transaction in the current activity window.
> Yet, when I run a dbcc opentran on the database, it says no active
> transactions.
> An open transaction is one that has not yet commited correct? So
> shouldn't it show up in DBCC opentran?
How are you determining the 200 Spids have open transactions?
Note that you may have 200 CONNECTIONS, but they may not be doing anything,
or they're doing very short transactions so you never get a chance to see
them with DBCC OpenTran.
> Thanks for any input.
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

No comments:

Post a Comment