SQL Server Performance

Do i create Multiple array for different Tasks?

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by waqar, Mar 5, 2007.

  1. waqar Member

    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.
  2. waqar Member

    no one [<img src='/community/emoticons/emotion-6.gif' alt=':(' />].<br /><br />________________________________________________<br />Be great in act, as you have been in thought.
  3. joechang New Member

    i talk about file placement in the top post
    it is a long post.
    but a litte knowledge can be dangerous
  4. waqar Member

    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.
  5. joechang New Member

    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
  6. waqar Member

    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.
  7. joechang New Member

    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

Share This Page