Performance Monitor - Shows 4 BILLION Active Transactions ?

[JohnBates]

hi experts,

I have a 2000 Server that is a database server (MS SQL Server).

Rebooted it Sunday. Next day I started PerfMon to monitor several counters.

The Active Transactions counter was approximately 4 billion ! The procedure we were running was running longer than usual (that's why I was using Perf Mon)

I would assume that rebooting the server would reset Active Transactions to zero ?

Just what does the 'Active Transactions' number mean... is it related to the transaction Log?
Anything to be concerned about, from a performance standpoint ?

Thanks. john

 

[JohnBates]

... here is an update.

I ran DBCC OPENTRAN
got "No active open transactions"

also ran SELECT @@TRANCOUNT (shouting at the server
"returned 0"

I'm still thinking the 'Active transactions' refers to data that is still in the transaction log....

 

[Catadmin]

Then do a complete database backup and see if that clears the number for you. It will certainly clear up the Transaction Log.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[JohnBates]

... update # 2

Ran backup log gm WITH TRUNCATE_ONLY
then DBCC SHRINKFILE (gm_log, 101)
Did the above for alll our user DBs + tempdb

Active Transactions was still 4 billion

Then rebooted server.

Now, Active Transactions is 0

Catadmin, do you think these (old ?) Active Transactions can degrade performance ? (in my case, performance has been pretty good)

Thanks, John