Thank you for you comment.
I need to add 2 comments to the article:
1) You need to setup queue monitoring !
If things fail, your server may blow up really fast, depending on the number of logins occuring.
msdb may grow, or the db where you defined your queues
2) Until now, SSB did freeze on 4 of our +200 instances.
Mostly the reason was the query on the queue received a "insufficient memory to complete the query" notification, causing the sproc to fail. Queue blew up, until disk got full !
If was a hell of a job to analyse the root cause and to clean it up.
I needed to beg for more ram on these very small systems, but they got fixed 😉
In a single case, the sproc was just to slow to cope with the queue load. After the modification to using the checksum column, things are running smoothly. :w00t:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me