Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tempdb
Message
De
14/08/2000 08:34:35
 
 
À
13/08/2000 03:15:15
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Re: Tempdb
Divers
Thread ID:
00403763
Message ID:
00404464
Vues:
10
SQL Server does not store any data in tempdb. tempdb is used just for housing temporary object (table, stored procedures, ...) while their being used for some process.

The only way that tempdb should noticable affect your applications is if you run out of space. SQL Server will not use tempdb to cache data pages. There's a lot more happening with the data cache then dirty pages sitting in memory.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform