Re: I see data gaps in the reports, anything I can do to prevent this?
There are a few things you can do:
1. Restart the SSRS service 2. Make sure the ETL has ran successfully 3. Make sure there is no network connectivity issue 4. Make sure there is no odbc connectivity issue.
You can also enable SAFing on the Monitoring nodes, this temporary stores data into the local node and when connectivity is restored pushes data into the Management node so that it can be pushed into SQL Server.