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.
Reference 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
