Under normal Adaptive Server use, temporary databases make heavy use of the data cache as temporary tables are created, populated, and dropped.
Assigning a temporary database to its own data cache:
Keeps the activity on temporary objects from flushing other objects out of the default data cache
Helps spread I/O between multiple caches
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 Chapter 4, “Configuring Data Caches” in the System Administration Guide: Volume 2.
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