Meg,
I generally let my tempdb grow when it needs to. It seems that in my situation that 15 gig is a good size since it is rare for Tempdb to grow any larger. If it grows a little I just let it be. But I had an incident last week where tempdb grew to 50 gig. Then I shrank it back down to 15 and will let it be. You just need to find the "right" size for your server and users. You don't want Tempdb constantly growing cuz that takes system resources.
Dave
-----Original Message-----
From: Meg Hardy [mailto:[Email Address Removed] Friday, September 27, 2002 4:49 AM
To: LazyDBA.com Discussion
Subject: tempdb growth
Hi Guru's
I have a job set up to run every night to monitor file growth on all
database files and transaction log files. This morning I had an email
saying that my tempdb datafile has grown overnight. I understand that
datafile growth affects performance. If it was one of my own db's i would
increase the size but since it is a system db I dont know whether or not I
should. What would you recommend?
Thanks!!
Meg
**********************************************************************
DISCLAIMER
Any opinions expressed in this email are those of the individual and not necessarily of Mondial Assistance (UK) Ltd. This email and any files transmitted with it, including replies and forwarded copies (which may contain alterations) subsequently transmitted from the Company, are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited.
If you have received this email in error please notify the IT support desk by telephone on +44 (0)208 2393984 or via email to
[Email Address Removed] including a copy of this message. Please then delete this email and destroy any copies of it. Thank you.
Mondial Assistance (UK) Ltd
Mondial House
102 George Street
Croydon
CR9 1AJ
Mondial Assistance (UK) Ltd Registered in England No.1710361 Registered office as above
**********************************************************************
________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________
MS Sql Server LazyDBA home page