Under normal Adaptive Server use, tempdb makes heavy use of the data cache as temporary tables are created, populated, and then dropped.
Assigning tempdb 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
See “Examining cache needs for tempdb” on page 232 for more information.
