ESXi

 View Only

  • 1.  Virtualizing a SQL database

    Posted Mar 12, 2012 10:27 PM

    I can't the IOPS from the customer. The SQL database is used by about 100 concurrent users, not heavy transactional database.

    SQL is on Windows 2008 R2, 100GB data file, 50GB log file.

    I have three sets of storage place, what would be the best way to virtualize this?

    Drive 1. SSD drive in RAID 10 but with very limited space, about 200GB total.

    Drive 2. SATA drive in RAID 10, a few TBs

    Drive 3. SATA drive in RAID 5, a few TBs

    What's the best way to structure is so that the customer would get the best performance? Obviously if I fit the DB on Drive 1, it would be the best.



  • 2.  RE: Virtualizing a SQL database

    Posted Mar 12, 2012 10:37 PM

    Without ANY data, this is pretty much a worthless exercise, but:

    Put TEMPDB & LOGS on the SSD.

    Put the actual data on Drive 2



  • 3.  RE: Virtualizing a SQL database

    Posted Mar 12, 2012 10:47 PM

    Can you explain the purpose of doing that? The Drive 2 (RAID 10 SATA drives) would only produce about 300 IOPS. :-(

    Should I put OS and SQL installation files on Drive 2?



  • 4.  RE: Virtualizing a SQL database

    Posted Mar 12, 2012 11:32 PM

    Sorry, for me RAID 10 implies more than 4 disks given your specification of "many" TB.

    How many drives are behind each LUN?



  • 5.  RE: Virtualizing a SQL database

    Posted Mar 13, 2012 03:09 AM

    4 drives.