The new way to monitor BI - SQL Server Business Intelligence Manager
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.
Pros
- Shows an excellent dashboard
- Allows easy monitoring of multiple instances
- Created an environment that can be self healing
Cons
- Drill down can kind of be cumbersome
- Deep knowledge is needed to understand metrics
- Some light training is needed to take advantage of all features
- 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.
Comments
Please log in to join the conversation