Sample SQL Server high-availability cluster storage configuration


Sample SQL Server high-availability cluster storage configuration
Prev	Planning for SFW cluster disk groups and volumes	Next

The number of disk groups for SQL Server depends on the planned organization of the data. The application program files need to be installed on the local drive of the server. Data files and other related files, such as logs, or FILESTREAM filegroups (if implemented), are placed on the shared storage in a cluster disk group.

Veritas recommends that you place database files, log files, and FILESTREAM filegroups on separate volumes.

You create at least one disk group for the system data files. You may want to create additional disk groups for user databases.

The following figure shows an example configuration of the disk groups and volumes for SQL Server in a Microsoft cluster environment.

Figure: SFW disk groups and volumes for SQL in a Microsoft high-availability cluster

SQL disk group INST1_DG contains the following volumes:

INST1_DB1_VOL contains the SQL database. Each database typically resides on a separate volume.
INST1_DB1_LOG contains the transaction log.
INST1_SYS_FILES contains the volume for Microsoft SQL Server system data files.

This configuration is a simple example. The recommended practice for disk groups and volume layout is dependent on your environment.

Note:

If FILESTREAM is implemented, the configuration should also contain a separate volume for the FILESTREAM filegroup.