sp_configure allows you to specify the value for configuration parameters in unit specifiers. The unit specifiers are p or P for pages, m or M for megabytes, and g or G for gigabytes. If you do not specify a unit, and you are configuring a parameter that controls memory, Adaptive Server uses the logical page size for the basic unit.
The syntax to indicate a particular unit specification is:
sp_configure "parameter name", 0, "p|P|k|K|m|M|g|G"
You must include the “0” as a placeholder.
You can use this unit specification to configure any parameter. For example, when setting number of locks to 1024 you can enter:
sp_configure "number of locks", 1024
or:
sp_configure "number of locks", 0, 1K
This functionality will not change the way in which Adaptive Server reports sp_configure output.
When you are configuring memory related parameters,
only use the P (pagesize) parameter for your
unit specification. If you use any other parameter to configure
memory related parameters, Adaptive Server may issue an arithmetic
overflow error message.
