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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics