HP StorageWorks Enterprise File Services WAN Accelerator 2.1.5 Command-Line Interface reference manual (June 2006)

HP STORAGEWORKS EFS WAN ACCELERATOR COMMAND-LINE INTERFACE REFERENCE MANUAL 133
4 - CONFIGURATION-MODE
C
OMMANDS
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.
IMPORTANT: The commands for MS-SQL support must be implemented by HP professional
services—improper use can result in undesirable effects.
NOTE: If you are interested in enabling the MS-SQL blade for other database applications,
contact HP professional services.
Syntax protocol ms-sql num-preack <num-preack>
Parameters
minna (config) # protocol ms-sql num-preack 5
minna (config) #
protocol ms-sql port
Description Specifies the server port to listen on for SQL requests. The default port is 1433. The
no command option disables the SQL server port.
IMPORTANT: The commands for MS-SQL support must be implemented by HP professional
services—improper use can result in undesirable effects.
NOTE: If you are interested in enabling the MS-SQL blade for other database applications,
contact HP professional services.
<num-preack>> Specifies the maximum number of pre-acknowledgements. The
default value is 5.