Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tempdb
Message
From
14/08/2000 08:34:35
 
 
To
13/08/2000 03:15:15
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: Tempdb
Miscellaneous
Thread ID:
00403763
Message ID:
00404464
Views:
9
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
Previous
Reply
Map
View

Click here to load this message in the networking platform