Skip to Content
0
Former Member
Feb 05, 2016 at 06:18 PM

Multiple Temporary Databases

20 Views

We're currently running ASE 15.7 SP 63.

We've recently had what might be some contention issues in tempdb, we're still investigating.

However, this brought up a question: are there any good guidelines as to how many temporary databases there should be?

Currently on the system in question we have 30 engines, 6 tempdbs in the default pool, 1 tempdb for DBAs, and 1 tempdb for a monitoring tool. 8 total tempdbs. Is this enough, or should there be more? What are the main considerations for how many tempdbs there should be?