HP IO Accelerator for BladeSystem c-Class Podręcznik Użytkownika Pobierz pdf (Strona 4)

Installing and preparing the IO Accelerator for Microsoft Windows SQL Server 4

Installing and preparing the IO Accelerator for

Microsoft Windows SQL Server

Initial setup

After the IO Accelerator is installed, follow these steps to prepare it for use with Microsoft® SQL Server:

1. Start the HP IO Accelerator Management Tool.

2. In the Device Tree, select the IO Accelerator.

3. Click Format Low-level.

4. In the dialog box, select Advertised Capacity, and select a 4K block size.

5. Select Disk Management in Windows.

6. If you are using a RAID configuration on multiple IO Accelerators, convert the drives to Dynamic.

7. Format the drive for a filesystem, setting the File Allocation Unit Size to 64K.

Installing Microsoft SQL Server

NOTE: When you install Microsoft® SQL Server, install the executables, usually found in the

Program Files folder, to your local drive rather than to the IO Accelerator drive.

Install the following system databases on the IO Accelerator:

• Master

• Tempdb

• MSDB

• Model

If heavy paging occurs, install the page files on the IO Accelerator, which provides a significant increase

in performance (when DRAM is available).

For more information, see the latest Windows® user guide.

Additional performance tips

• Have as many user database data files as there are processor cores in the server. This ratio enables

multiple threads to operate at the same time and significantly improves the IO Accelerator

performance.

• Keep all the data files the same size.

• Allow the database to use only one log file.

1 2 3 4 5 6 7 8 9 ... 13 14

Brak uwag

HP IO Accelerator for BladeSystem c-Class Podręcznik Użytkownika Strona 4