Do i create Multiple array for different Tasks? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Do i create Multiple array for different Tasks?

Hi, I am using PowerValut 220s as single RAID 5 array.
It is working well but speed slow down when i pump 30~40k records from text file in database and do a number of process before it reach to final stage. I am thinking to break PowerValut single raid to 2 RAIDS (using Single RAID controller but separate Channels). Planning to put One array to access static data and other raid to only process imports (inventory import) etc. Does this scenario will work as,
If my 2nd Raid is using full Disk queue does it mean queries performed on 1st Raid will act normal or there will be delay in response? ________________________________________________
Be great in act, as you have been in thought.
no one [<img src=’/community/emoticons/emotion-6.gif’ alt=’:(‘ />].<br /><br />________________________________________________<br />Be great in act, as you have been in thought.
i talk about file placement in the top post
it is a long post.
but a litte knowledge can be dangerous
Joe, Thank you very much, i am reading your article.
I am thinking to buy 36GBx15kRPMx36Drives for my database.
Can you advise any external cage manufacturers which can hold 12/15 scsi drives? ________________________________________________
Be great in act, as you have been in thought.
i would strongly suggest SAS over SCSI Dell is cheapest from Tier 1 OEM in US, not sure about Singapore
Dell periodically has 25% discount on the storage even for the usage you described above,
i think best is to split each array into multiple partitions
database data on one, tempdb on another, and your flat files and backups on the third always check pricing on both 36G and 73G 15K drives, if the differential is small, you might go 73G

Joe Thanks,<br /><br />I read your article (first post) and was thinking to make similar structure but with only 3 external storage (cost issue <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />).<br />I am preparing this hardware for my client in US.<br />I was calculating 73GB(15K RPM – PowerVault MD 1000 SAS/SATA Storage) and it is costing about 8.5K per unit. I will try to call and negotiate for 3 units.<br />But before that i need to confirm if i can insert 3 more dual channel RAID cards in my POWER-EDGE 2850. My SAS knowledge is almost beginner <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />.<br /><br /><br />________________________________________________<br />Be great in act, as you have been in thought.
the MD1000 does work with the PE 2850 make sure you have the PCI-E + PCI-X riser card, not the PCI-X riser card
the first has 1 x8 and 1 x4 PCI-e slots so you will want to get 2 PERC/5E cards,
attach 2 MD1000 to the PERC/5E in the x8 slot
attach 1 MD 1000 to the one in the x4 slot call your Dell rep too