protocol ms-sql num-preack
Specifies the maximum number of sp_execute (or save project) requests to preacknowledge before waiting for a server response to be returned.
Syntax
[no] protocol ms-sql num-preack <number-preack>
Parameters
<number-preack> | Maximum number of pre-acknowledgments. The default value is 5. |
Usage
You can enable pre-acknowledgment 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. To maximize optimization, the protocol ms-sql num‑preack command limits the number of pre-acknowledgments from the server.
The no command option disables pre-acknowledgment.
Example
amnesiac (config) # protocol ms-sql num-preack 6
amnesiac (config) # service restart
Product
SteelHead CX, SteelHead EX, SteelHead-v, SteelHead-c
Related Commands