Commands for cache binding

Use sp_cacheconfig and sp_poolconfig to create named data caches and to configure pools of a given size for large I/O. Only a System Administrator can configure caches and pools.

NoteReference to Large I/Os are on a 2K logical page size server. If you have an 8K page size server, the basic unit for the I/O is 8K. If you have a 16K page size server, the basic unit for the I/O is 16K.

For instructions on configuring named caches and pools, see the System Administration Guide.

Once the caches have been configured, and the server has been restarted, you can bind tempdb to the new cache:

sp_bindcache "tempdb_cache", tempdb