On our Epicor SQL Server instance, we are running out of disk space on both the tempdb (140GB) and Epicor905 (550GB) data file locations. Any thoughts why this is getting large? We’re looking at doing a shrink of the database data files to see if that helps.
I would do a few things -
1 - Reboot SQL and the tempdb space should come back to normal and free up any processes that may be active and could prevent shrinking the files
2 - Make the tempdb files all the same size and make sure they are all set to the same auto-grow settings
3 - You should look at your data files and see how much space is used within them. Judging by the sizes they are auto-growing which is not a good thing. if they are close to full you should size each the same and allow plenty of extra space for re-index operations. Check your auto-grow settings for each file and make sure they are all the same