Diagnostic Tools

Using these tools to monitor your load is WAY easier than what SQL Server has built out for you in the case of looking after your SSIS packages.

For other processes, I freely admit that the reporting and monitoring tools in SQL Server Agent are my go to.