sp_helpconfig displays information about configuration parameters. Use sp_helpconfig to calculate the overhead associated with enabling the secondary data cache.
For example, to calculate the overhead for a secondary cache of 2GB (1048576 2K pages), enter:
sp_helpconfig “extended cache size”, “1048576”
Copyright © 2004. Sybase Inc. All rights reserved. |
![]() |