Tempdb mdf files not clearing #827
Replies: 1 comment
-
The Maintenance Solution is not doing anything with respect to tempdb. You need to find out which job/command that was causing tempdb to grow. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
I switched from using the native sql backup function (the maintenance plan) to the Ola Hallengren script and I realized my Tempdb mdf files were growing out of control. I checked the tempdb and can a report showing top tables by disk usage and the tables had like 128mb of data, yet, there are 4 tempdb files of 28gb a piece. My only solution was to restart the sql service. Does the ola script empty the tempdb file? If not, can you add it as a feature?
Beta Was this translation helpful? Give feedback.
All reactions