Filling up msdb
Somehow my database using service broker got messed up and then all the messages started filling up msdb, I am using it to monitor object access and such, so nothing critical, but filling up my msdb is critical, what I want is some way to use the service
broker to send these events but to have then expire after an hour or so if they aren't picked up. This way the msdb won't fill up, is this
August 19th, 2015 1:30pm
Check to see what event notifications are setup by querying sys.server_events_notifications and it should be only one entry: like you mentioned. Also Query sys.transmissions_queue to see how many events are in the queue
I think you might have the Queue to be cleared which can be done by creating a new broker. To do this execute
ALTER DATABASE msdb SET NEW_BROKER.
Make sure to Have Full backups in place before you perform ALTER
You can also refer to this article
Free Windows Admin Tool Kit Click here and download it now
August 19th, 2015 3:47pm