Our sysreplicationalerts table in MSDB is over 200MB alone. Does anyone know how I can shrink this table? I've used sp_delete_backuphistory to shrink MSDB backupset table...but don't find anything for sysreplicationalerts. Any ideas are appreciated!
I'll have to look, working on a deadline at work so it may be a day or two! You should check the verbose setting of your repl agents, maybe set to do less logging.