The configuration parameters in sp_configure control resource allocation and performance. The system administrator can reset these configuration parameters 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 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:
cis rpc handling
cis cursor rows
cis bulk insert batch size
cis bulk insert array size
cis packet size
