Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Full tempdb Log Expand / Collapse
Author
Message
Posted Tuesday, January 15, 2013 9:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 9:33 AM
Points: 157, Visits: 1,178
My tempdb log file fills up where the Log Free Space is 4%, Log Used is 95%. If I restart the server it will clear out tempdb, thats not an option since it has to be up 24/7 (mostly). Is my only option is to increase the size.
Post #1407351
Posted Tuesday, January 15, 2013 2:15 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 3:35 AM
Points: 227, Visits: 1,782
Yes, if the DB must be online your only option is to increase size of the temdb. Then check what consume space eg:
http://thesqldude.com/2012/05/15/monitoring-tempdb-space-usage-and-scripts-for-finding-queries-which-are-using-excessive-tempdb-space/
maybe the tempdb size should be larger.
Post #1407491
Posted Tuesday, January 15, 2013 7:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 20, 2014 9:17 PM
Points: 3, Visits: 159
When looking at what is happening in the temp db I would also have a look at what the overall requirement of the database server and the hardware configuration is.

I have just been reading up on some of this, and one idea is that you should have a look at the databases and the tables inside, from that the tempdb should at least have enough room to allow you to do an online reindex of the largest table and all it's indexes. But take not that sizing the temp db and if in some cases the multiple files of the temp db should be done correctly to make sure the system runs fine.
Post #1407548
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse