TEMP DB

[wimvanherp]

A few questions abjout the tempdb,

the tempdb is it used only for temporary tables, or does sybase uses it also for internal use ?
How do I know wich size the tempdb must be ?
Is it possible to monitor the usage of the tempdb ?

regards

Wim Vanherp Wim Vanherp
Wim.Vanherp@belgacom.net

 

[ramrakhiani]

the tempdb is it used only for temporary tables, or does sybase uses it also for internal use ?
--Not sure but I think it is internall also as for creating work tables for 'sort by' queries.

How do I know wich size the tempdb must be ?
--Genrally, 10% of size of database.

Is it possible to monitor the usage of the tempdb ?
--Do you need to monitor free space? Whenever it goes
full, sp_thersholdaction is invoked.

 

[mehrnosh]

tempdb is a database that is used by Sybase for storing
temporary tables and intermediate results in a complex query.
It is shared by all databases in the system. You rarely refer to it
directly.