Query allocation in case multiple tempdb

[Former Member]

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.

[former_member188958]

Each connection (spid) can only use one tempdb.  So the query would abort.

[Former Member]

Thanks Bret.

Also, can you please let me know the advantage of using multiple tempdb (no binding) over one more sized tempdb?

I have tried to find the answer hard but not convinced of any answer.

Thanks again in advance.

[former_member188958]

Multiple tempdbs are used to reduce contention on tempdb.