SQL SERVER Stop Growing MSDB Database by Removing sysmail_mailitems History
Posted by: Journey to SQL Authority with Pinal Dave,
on 25 Nov 2016 |
View original | Bookmarked: 0 time(s)
Received an email "Need your urgent help On Demand, our MSDB Database has grown too big and we need help to check our sysmail_mailitems table. We are also facing performance issues." I have been an independent consultant for a while and one of the services I provide is "On Demand (50 minutes)" service. This service is very helpful for organizations who are in need immediate help with their performance tuning issue. Though, I have set working ours for my regular clients, every single day, I keep two...