Post reply

How do I track transaction activity in SQL 2000 databases?

  • March 26, 2008 at 4:57 am

    #185655

    I need tracking for about 1 week to 1 month without losing any performance to evaluate databases for replatforming. I want to set up servers with heavier transaction volumes balanced across 2-3 servers. I am new to the datacenter environment (previously a developer at another shop) and would like some advice on how transaction volumes can be documented.

    Thanks

  • March 26, 2008 at 9:07 am

    #794115

    Use System Monitor to track counters. SQL Server has a number of them and you can grab user counts, transactions/sec, and anything else that might impact your decision.

    It's really load you're documenting, not just transactions.

  • March 27, 2008 at 4:47 am

    #794504

    Thanks, I will look into System Monitor.:)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply