SQL Server Performance

What is "best strategy for the following scenario"

Discussion in 'Performance Tuning for Hardware Configurations' started by waqar, Mar 16, 2006.

  1. waqar Member

    Hi,<br /><br />I need guidance for the following scenario.<br /><br />We are shifting our database server from our vendor location to in-house, but what I found they have divided our database into 3 different databases<br /><br />DB1 (images)=120 GB<br />DB2 (text based)=45 GB<br />DB3 (images)=56 GB<br /><br />I tried to restore DB2 at my development computer, it was real pain in my neck when I restore this database (it took me like 4-6 hours).<br /><br />This server is business critical, and I am going to have a standby database server ready (in case if primary server go down I can use this backup server).<br />I have SQL 2000 Standard license for both servers.<br /><br />I would like to know<br /><br />1- What procedure I put in place to make sure my both servers are properly replicating. <br />I have not done any replication procedure before and reading around for replication possibilities. I have read about Clustering (it require Enterprise Server) and find it troublesome, I have also read about log shipping and think it will be more easier than Clustering. I am really not sure and will need feed back from you guys.<br />2- Which technique I can put in place for backup (if I am going to perform full backup every night, it is going to kill my server for number of hours).<br />3- I still have 2-3 weeks before we bring our server in-house, so I still have bit of time to find different strategies.<br /><br />Will appreciate assist from experts here [<img src='/community/emoticons/emotion-1.gif' alt=':)' />].
  2. joechang New Member

    if you config the storage per my rec in the other post, with emphasis on the 2 extra raid controllers plus the embedded controller, ie, 6 scsi channels, and 4 disks per channel on the plug-in, 2+ per on the embedded,

    the backup should run at 400MB/sec+, so total of 200GB backup, 3DB, should take 10min,
    use LiteSpeed to do a compressed backup, the next minor version will have improved restore times.
  3. waqar Member

    Joe,

    You are killing me with your valuable answers [8D].
    I am going to purchase my DELL server as per your advise, I don't have enough funds else I engage you for my setup [:I].
  4. joechang New Member

    if the dell rep asks why don't you go for a shiny new SAN instead of DA storage, tell them what you hear on this site

    its time they own up to the fact they are pushing grossly overpriced HW,
    that performs like crap as far as sequenital IO goes
  5. waqar Member

    Joe,

    I would like to check, how much it can cost me to prepare the server if I follow the setup you have suggested?

  6. joechang New Member

    what do you mean by prepare the server?
    i will probably make some sql scripts available to test the disk
  7. waqar Member

    Mean BUY, sorry for Vague word.
  8. joechang New Member

    its on the Dell website

    PE 2800, 1 dual core, 4GB $3,000
    2nd dual core 1,000
    PERC 4/DC + 7 add 73G 10K 3,000
    additional controllers $800 each
    PowerVault 220S, red pwr sup
    8 73G 10K disks 6,000

    so you are probably looking at 22K,

    i think you will have to call Dell, becuase the online does not let me pick the 2x4 internal drive cage config

    personally, for external storage, i have been buying the Supermicro cases
    $450 for 2x4 disks, additional 1x4 at ~$250, scsi cables $200
    12 disks at $180 each, so 3K per 12 ext disks

    PE2800 + 2 white box storage = $15K
  9. waqar Member

    Hi Joe,

    You said 10 drives at 180$ each.
    Where i can get these drives and what is the type of warrenty?

Share This Page