No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

Basic Storage Service Configuration Guide for Block

OceanStor V5 Series V500R007

This document is applicable to OceanStor 5110 V5, 5300 V5, 5500 V5, 5600 V5, 5800 V5, 6800 V5, 5300F V5, 5500F V5, 5600F V5, 5800F V5, 6800F V5, 18500 V5, 18800 V5, 18500F V5, and 18800F V5. It describes the basic storage services and explains how to configure and manage them.
Rate and give feedback:
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
SQL Server

SQL Server

This section describes how to configure storage resources for 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.

    NOTE:
    • 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.

Download
Updated: 2019-08-30

Document ID: EDOC1000181506

Views: 74510

Downloads: 561

Average rating:
This Document Applies to these Products
Related Version
Related Documents
Share
Previous Next