HP StorageWorks Enterprise File Services WAN Accelerator 2.1 Command Line Interface Reference Guide (November 2005)

122 4 - CONFIGURATION-MODE COMMANDS
The no command option disables SQL blade support. You must restart the HP EFS
WAN Accelerator service after enabling this feature.
Syntax protocol ms-sql enable
Parameters None
minna (config) # protocol ms-sql enable
minna (config) #
protocol ms-sql fetch-next enable
Description Enables pre-fetching requests to request the next row in MS Project. The server-side
HP EFS WAN Accelerator pre-fetches sequential row results and the client-side HP
EFS WAN Accelerator caches them. You decide which cursors or queries are
cacheable. The no ms-sql fetch-next command option removes pre-fetching requests.
IMPORTANT: The commands for MS-SQL support must be implemented by HP professional
services—improper use can result in undesirable effects.
To determine which cursors or queries are cacheable, you configure rules. By default
all fetch next queries are cacheable.
NOTE: If you are interested in enabling the MS-SQL blade for other database applications,
contact HP professional services.
Syntax protocol ms-sql prefetch-fetchnext enable
Parameters None
minna (config) # protocol ms-sql prefetch-fetchnext enable
minna (config) #
protocol ms-sql num-preack
Description Specifies the maximum number of sp_execute (or save project) requests to pre-
acknowledge before waiting for a server response to be returned. You can enable pre-
acknowledgement if the client application does not need a result value from the
server.
For example, when you save a project in MS Project, server-side procedures are
invoked many times to write or update database data. The protocol ms-sql num-
preack command limits the number of pre-acknowledgements from the server to
maximize HP EFS WAN Accelerator optimization. The no command option disables
pre-acknowledgement.