Unsolved
This post is more than 5 years old
56 Posts
0
416
April 12th, 2011 07:00
running SQL in a vm on vnx
We currently run about 8 SQL servers on ESX with a CX3-40 backend.
I have the OS and backup drives in my "general" meta lun 2x5 raid 5 disks.
I tempdb,datadb, and logs on different raid groups, but all 8 SQL servers are using the same Raid groups.
Its working well, but I'm getting a VNX soon and I was reading about the storage pools, I wondering if I should stop dedicating drives to SQL and just use storage pools with FAST. I'll have SSD,15k and NL-SAS available.
OF the 8 SQL servers non are what I'd call high use, maybe 3 are mid tier and the rest are low usage.
Looking for feedback on what others are doing.
thanks,jb
No Events found!
Julien_LECORRE
92 Posts
0
April 18th, 2011 02:00
Hi,
I was on the case for a customer. It depends on which approach you prefer ease of use or performance.
My customer want easy configuration and just want and "private cloud" approach with different kind of SLA.
In my case it works well. Separate datafile from redo is still the best practice regarding the different white paper.
Please take a look at this thread https://community.emc.com/thread/116781.
My 2 cents is that if you have only SQL Servers in your environnement you should use 2 pool. One for Datafile with FAST [SAS -NLSAS - EFD SAS] R5 and one for redo with EFD or FC drive in R10.