HP StorageWorks Enterprise File Services WAN Accelerator 3.0.4 Command-Line Interface reference manual (AG421-96004, March 2007)

158 4 - CONFIGURATION-MODE COMMANDS
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 [no] protocol ms-sql num-preack <num-preack>
Parameters
Example
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.
Syntax [no] protocol ms-sql port <port>
<num-preack> Specifies the maximum number of pre-acknowledgements. The
default value is 5.