In previous versions of SQLWATCH this was every 1 minute. Since version 3.0, the data collection is invoked via SQL Agent, every 10 seconds. This is something that has been in my head for few months or even years. Service broker is included in every edition including Express and is exceptionally reliable, although not the easiest to use. Service broker can execute stored procedure when a new message is added to the queue and it happens in real-time. SQL Server Service Broker is SQL Server built-in messaging and queuing mechanism that supports internal and external content. Sadly, there have been zero responses from the community, so I made my own decision. Some time ago I asked on GitHub whether we should move to using SQL Server Service Broker rather than SQL Agent jobs.
0 Comments
Leave a Reply. |