Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Location
    CA Bay Area
    Posts
    6

    Unanswered: Databases: Active tranzactions (_Total)

    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!

  2. #2
    Join Date
    Jul 2002
    Posts
    229
    Which way do you collect the data?

  3. #3
    Join Date
    Oct 2002
    Location
    CA Bay Area
    Posts
    6
    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
    Attached Files Attached Files
    Last edited by s_vinnik; 11-06-02 at 18:49.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •