August 12, 2011 at 4:30 pm
I giving max size of 1TB to the tempdb but the tempdb seems to be growing over that and filling up the disk, is there a way i can control the growth and make sure it does not grow over certain size.
August 12, 2011 at 5:16 pm
I recommend finding what is causing all of that growth to occur and fix the process.
1 TB for tempdb is huge.
Here are a couple of articles you should read.
http://www.sqlservercentral.com/articles/Log+growth/69476/
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
August 13, 2011 at 1:29 am
Sorry, misread this...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2011 at 5:18 am
I concur. You need to address the root causes, not simply try to limit the size of tempdb. In fact, as you're finding, you won't be able to. If whatever you're running needs 50TB of storage in tempdb, then you'll have to have a 50TB tempdb. You need to figure out what that is.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply