December 1, 2011 at 9:56 pm
I were asked to find out the why tempdb was got full. Is there anyway to find why tempdb running out of space in past ? Pls help.
December 1, 2011 at 11:23 pm
Without having some sort of monitoring in place when the files grow like that, you won't be able to find out.
Check out this article for some ideas on how to monitor the file growth.
http://www.sqlservercentral.com/articles/Log+growth/69476/
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
December 1, 2011 at 11:32 pm
Following article covers all what you need to know about tempdb. It's for SS2K5 but pretty much fine with SS2K8 as well.
Working with tempdb in SQL Server 2005
December 2, 2011 at 2:59 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply