VMware Cloud Community
Chinabee
Contributor
Contributor

Virtualizing a SQL database

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.

Reply
0 Kudos
4 Replies
mcowger
Immortal
Immortal

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

Put TEMPDB & LOGS on the SSD.

Put the actual data on Drive 2

--Matt VCDX #52 blog.cowger.us
Reply
0 Kudos
Chinabee
Contributor
Contributor

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?

Reply
0 Kudos
mcowger
Immortal
Immortal

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

How many drives are behind each LUN?

--Matt VCDX #52 blog.cowger.us
Reply
0 Kudos
Chinabee
Contributor
Contributor

4 drives.

Reply
0 Kudos