Monday, September 19, 2011 11:54 AM
Can any one help me out that,what are all steps we need to take if tempdb drive size is very low on the server.I have shrinked the tempdb on regular basis but not getting shrunked.
- Changed Type KJian_ Wednesday, October 05, 2011 2:17 AM
Wednesday, September 21, 2011 1:17 PM
Below is a very good article to manage tempdb size
Working with Temp db : http://technet.microsoft.com/en-us/library/cc966545.aspx
How to shrink Temp database in SQL server : http://support.microsoft.com/kb/307487
Friday, September 23, 2011 10:31 AM
Thanks for your assistance. But the first link is not working http://technet.microsoft.com/en-us/library/cc966545.aspx do not know why.
Tuesday, October 04, 2011 3:42 PMModerator
I have displayed the page corresponding to the first link, it concerns SQL Server 2005
Please SKD, could you tell which is the version (2005,2008,2008 R2 ) of the SQL Server ?
Have a nice day
Mark Post as helpful if it provides any help.Otherwise,leave it as it is.
Friday, January 27, 2012 10:05 AM
I am faceing this issue on sql server 2008r2, but most of the servers has configured on sql server 2008 and sql server 2005 also.
Wednesday, February 01, 2012 5:57 PM
The following article deals with disk drive configuration:
Shrinking tempdb will not help because if needed, tempdb will grow again fast.
You would have to find out the reason for unusual large growth. You can use SQL Profiler for diagnostics:
Kalman Toth SQL SERVER 2012 & BI TRAINING
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012