June 28, 2006 at 10:40 am
I am thinking of changing my SQL monitoring application to use Service Broker.
Right now I have code that loops through all my servers, checking a number of things on each server, what I check varies on time of day. All sequentially.
This is starting to take a while as the number of servers grows.
I was thinking I would push the individual tasks into queues so that I can run against multiple servers at the same time. But I don't want to run more that 1 task on each server at any one time.
I would have a queue for 'Check Dump Status', 'Check Agent Jobs', ', Check for new databases' etc. On each queue I would push the name of the server to check. Some servers get everything checked, some only get some of the tasks,
I think I can use Conversation Groups to do this but I'm not sure.
Any ideas?
June 28, 2006 at 10:41 am
The title should be 'Conversation Groups'
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply