SQL Server has less space on tempdb drive

Question

Hi All,

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.

Answer 1

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

---

Sandeep Dasam

Answer 2

Thanks for your assistance. But the first link is not working http://technet.microsoft.com/en-us/library/cc966545.aspx do not know why.

 

---

SKD

Answer 3

Hello,

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.

Answer 4

Hi Normand,

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.

---

SKD

Answer 5

The following article deals with disk drive configuration:

http://www.sqlusa.com/bestpractices/configureharddisk/

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:

http://stackoverflow.com/questions/1119924/sql-server-2000-tempdb-growing-very-large

---

Kalman Toth SQL SERVER 2012 & BI TRAINING
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012