1-Are you insert a lot logged data to your database.
2-Are you using a lot of #temp tables
3-Check the time period of your database backup and your transaction log
size during that time.
4-Check if you are using full recovery mode
These are just a few things that may cause it to grow
Find out what is causing it before restarting your server as it will grow
again according to what it the space it needs
Jaime E. Maccou
mailto:Jaime E. Maccou
"Our lives begin to end the day we become silent about things that matter."
- Dr. Martin Luther King, Jr.
"The mind does not take its complexion from the skin..."
- Frederick Douglass
There is always a way to do it better . . . find it!" Thomas A. Edison
DBA Ethical Rules
1. Don’t Lie
2. Don’t Cheat
3. Don’t Steal
4. Treat everyone fairly
5. Treat everyone equally"
-----Original Message-----
From: Bipan Kumar
[mailto:mssqldba-ezmlmshield-x39732650.[Email address protected]
Sent: Friday, March 28, 2008 4:18 AM
To: LazyDBA Discussion
Subject: RE: tempdb datafile size grows to 90 gb
Restart the sql server services....
-----Original Message-----
From: Venkataramani S.
[mailto:mssqldba-ezmlmshield-x20339155.[Email address protected]
Sent: Friday, March 28, 2008 1:35 PM
To: LazyDBA Discussion
Subject: tempdb datafile size grows to 90 gb
Hi,
I got this error message in my log file.
"Autogrow of file 'tempdev' in database 'tempdb' took 64328
milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH
for this file."
Suddenly my temp db datafile size grows to 90 gb. I have enabled auto
growth. When I checked the spaceused it used only 2 mb and remaininig in
unallocated zone.
I did shrink database and shrinkfile to reduce it to default size but
nothing happened.
Pls friends help me out in this issue. very urgent I am running out of
space.
Thanks in advance
Venkat
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This message and its attachments contain confidential information and may
also contain legally privileged information. This message is intended solely
for the named addressee. If you are not the addressee indicated in this
message (or authorized to receive for addressee), you may not copy or
deliver any part of this message or its attachments to anyone or use any
part of this message or its attachments. Rather, you should permanently
delete this message and its attachments (and all copies) from your system
and kindly notify the sender by reply e-mail. Any content of this message
and its attachments that does not relate to the official business of
Cellebrum.com Pvt Ltd or its affiliates and/or subsidiaries must be taken
not to have been sent or endorsed by any of them. Opinions and information
in this email that do not relate to the official business of Cellebrum.com
Pvt Ltd, shall be understood as neither given nor endorsed by Cellebrum.com
Pvt Ltd. Any action/proceeding/opportunity upon the contents of this email
taken by not intended addressee shall attract liabilities both criminal and
civil against such addressee.
Email communications are not private and no warranty is made that e-mail
communications are timely, secure or free from computer virus or other
defect.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page