Post reply

Writes and reads

  • November 16, 2011 at 2:04 am

    #260047

    Hi there, me again 🙂

    Can someone maybe help me out with a script to determine if there are more writes or reads on the DB files?

    I know in most cases the log files have more writes than reads, but what of the db's?

    I need to scope for the perfect RAID combination. If db's have more reads than writes I would go for RAID 5 for databases and RAID 1 for Logs (If possible RAID 10).

    Thanks in advance

  • November 16, 2011 at 3:05 am

    #1408319

    Have a look at sys.dm_io_virtual_file_stats. It has all the information that you are asking for.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • November 16, 2011 at 6:04 am

    #1408423

    Thanks a lot, perfect solution 🙂

  • November 16, 2011 at 6:50 am

    #1408464

    Okay, so now (as expected), the databases have more reads whereas the logs have more writes.

    Tempdb is under alot of strain though.

    The only problem is, I need to find the best possible RAID solution for only 6 hdd's 🙁

    Budget does not allow a SAN, so I have to make use of 6 drive bays.

    The only best solution I can think of is:

    OS - RAID 1

    DB's - RAID 1

    Logs - RAID 1

    Would have loved to configure db's for RAID 5, but then we need 7 bays 🙁

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

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