Active transaction counter does not add up

Hi,
I've just started having problems in a SQL 2000 database (W2K, dual cpu) where the database server just grinds to a virtual halt for 5 to 10 minutes then carries on. One thing I have noticed is the system's Total Active Transaction counter is kinda growin
g during the day at about 1 transaction every hour or so but, when I look at the Active Transacions at the individual database level, the Active Transactions are normally zero. The application's database registering 1 every so often (I have Performance Mo
nitor checking every 5 seconds) but all the other, eg tempdb are zero.
How can I find what the details are behind the total active transaction count?
Is there a reason why the total can be different from the individual database active transaction counts?
TIA - Peter
Peter
DBCC LOGINFO(database_id)
If you see tranasction status =2 at the end of the list that means you have
an active transaction (has not been written to the disk yet)
Also , I'd run Profiler to find out a long running queris/stored procedures
..
"Peter Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:72470C20-A20B-4750-8682-A4FCC46CEACB@.microsoft.com...
> Hi,
> I've just started having problems in a SQL 2000 database (W2K, dual cpu)
where the database server just grinds to a virtual halt for 5 to 10 minutes
then carries on. One thing I have noticed is the system's Total Active
Transaction counter is kinda growing during the day at about 1 transaction
every hour or so but, when I look at the Active Transacions at the
individual database level, the Active Transactions are normally zero. The
application's database registering 1 every so often (I have Performance
Monitor checking every 5 seconds) but all the other, eg tempdb are zero.
> How can I find what the details are behind the total active transaction
count?
> Is there a reason why the total can be different from the individual
database active transaction counts?
> TIA - Peter

Active transaction counter does not add up

Hi,
I've just started having problems in a SQL 2000 database (W2K, dual cpu) whe
re the database server just grinds to a virtual halt for 5 to 10 minutes the
n carries on. One thing I have noticed is the system's Total Active Transact
ion counter is kinda growin
g during the day at about 1 transaction every hour or so but, when I look at
the Active Transacions at the individual database level, the Active Transac
tions are normally zero. The application's database registering 1 every so o
ften (I have Performance Mo
nitor checking every 5 seconds) but all the other, eg tempdb are zero.
How can I find what the details are behind the total active transaction coun
t?
Is there a reason why the total can be different from the individual databas
e active transaction counts?
TIA - PeterPeter
DBCC LOGINFO(database_id)
If you see tranasction status =2 at the end of the list that means you have
an active transaction (has not been written to the disk yet)
Also , I'd run Profiler to find out a long running queris/stored procedures
.
"Peter Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:72470C20-A20B-4750-8682-A4FCC46CEACB@.microsoft.com...
> Hi,
> I've just started having problems in a SQL 2000 database (W2K, dual cpu)
where the database server just grinds to a virtual halt for 5 to 10 minutes
then carries on. One thing I have noticed is the system's Total Active
Transaction counter is kinda growing during the day at about 1 transaction
every hour or so but, when I look at the Active Transacions at the
individual database level, the Active Transactions are normally zero. The
application's database registering 1 every so often (I have Performance
Monitor checking every 5 seconds) but all the other, eg tempdb are zero.
> How can I find what the details are behind the total active transaction
count?
> Is there a reason why the total can be different from the individual
database active transaction counts?
> TIA - Petersql

Active transaction counter does not add up

Hi
I've just started having problems in a SQL 2000 database (W2K, dual cpu) where the database server just grinds to a virtual halt for 5 to 10 minutes then carries on. One thing I have noticed is the system's Total Active Transaction counter is kinda growing during the day at about 1 transaction every hour or so but, when I look at the Active Transacions at the individual database level, the Active Transactions are normally zero. The application's database registering 1 every so often (I have Performance Monitor checking every 5 seconds) but all the other, eg tempdb are zero
How can I find what the details are behind the total active transaction count
Is there a reason why the total can be different from the individual database active transaction counts
TIA - PeterPeter
DBCC LOGINFO(database_id)
If you see tranasction status =2 at the end of the list that means you have
an active transaction (has not been written to the disk yet)
Also , I'd run Profiler to find out a long running queris/stored procedures
.
"Peter Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:72470C20-A20B-4750-8682-A4FCC46CEACB@.microsoft.com...
> Hi,
> I've just started having problems in a SQL 2000 database (W2K, dual cpu)
where the database server just grinds to a virtual halt for 5 to 10 minutes
then carries on. One thing I have noticed is the system's Total Active
Transaction counter is kinda growing during the day at about 1 transaction
every hour or so but, when I look at the Active Transacions at the
individual database level, the Active Transactions are normally zero. The
application's database registering 1 every so often (I have Performance
Monitor checking every 5 seconds) but all the other, eg tempdb are zero.
> How can I find what the details are behind the total active transaction
count?
> Is there a reason why the total can be different from the individual
database active transaction counts?
> TIA - Peter