SQL Server

Prerequisite

The system has sufficient storage space.

Context

The storage system supports SQL Server 2008 and SQL Server 2012.

Procedure

1. Log in to DeviceManager.
2. Choose Provisioning > Application > SQL Server.
3. Click Create.

   The Create SQL Server Storage Resource Wizard is displayed.

4. Set basic information about the SQL Server instance to be created.

   Table 5-20 describes related parameters.

   Table 5-20 Parameters of an SQL Server instance

   Parameter	Description	Value
   Name	Name of an SQL Server instance. The name: Must be unique. Can contain only letters, digits, underscores (_), periods (.), and hyphens (-). Must contain 1 to 22 characters.	[Example] SQLServer_App_001
   Description	Description of an SQL Server instance. Description can be left blank or contain up to 255 characters.	[Example] -

5. Click Next and set the SQL Server application parameters.

   Table 5-21 describes related parameters.

   Table 5-21 SQL Server application parameters

   Parameter	Description	Value
   Service Type	Type of an SQL Server application. The possible values are described as follows: OLTP: The OLTP is a main application of traditional relational databases. It is used for processing basic and ordinary transactions, such as bank transaction. OLAP: A technology that uses multidimensional structures to provide rapid accesses to data for analysis. This application mainly applies to data warehouse systems, such as dynamic reporting systems.	[Example] OLTP
   Service Scale	Storage space required by SQL Server services.	[Example] 40 GB

6. Optional: Set advanced properties for SQL Server applications.
   1. Click Advanced.

      The Advanced dialog box is displayed.

   2. Set advanced properties for SQL Server applications.

      Table 5-22 describes the related parameters.

      Table 5-22 Parameters in advanced properties of an SQL Server application

      Parameter	Description	Value
      Use full log mode	After this option is selected, the system will allocate storage resources to SQL Server applications to store SQL Server database logs.	[Example] Use full log mode
      Log Amount per Day (GB)	Maximum storage space used to store logs per day. This parameter is available after Enable log archiving is selected.	[Example] 3
      Log Retention Period (days)	Retention period of system logs. After this period expires, logs are not stored. This parameter is available after Enable log archiving is selected.	[Example] 8
      Enable SmartThin	After this option is selected, the system creates thin LUNs. A thin LUN is allocated an initial capacity (30% of the total capacity) when created and is dynamically allocated required storage resources when its available capacity is insufficient.	[Example] Enable SmartThin
      Reserve snapshot space	After this option is selected, the system automatically selects a storage pool whose capacity is 130% of the required capacity. When you use the storage pool to create storage resources for applications, reserve sufficient space to create snapshots for applications.	[Example] -
      Use clusters	After this option is selected, the system automatically allocates two 5 GB LUNs to store cluster logs.	[Example] -
      Use AlwaysOn	After this option is selected, the system stores n duplicates of data LUNs and log LUNs. n indicates the number of duplicates. This function is available to Microsoft SQL Server 2012 only.	[Example] -
      Number of Duplicates	Number of duplicates of data LUNs and log LUNs. This parameter is available after Use AlwaysOn is selected.	[Value range] The value ranges from 1 to 5 and the default value is 2. [Example] 2

   3. Click OK.

      You are returned to the Set SQL Server Database Parameters page.

7. Click Next to set storage resource parameters for SQL Server.

   The system will allocate optimal storage resources based on preset SQL Server parameters.

   Table 5-23 SQL Server storage resource parameters

   Parameter	Description	Value
   LUN Capacity	LUN storage space allocated to store data or logs.	[Example] 60.000 GB
   LUN Quantity	Number of LUNs allocated to store data or logs.	[Example] 1
   Storage Pool Policy	The system sets storage pool allocation policies based on preset SQL Server parameters. The value can be High performance, Performance/Cost balance, Low cost, or Manual selection. The four values are described as follows: High performance: The system automatically selects a RAID 6 storage pool containing SAS disks only. If such a storage pool does not exist in the system, create one. Performance/Cost balance: The system automatically selects a RAID 6 storage pool containing SAS and NL-SAS disks only. If such a storage pool does not exist in the system, create one. Low cost: The system automatically selects a RAID 6 storage pool containing NL-SAS disks only. If such a storage pool does not exist in the system, create one. Manual selection: Users define storage pools that meet the SQL Server service requirements.	[Example] Manual selection
   Selected Storage Pool	Name of the storage pool automatically allocated by the system to an SQL Server instance.	[Example] StoragePool002

8. Optional: If the desired storage pool type does not exist or is unavailable, click and modify Storage Pool Policy in the dialog box that is displayed, or click Create Storage Pool to create one.

   Table 5-23 describes related parameters.

9. Optional: Select a host to which you want to map the instance.
   • If a mapped host is selected, the system automatically creates a LUN group, a host group, and a mapping view, and adds the LUN group and host group to the mapping view.
   • If no mapped host is selected, the system automatically creates a LUN group only. You need to manually create a host group and a mapping view for a mapped host and add the host to the mapping view. After being added to the mapping view, the host can access storage resources.

     The LUN group must contain all LUNs in the application instance.

   1. Click Next.

      The Select Mapping Hosts page is displayed.

   2. In the Available Hosts list, select the host that is used to access storage resources.
   3. Click to add the host to Selected Hosts.

10. Confirm your settings.
    1. Click Next.

       The summary page is displayed.

    2. Verify that the information about the SQL Server instance to be created is correct and click Finish.

       The Execution Result dialog box is displayed, indicating that the operation succeeded.

    3. Click Close.