February 24, 2011 at 6:53 am
SKYBVI (2/24/2011)
I also dont like shrinking the tempdb personally.10gb is fine for a 340 gb prod db, i know that.
But my manager doesn't like that.
I told her many reasons for not shrinking it...but she cant understand..
🙁
Regards,
Sushant
What, specifically, are your manager's reasons for wanting to shrink it?
Perhaps TheSQLGuru needs to knock some sense into her?? :w00t:
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 24, 2011 at 7:00 am
TheSQLGuru (2/24/2011)
SKYBVI (2/24/2011)
I also dont like shrinking the tempdb personally.10gb is fine for a 340 gb prod db, i know that.
But my manager doesn't like that.
I told her many reasons for not shrinking it...but she cant understand..
🙁
Regards,
Sushant
What, specifically, are your manager's reasons for wanting to shrink it?
Perhaps TheSQLGuru needs to knock some sense into her?? :w00t:
She is a crack i guess..
The drive holding the tempdb has 140 gb and just 11 gb is used out of it..then also she wants to have some more space in that drive....GOD knows for what?...
She thinks im uncapable of doing that and thtsy iam finding an excuse for that.
But i did tempdb shrink on other servers too....
The manager level mentality , i can never understand ...they want to save everything...from money to free space....HUH....
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
February 24, 2011 at 7:05 am
If performance or availability is not a concern to her, restart the service...:-P
-- Gianluca Sartori
February 24, 2011 at 7:10 am
SKYBVI (2/24/2011)
TheSQLGuru (2/24/2011)
SKYBVI (2/24/2011)
I also dont like shrinking the tempdb personally.10gb is fine for a 340 gb prod db, i know that.
But my manager doesn't like that.
I told her many reasons for not shrinking it...but she cant understand..
🙁
Regards,
Sushant
What, specifically, are your manager's reasons for wanting to shrink it?
Perhaps TheSQLGuru needs to knock some sense into her?? :w00t:
She is a crack i guess..
The drive holding the tempdb has 140 gb and just 11 gb is used out of it..then also she wants to have some more space in that drive....GOD knows for what?...
She thinks im uncapable of doing that and thtsy iam finding an excuse for that.
But i did tempdb shrink on other servers too....
The manager level mentality , i can never understand ...they want to save everything...from money to free space....HUH....
Regards,
Sushant
Send her to this thread, oh nvm after reading the few last posts better not to
February 24, 2011 at 7:12 am
It is generally very difficult to SHRINK the TEMPDB as its almost constantly in use. If you really must bring down the size of the TEMPDB, reduce the initial size of the DB and restart the SQL services.
February 24, 2011 at 7:16 am
grahamc (2/24/2011)
It is generally very difficult to SHRINK the TEMPDB as its almost constantly in use. If you really must bring down the size of the TEMPDB, reduce the initial size of the DB and restart the SQL services.
Restarting services Not possible as its a prod database..
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
February 24, 2011 at 1:43 pm
Tell your manager that shrinking it is like crumpling up a piece of paper because you don't need it right now, then flattening it out (growth) when you do need it, then crumpling it back up again (shrinking) ... a lot of wasted effort for no gain.
February 24, 2011 at 2:11 pm
homebrew01 (2/24/2011)
Tell your manager that shrinking it is like crumpling up a piece of paper because you don't need it right now, then flattening it out (growth) when you do need it, then crumpling it back up again (shrinking) ... a lot of wasted effort for no gain.
🙂
Regards
Sushant Kumar
MCTS,MCP
February 24, 2011 at 2:37 pm
Would some MSDN whitepapers help?
http://msdn.microsoft.com/en-us/library/cc966545.aspx#EGAA
http://msdn.microsoft.com/en-us/library/ms190768%28v=SQL.90%29
February 25, 2011 at 3:35 am
homebrew01 (2/24/2011)
Tell your manager that shrinking it is like crumpling up a piece of paper because you don't need it right now, then flattening it out (growth) when you do need it, then crumpling it back up again (shrinking) ... a lot of wasted effort for no gain.
I like that.... 😎
February 25, 2011 at 4:26 am
Tell your manager that you've checked with all of us and: it's not possible to shrink tempDB 😀
Carlton.
February 25, 2011 at 6:29 am
Sushant can you try this query and let me know what happens:
dbcc shrinkfile ('templog',100)
backup log tempdb with truncate_only
dbcc shrinkfile ('templog',100)
February 25, 2011 at 6:56 am
.
Regards
Sushant Kumar
MCTS,MCP
February 25, 2011 at 7:02 am
Carlton Leach (2/25/2011)
Tell your manager that you've checked with all of us and: it's not possible to shrink tempDB 😀Carlton.
It seems as if its the only alternative left ...:)
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
February 25, 2011 at 7:13 am
Sky,
seem your manager is non-tehnical and doesnt really understand the importance of the tempdb.
_________________________________________________________________________
SSC Guide to Posting and Best Practices
Viewing 15 posts - 16 through 29 (of 29 total)
You must be logged in to reply to this topic. Login to reply