Database size increases significantly. Normally 15G per month, but recently 60G per month. Anyone knows why and how to find out the reasons for it? Thank you!
Start by setting up or verifying a backup plan, defrag, reorganize.
most likely to be the log table, you can uncheck trace option under users, - as well as clearing the the log files them self, and as @Doug.C suggested if run the table use analysis most likely to find it as i said, in my environment i have narrowed it down to the manager log folder as i found it growing approximately 1GB per day, so i have written a PwerShell script to clear this folder and keep one week of data only in case if needed for any traceability issue.
