Good product just not a fit for us
We used it to monitor our SSIS and SSRS environments for a few years company wide. We had it to go along with our SQL Diagnostics Manager …
Overview
What is SQL Server BI Manager?
Houston-based Idera's SQL Server Business Intelligence Manager is an IT infrastructure monitoring option.
Recent Reviews
Pricing
N/A
Unavailable
What is SQL Server BI Manager?
Houston-based Idera's SQL Server Business Intelligence Manager is an IT infrastructure monitoring option.
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
1 person also want pricing
Alternatives Pricing
N/A
Unavailable
What is LogicMonitor?
LogicMonitor provides an agentless SaaS-based monitoring platform. LogicMonitor provides prebuilt integrations and an open API, and is designed to provide monitoring across networks, servers, applications, websites, and containers, including insights and reporting capabilities.
What is SolarWinds SQL Sentry?
SolarWinds SQL Sentry is designed to help data professionals optimize SQL Server database performance in physical, virtual, and cloud environments. SQL Sentry delivers metrics to help users find and fix database performance problems and provides scalability, boasting demonstrated success monitoring…
Product Details
- About
- Tech Details
- FAQs
What is SQL Server BI Manager?
SQL Server BI Manager Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
Houston-based Idera's SQL Server Business Intelligence Manager is an IT infrastructure monitoring option.
Reviewers rate Intelligent alerting and Top SQL highest, with a score of 8.5.
The most common users of SQL Server BI Manager are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(35)Reviews
(1-5 of 5)Companies can't remove reviews or game the system. Here's why
July 26, 2021
Good product just not a fit for us
We used it to monitor our SSIS and SSRS environments for a few years company wide. We had it to go along with our SQL Diagnostics Manager product so we could have an end to end monitoring solution for our entire environment.
- Types of alerts
- Dashboard view
- Configurable Alerts
- Not the most intuitive product
- The basic features are easy to use, the more advanced features are more difficult to use than they should be
- Drill Down is clunky
76%
7.6
- Being a small shop with a small SQL Server BI footprint it was not worth the price
- IDERA SQL Diagnostic Manager for SQL Server, SolarWinds Database Performance Monitor (formerly VividCortex), Spotlight, Redgate SQL Monitor and SQL Sentry
For our small environment, we already had Idera SQL Diagnostics manager so we felt like that would be good enough and not pay for the extra licensing. If we had a bigger BI footprint, we could certainly have had a good business case for it.
2
We used it for our systems administration group to maintain the health of the environment. Our DBA's also used it for troubleshooting performance issues. Developers used it to identify usage patterns and help with performance tuning.
May 13, 2021
Monitoring solution for Microsoft Based Products
SQL Server [Business Intelligence] Manager was used by our organization to track SQL Server Bi Platforms (SSIS, SSRS, SSAS) and collect performance related data. It was being used by our IT and Business Intelligence Department to improve performance for end users.
- It can be used to monitor SSIS, SSRS and SSAS
- Provides Dashboards to view performance
- Works well with Microsoft products
- Training is needed to understand and use all the feature
- Works well only with Microsoft products
- Not enough Tutorials available
- Features are more useful for larger organization
52%
5.2
- It helped improve performance for SSIS,SSRS and SSAS
- Helped Improve performance for end users and customers
SQL Server [Business Intelligence] Manager works well with Microsoft products. It has several advanced features along with dashboards and alerts that can be configured to user's need.
July 07, 2019
My experience with BIDS
We used BI Manager to develop and maintain all of our ETL packages.
- Easy to use GUI
- Integrates nicely with SQL Server
- Simple single server deployment
- Lacks versioning control.
- Lacks support/native driver for alternative database.
- Only plays well with other Microsoft products.
64%
6.4
- Allows us to quickly set up ETL processes as soon as we installed SQL Server.
- There's a lot of free/paid resources available online, decreasing development time.
- A tool with plenty of experienced developers.
- Amazon Redshift, Matillion and RedPoint Data Management & Quality
SQL servers are much easier to set up than the others but they lack the customization and integration with other popular DB.
April 05, 2019
Great monitoring and alerting for MS SSAS, SSRS and SSIS
We're using SQL Server Business Intelligence Manager to monitor our SQL Server BI platforms (analysis services, reporting services, and integration services). It's great at collecting metrics and KPIs regarding query execution and performance for SSAS in both standard and cube models, and also provides great insights for packages executed by SSIS.
- Great monitoring capabilities for SSAS, SSRS, and SSIS.
- Tuning features for SSAS cubes.
- Configurable alerts.
- Some advanced features are hard to get without proper training.
- Usability has room for improvement.
80%
8.0
- We've prevented several SSAS outages because of SQL Server Business Intelligence Manager's timely alerts.
- We've greatly reduced cubes calculation times with SQL Server Business Intelligence Manager's tuning features.
SQL Server Business Intelligence Manager does what SQL Server Management Studio should already do natively. So it actually fills up important gaps Microsoft left in its product.
November 09, 2016
The new way to monitor BI - 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.
- Shows an excellent dashboard
- Allows easy monitoring of multiple instances
- Created an environment that can be self healing
- 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.