To configure MS-SQL1. Click the Setup tab to expand the Optimization Service menu. protocol support

2.Click Protocol: MS-SQL to display the Optimization Service - Protocol: MS-SQL page.

Figure 2-6.Optimization Service - Protocol: MS-SQL Page

 

3. Use the controls to complete the configuration, as described in the following table.

 

 

 

Control

 

Description

 

 

 

General

 

Enable MS-SQL Optimization. Specify this option to increase optimization for

 

 

Microsoft Project.

 

 

 

 

 

Enable MS-SQL Prefetch Fetch-Next. Specify this option to enable prefetching

 

 

requests to request the next row in MS Project. This feature is enabled by default. The

 

 

server-side appliance prefetches sequential row results and the client-side HP EFS WAN

 

 

Accelerator caches them.

 

 

 

 

 

Max Number of Pre-Acknowledgements. Specify the number of requests to pre-

 

 

acknowledge before waiting for a server response to be returned. The default is 30.

 

 

 

 

 

Apply. Click Apply to apply your settings to the running configuration. (Apply your

 

 

settings to test a new configuration before saving them permanently.)

 

 

 

Add MS-SQL Port

 

Port. Specify the port number for the MS-SQL server.

 

 

 

 

 

Add Port. Click Add Port. The default is 1433.

 

 

 

 

 

Remove Selected Ports. To remove an entry, click the check box next to the port name

 

 

and click Remove Selected Ports.

 

 

 

2 CONFIGURING THE HP EFS WAN ACCELERATOR

HP STORAGEWORKS EFS WAN ACCELERATOR MANAGEMENT CONSOLE USER GUIDE

37

Page 37
Image 37
HP Enterprise File Services WAN Accelerator manual Optimization Service Protocol MS-SQL, Click Remove Selected Ports