The configuration parameters in the sp_configure system procedure control resource allocation and performance. The System Administrator can reset these configuration parameters in order to tune performance and redefine storage allocation. In the absence of intervention by the System Administrator, the server supplies default values for all the parameters.
The procedure for resetting configuration parameters is:
Execute the system procedure sp_configure, which updates the values field of the system table master..sysconfigures.
Restart the server if you have reset any of the static configuration parameters. The parameters listed below are dynamic; all others are static:
cis rpc handling
cis cursor rows
cis connect timeout
cis bulk insert batch size
cis bulk insert array size
cis packet size
