2012-04-27 10:25 AM - edited 2015-12-18 01:19 AM
I've read the most recent Microsoft SQL Server and SnapManager for SQL on NetApp Storage Best Practices Guide (TR-4003), but am still unclear of the the Netapp Volume and VM Datastore configuration for SQL Server VM's using VMDK's. The question is:
There seem to be some conflicting limitations on the VM and Netapp side that have made this a more difficult decision:
2012-04-30 04:08 AM
Hi Mark ,
How many SQL Server instances are you planning to run per VM? The restriction with 64 datastores is gone with ESX 5.0 .So there is a more headroom for drawing the layout architecture.This is not a hard and fast rule to have a datastore dedicated to a single SQL VM .
You can still have multiple datastores for a single VM if there are high number of SQL instances running per VM.
2012-04-30 09:16 AM
Thanks for the quick response. We only run one SQL Server instance per VM.
We are also in the process of upgrading our VMWare environment from v4.1 to v5.0. So, that will help with the datastore limitation.