January 25, 2010 at 11:36 am
Templog.ldf file is bigger .
what is the reason for the continuous increase of the temp database.
how to restrict the growth of the temp database and hence forth the templog.ldf file.
January 25, 2010 at 12:18 pm
You really need to provide more information and write a question that we can understand. What you've listed here doesn't follow a coherent question that describes a problem and what you would like to know.
January 25, 2010 at 12:48 pm
what is the default size of temp db?
my problem is temp db is growing continuously.
how to restrict the size.
January 25, 2010 at 1:11 pm
currently my templog.ldf is 120gb.
i am not able to shrink the file because the tempdb is not responding properly.
January 25, 2010 at 1:16 pm
Likely causes for increased size in your tempdb are:
Poorly written SQL that uses tempdb heavily. Transaction is probably still ongoing.
Index rebuilds
The most likely cause is the Poorly written SQL. You need to find the SQL that is running, fix it and determine what it does.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 25, 2010 at 4:48 pm
Running DBCC OPENTRAN in tempdb may give you a starting point if there is a long running query in tempdb.
January 25, 2010 at 5:01 pm
Check out this thread for an alternative method at helping to figure out what caused tempdb growth.
Opentran will work great - if the transaction is still running.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply