Configuring and Setting Up tempdbs for Optimal Performance in Sybase ASE
By Mich Talebzadeh
Mich Talebzadeh is a consultant and a technical architect who has worked with Sybase and other databases since the early 1990s. He is the co-author of the book “Sybase Transact SQL Programming Guidelines and Best Practices” and the author of the forthcoming book “Oracle and Sybase, Concepts and Contrasts”. Mich can be reached at mich@peridale.co.uk.

Copyright : Mich Talebzadeh

For DBAs, good management of tempdb is critical to the overall performance of ASE. It is the most dynamic database on many servers and should receive special attention.

When ASE is installed, the setup program creates the tempdb database. The tempdb database is a system database used by ASE to store temporary tables and temporary stored procedures, for sorting, subqueries, and aggregates with GROUP BY, ORDER BY, for cursors, and so on. This database contains only temporary objects. The contents of tempdb databases are built from the model database each time...