Example: Microsoft SQL Server Storage Layout (with VMDKs and NetApp SnapCenter)

Continuing from the Master of SnapCenter post… The following is mostly copied from the “Data Protection for Virtualized Applications v1.0” NetApp Lab on Demand since this stuff is quite interesting for one wanting to understand storage layout.

The following information describes the database layout used in this lab as an example of a SQL server running as a VMware Virtual Machine (VM) using VMware Virtual Machine Disks (VMDK) as the underlying storage for database files. This is just an example layout with small sized disks for a demonstration only database. Production database file layouts can be customized to meet backup consistency, performance, and desired business continuity goals.

Image: SQL Database Layout

A cluster and SVM peering relationship is established in this lab, along with data protection relationships for ease of demonstration.

Image: Data Protection Relationships

Notice: Only SQL data and SQL log files are mirrored in this case (not the O/S disk, not the sysdb, not the mountpoint/host log).

Image: Disks

Image: Volumes

Image: VM Disks (this is just a lab MS SQL box, hence the CPU, memory and disk sizes are small)

Comments