Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Not what you were looking for? View more on this topic or Ask a question