November 16, 2011 at 2:04 am
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
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
Thanks a lot, perfect solution 🙂
November 16, 2011 at 6:50 am
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