Skip to Content
Former Member
Aug 13, 2015 at 12:36 PM

Query allocation in case multiple tempdb


I have one SYBASE ASE 16.0 Database running having 5 tempdb and each of them of 500MB.

Now suppose one query is trying to allocate 600 MB tempdb to execute it, in this scenario what will be the result:

Will the query be aborted as each tempdb is of 500MB and query is needed 600MB ?

Or will it take 2 tempdb to execute it successfully?

Please help me if you know the answer.