patternsqlMinor
Tempdb is getting full very quickly in microsoft sql server 2008
Viewed 0 times
quicklyfulltempdb2008sqlgettingmicrosoftveryserver
Problem
I am developing a log analyzer tool and After queering it and
generating reports
Is there any solution to clean the
2008 on a timely basis other than restarting the server ?
Thank you so much in Advance
generating reports
Tempdb is getting full very quickly . Is there any solution to clean the
tempdb file in microsoft sql server2008 on a timely basis other than restarting the server ?
Thank you so much in Advance
Solution
Tempdb is growing like this because something is using it. No attempt to fix, clean or manipulate tempdb is going to work as long as this is going on.
To address this problem, you need to find out what is causing it to grow like this and then fix that problem first. This alone may resolve the whole issue and remove your need to do anything else with tempdb. In my experience, the most likely cause for something like this is an out-of-control Cross Join query (though there are lots of other possibilities).
To address this problem, you need to find out what is causing it to grow like this and then fix that problem first. This alone may resolve the whole issue and remove your need to do anything else with tempdb. In my experience, the most likely cause for something like this is an out-of-control Cross Join query (though there are lots of other possibilities).
Context
StackExchange Database Administrators Q#19231, answer score: 6
Revisions (0)
No revisions yet.