Sizing the tempdb

tempdb needs to be big enough to handle the following processes for every concurrent Adaptive Server user:

Some applications may perform better if you use temporary tables to split up multitable joins. This strategy is often used for:

You might also use tempdb to:

For most applications, make tempdb 20 to 25% of the size of your user databases to provide enough space for these uses.