Overall Satisfaction with SQL Server Business Intelligence Manager
We were using SQL Server BI Manager to monitor the health and availability of our entire SQL Server BI environment. This includes SSIS, SSRS and SSAS. The business problems that this addresses are all related to ensuring our customers get the best BI solutions available. Currently it is being used by our reporting department, but we assume it might spread shortly.
- More efficiencies throughout the BI stack
- Less employees needed for monitoring all the BI processing
- Proactive error handling
We compared SQL Server Business Intelligence Manager to our current tool Solarwinds Database Performance Analyzer. Where Solarwinds was deficient, SQL BI manager filled the gap. At the end of the day they were both different tools with different purposes so we concluded it was best to have both for our organization.
SQL Server Business Intelligence Manager is well suited for organizations with large scale BI deployments. When tracking all of your SSIS, SSAS and SSRS processes that are spread out and disjointed, this tool will enable one user to get a holistic view of the whole environment. If you want to be proactive in handling performance issues before they happen, then this tool is good too.