Hi Community,
are there any recommendations regarding the NetApp storage LUN layout for a MS SQL Server?
I have not found anything in the documentation.
I would implement following layout:
Disk1: VMDK - OS
Disk2: NetApp LUN - SQL User DB / System DB
Disk3: NetApp LUN - SQL Logs
Or would you separate User DB and System DB?
Thanks for your feedback!
best regards,
Andreas
Best answer by Scott Reynolds
Hi
There is nothing wrong with the config you are listing. Note from a backup/CVLT perspective this layout does not matter. As long as all databases (user and system) are located on netapp lun the backup can snap the DBs without issue. A common config seen is system dbs on local disk and user dbs on LUNS. In that setup you could not snap the system DBs (create separate subclients for user and system DBs allow system dbs to backup via streaming and user dbs via snap)
In your setup the only possible concern is if you have a very busy user DB it would affect the instance since it shares the LUN as the system dbs. However as noted from backup perspective it does not matter this is more of the MSFT SQL performance issue.
Hi
There is nothing wrong with the config you are listing. Note from a backup/CVLT perspective this layout does not matter. As long as all databases (user and system) are located on netapp lun the backup can snap the DBs without issue. A common config seen is system dbs on local disk and user dbs on LUNS. In that setup you could not snap the system DBs (create separate subclients for user and system DBs allow system dbs to backup via streaming and user dbs via snap)
In your setup the only possible concern is if you have a very busy user DB it would affect the instance since it shares the LUN as the system dbs. However as noted from backup perspective it does not matter this is more of the MSFT SQL performance issue.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
