If a named cache has only local configurations and objects bound to it, you cannot create a global cache configuration. You see error 19817. For example:
sp_cacheconfig 'SALES', '200M', 'instance SALES_INSTANCE' go sp_bindcache 'SALES','SALES_DB' go sp_cacheconfig 'SALES', '300m' go ------- Error 19817, "New configuration on cache 'SALES' is not permitted."
To avoid this situation in the example above, unbind all objects bound to cache “SALES”. Create a new configuration for cache “SALES”, and bind the objects again.
To avoid physical lock deadlocks, the index pages in the Cluster Edition do not use large pool support.