If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Microsoft SQL Server > Databas I/O shared RAID 10 vs single disks

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-19-12, 02:20
bissa bissa is offline
Registered User
 
Join Date: Aug 2012
Posts: 2
Databas I/O shared RAID 10 vs single disks

Hello,
I'm currently hosting a game server with the current specification
E1230
32GB Ram
2x 1Tb SATA
Windows 2008 server
SQL Server 2012
Databse size is 10Gb
Number of players 1k

- The problem at first I had I/O bottleneck with 2x1Tb as I was using the default SQL configuration and all the files .mdf and .ldf were stored in default C:/SQLSERVER
- Then I added 2 more 1 Tb disks and I isolated .mdf and .ldf and TempDB locations. Problem has been fixed and I/O is performing well.
- Now I have the opportunity to change the disks system to 4x 300GB SAS in HW RAID 10, the problem I'm limited to 4 Disks 1 Array only, so I will have to store mdf, ldf and tempdb files in the same array and not isolated.
- Will I have I/O issue with this configuration? it will be better than 4x single HDD's which every physical HDD contains mdf, ldf, and tempdb files which I already use at the moment without issue or performance could be worse with shared 4x SAS 300GB RAID 10?

Thank you
Reply With Quote
  #2 (permalink)  
Old 08-21-12, 16:38
rdjabarov rdjabarov is offline
Registered User
 
Join Date: Jul 2003
Location: San Antonio, TX
Posts: 3,634
It all depends on capabilities of your controller. As you know, the IO performed by kernel threads is only up to the controller, where the latter takes over. With RAID-10 it knows it has at least 3-layered queue (two for mirror and one for stripe). Logically it all bottles down to the controller's cache size, which in turn dictates the size of each queue, plus configuration options if such are available (READ vs WRITE).
__________________
"The data in a record depends on the Key to the record, the Whole Key, and
nothing but the Key, so help me Codd."
Reply With Quote
  #3 (permalink)  
Old 08-21-12, 19:40
bissa bissa is offline
Registered User
 
Join Date: Aug 2012
Posts: 2
Controller is LSI 9260 and the disks are 15k RPM version.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On