Tuesday, March 20, 2012

Active Transactions on Performance Monitor for SQL Server DATABASE

I am running Performance Monitor and it says that for the
SQL SERVER:DATABASE (Active Transaction) I have for
_TOTAL = 4,300,000,000
yet for all the individual databases, they all are 0 or 1 during any given
second and I only have 8 databases. Shouldn't the _Total add up to all the
individual Database?
Please adviseAnswered my own question with a little digging..
http://support.microsoft.com/defaul...Ben-us%3B841401
"Jason Greene" wrote:

> I am running Performance Monitor and it says that for the
> SQL SERVER:DATABASE (Active Transaction) I have for
> _TOTAL = 4,300,000,000
> yet for all the individual databases, they all are 0 or 1 during any given
> second and I only have 8 databases. Shouldn't the _Total add up to all th
e
> individual Database?
> Please advise

No comments:

Post a Comment