Post reply

Re: Collecting read/write stats for multiple database across multiple instances

  • December 25, 2008 at 11:13 am

    #126681

    I have 5 instances of SQL Server running approximately 50 different databases residing on a single hard disk. In the near future, I'd like to add more hard drives for the databases, but I'm unsure how to determine which databases should go on which drives.

    Is there anyway to monitor which database performs the most reads or writes across all instances? In other words, I'd like to be able to order all databases in all instance by read/write stats. Currently, I'm using Performance Dashboard -> Historical IO Report for each instance, but this data is cumulative through the last SQL Server restart.

  • December 25, 2008 at 1:11 pm

    #917665

    How about perfmon data piped into a sql table?


    Shamless self promotion - read my blog http://sirsql.net

  • December 25, 2008 at 3:01 pm

    #917669

    Nicholas Cain (12/25/2008)

    How about perfmon data piped into a sql table?

    What perfmon data would you recommend capturing?

  • December 25, 2008 at 10:03 pm

    #917682

    Dear

    I want to be in this question therefore I m adding this reply.

    THX

    Thanks

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

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