Post reply

Disk Sizing SQL 2005

  • May 25, 2010 at 10:03 am

    #143345

    Hi all

    I am currently going through a migration exercise for placing our applications on a new SAN infrastructure. I am currently performing a capacity planning exercise to try and figure out the disk configuration and sizing.

    I am collecting data using counters such as:

    Avg. Disk Writes/sec

    Avg. Disk reads/sec

    However our transaction log and database files currently reside on the same RAID 5 array. I am obviously wanting to separate these out but how can I gather specific throughput statistics on the T-log and DB files so that I can correctly configure the new RAID infrastructure?

    Thanks

  • May 25, 2010 at 10:31 am

    #1172222

    slightly confusing, so is the question about size or throughput?

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • May 25, 2010 at 10:41 am

    #1172229

    use DMF sys_dm_io_virtual_file_stats, it will give you info on IO activity per database file. good for seeing where the load is.

    this replaced fn_virtualfilestats() in SQL2000, which still works though.

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

  • May 25, 2010 at 10:56 am

    #1172237

    http://www.miracleas.com/BAARF/BAARF2.html

  • May 26, 2010 at 6:21 am

    #1172638

    Hi and thanks for the replies - This thread is primarily about calculating IOPS.

    I have looked at the sys_dm_io_virtual_file_stats and can see the amount of reads and writes. I can write something to calculate the IOPS from this, unless anyone knows of something that has already been written to do this?

    Once I have these stats I can work out peak usage and configure the RAID disk appropriately. If i do this periodically then I can predict a trend for IOPS to determine when we will become disk bound.

    Thanks

  • May 26, 2010 at 8:56 am

    #1172794

    I found this on a thread: IOPS (Disk Reads/sec + Disk Writes/sec)

    http://social.technet.microsoft.com/Forums/en/operationsmanagergeneral/thread/92ad3a22-49fb-4e60-9573-8b6f629cbbe9

  • May 26, 2010 at 9:02 am

    #1172801

    Nice find Steve.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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