By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,648 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

temp db

P: n/a
what is the best practice for sizing the temp db in sql 2000?

what the best way to free up temp db space without shutdown the sql?

how to monitor temp db parameters?
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"Shawn" <fa***************@yahoo.com> wrote in message
news:ab**************************@posting.google.c om...
what is the best practice for sizing the temp db in sql 2000?
It's hard to say - it depends a lot on the queries you execute, as well as
on the volume of data you have. MS recommends allowing it to grow
automatically, but I don't know of any suggested way to establish a starting
size. You could just leave it as default, then see how large it grows - when
you have a feel for how big it needs to be, you can then change the database
size so it's larger on startup.

what the best way to free up temp db space without shutdown the sql?
http://support.microsoft.com/default...&Product=sql2k

how to monitor temp db parameters?


If by "parameters" you mean the size, then you can use performance monitor
to monitor the SQLServer:Databases data and log file size counters; you can
write your own simple script to check the database size at certain
intervals; or if you use a third-party MSSQL monitoring tool, it should be
able to do this.

Simon
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.