February 23, 2011 at 10:23 am
Hi,
I'm using Microsoft SQL Server 2005 Enterprise Edition installed in live server where the TempDB is reaching the size to 15GB and making the disk space low. I have restarted the sql services and after 20 mins of start its slowly increasing its size. There is no job agent or sproc running at backend. TempDb is under simple recovery mode and I have set the growth rate to 10GB but it breaking it and reaching 15GB. What needs to be done in this case.
February 23, 2011 at 10:29 am
Have a look at the blog post here:
http://strictlysql.blogspot.com/2010/03/whats-causing-my-tempdb-to-grow-sql_17.html
You need to see what the underlying cause of growth is by setting up monitoring.
Of course, depending on the size of the user databases on your system, it might mean that you need more server space , as activities such as DBCC CHECKDB and reindexing will need space in tempdb in order to take place.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply