This is great, I am new to service broker and wanted to get some questions answered. I set this up and was trying to configure it to run on all the databases. I downloaded all the material and saw the job. I'm assuming in the 2nd step is where I would at the syntax for all databases. Is that correct or does anything else need modified. Thanks
Hi, sorry it has taken so long for me to respond.
The 1st step in the job - script "03_JOB_dba-updStats-ServiceBroker.sql" in the download - stores the records of all dbs, tables that are to be processed. In the example I was using only one db - SBdemo - but that can be easily extended to multiple dbs.
The 2nd step is where the actual work of service broker is being done.
Part 2 of this article goes in detail through the troubleshooting steps when this is not working.
Try going through that and let me know of any issues.
And thanks for trying this out! 🙂
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]