Post reply

chart database usage across time period

  • April 28, 2008 at 8:05 am

    #206807

    I was wondering if anyone could tell me how I could chart the usage of a database based on a time-range.

    The reasoning for this is that I'd like to reschedule our maintenance jobs for when the database will be the least busy, so I'd like to chart each database in the instance over a period of time (a week or so) and then make a decision accordingly.

    I have multiple databases within each instance, and would like to chart them seperately.

    Is there a way to do that with the tools that came with the database, or would I need a third party tool. If so, any suggestions would be helpful.

    Thanks for your help

    --------------------------

    I long for a job where my databases dont have any pesky users accessing them 🙂

  • April 28, 2008 at 8:29 am

    #807823

    the only good ways to track per database are to look at batches/sec and transactions/sec for the database. Most other counters will be for the entire instance.

  • April 28, 2008 at 11:20 am

    #807958

    Thanks Steve..

    I'm logging the transactions/sec from the windows performance monitor.. i didn't see batches/sec in there though? Am I looking in the right place?

    Thanks

    --------------------------

    I long for a job where my databases dont have any pesky users accessing them 🙂

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

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