Post reply

Transaction Count

  • September 25, 2007 at 9:04 am

    #69188

    Hi, I'm a noob just wanting to know how to determine how many transactions a day I have going in and out of my database. I know that's a determining factor on how "busy" my database is.

    Thanks for your response!

  • September 26, 2007 at 2:03 pm

    #736525

    Brian Fischer (9/25/2007)

    Hi, I'm a noob just wanting to know how to determine how many transactions a day I have going in and out of my database. I know that's a determining factor on how "busy" my database is.

    Thanks for your response!

    you could use perfmon and look at the counter SQLServer : Databases( _Total )\Transactions/sec

    Then aggregate the data so that you have an idea of what is the rate and at what time it peaks !

    Hope This Helps

    Cheers,


    * Noel

  • September 26, 2007 at 6:27 pm

    #736571

    Thank you, I will give that a shot.

  • September 26, 2007 at 7:45 pm

    #736577

    Good tip Noeld... got anymore like this one one monitoring the server's level of activity.

  • September 27, 2007 at 4:20 am

    #736657

    Not really good activity meter.

    You can possibly have terribly busy server without a single transaction for a whole day.

    From another side enormous number of simple transaction may take less than 5% of server resources.

    One transaction can take 10sec on 100% server load to complete, and another one may be completed within milliseconds.

    So, what number of transaction say about server activity?

    Nothing, really.

    _____________
    Code for TallyGenerator

  • September 27, 2007 at 8:32 am

    #736754

    Thanks for the clarification. What counters do you use (really asking, I've rarely done that kind of tuning)?

  • September 28, 2007 at 4:12 pm

    #737288

    Thanks for all your replies. I mainly wanted to know how to determine how busy my database is not the server. So I guess the correct question that I should have asked is: How do I determine how busy my database is?

    Thanks again!

Viewing 7 posts - 1 through 6 (of 6 total)

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