• Running te collection scripts and storing to a central monitoring server using powershell scripts is a pretty powerful option as well, and one I personally quite like.

    SSIS is a good tool, I have used it a lot, but with having a DEV background, I find making changes a lot easier - if you have a fairly dynamic SQL Server estate - using PoSh scripts. Here you can just add / remove servers from a list (held in a table or file) as you comission / decomission instances. It's also easy to add additional monitoring simply by adding a module to your PoSh script

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.