Greetings!
As a DBA, make sure you monitor the 11 VitalSigns used by SQLRx to debug performance bottlenecks. In addition to monitoring these items, here's a helpful script to prevent MSDB bloat.
|
 SQL Server Administration: Make sure to keep the system database MSDB maintained. When DatabaseMail is enabled, it's important to clean up old mail attachments and logs to prevent MSDB bloat. Here is a script designed to clean up mail attachments and logs more than 5 days old.
DECLARE @d DATETIME
SET @d = DATEADD(dd, -5, GETDATE())
EXECUTE msdb.dbo.sysmail_delete_mailitems_sp @sent_before = @d
EXECUTE msdb.dbo.sysmail_delete_log_sp @logged_before = @d
|
