MS SQL Server 2000:
When I collected performance data about the active tranzactions counter of my SQL server I found that (_Total) instance is very large (>9999999999999) and is not equal to the sum of the partial instances by DBs.
I have SP2 and all security patches installed.
What's wrong?
Thanks!Which way do you collect the data?|||Originally posted by Coolberg
Which way do you collect the data?
As usual:
Programs=>Administrative tools=>Performance=>Performance Logs and Alerts=>Counter Logs=>New Log Settings=>Name=>Add=>SQLServer: Databases=>Active Transactions+Total=>Add=>Start
