April 21, 2010 at 2:13 pm
Hi All,
The log file of tempdb keeps growing everyday.. How can i find out which processes is using much of the tempdb space?
Also, if the % of allocation and deallocation of pages in internal objects are high, what does it mean?
Any help is highly appreciated!!!
Thanks!!!
April 21, 2010 at 2:30 pm
Check out this article
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
April 21, 2010 at 3:46 pm
Thanks a lot, Jason!!! That was really helpful
April 21, 2010 at 3:57 pm
You're welcome.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply