TrustRadius: an HG Insights company

SQL Server Business Intelligence Manager

Score7 out of 10

35 Reviews and Ratings

Get a Demo

What is SQL Server Business Intelligence Manager?

Houston-based Idera's SQL Server Business Intelligence Manager is an IT infrastructure monitoring option.

Categories & Use Cases

Key Features

Learn about the best (and worst!) features SQL Server Business Intelligence Manager has to offer, as determined by TrustRadius' reviewers.
Based on 35 ratings of SQL Server Business Intelligence Manager's features
View all features

Top Performing Features

  • Intelligent alerting

    Customizable alerts and reports indicating outlier values from baseline

    Category average: 7.9

  • Top SQL

    Details about any long-running or high impact statements

    Category average: 8.6

  • Performance dashboard

    Dashboard displays consolidated data with drill-down capability

    Category average: 9

Areas for Improvement

  • Historical trend data

    Historical trends and anomalies for SQL tuning

    Category average: 8.6

  • Virtualization support

    Root cause analysis for virtual platforms like VMWare or Hyper-V

    Category average: 8.3

Reviews

What users are saying about SQL Server Business Intelligence Manager.
View all reviews

Great monitoring and alerting for MS SSAS, SSRS and SSIS

Incentivized
Gedson SilvaView profile
Senior Production Engineer in Engineering at Carrilho Engineering (11-50 employees employees)

Pros

  • Great monitoring capabilities for SSAS, SSRS, and SSIS.
  • Tuning features for SSAS cubes.
  • Configurable alerts.

Cons

  • Some advanced features are hard to get without proper training.
  • Usability has room for improvement.

Return on Investment

  • 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.

Monitoring solution for Microsoft Based Products

Incentivized
Verified User
Manager in Information Technology (201-500 employees employees)

Pros

  • It can be used to monitor SSIS, SSRS and SSAS
  • Provides Dashboards to view performance
  • Works well with Microsoft products

Cons

  • 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

Return on Investment

  • It helped improve performance for SSIS,SSRS and SSAS
  • Helped Improve performance for end users and customers

Other Software Used

Microsoft Power BI, Tableau Desktop, Tableau Online

Good product just not a fit for us

Incentivized
Verified User
Manager in Information Technology (201-500 employees employees)

Pros

  • Types of alerts
  • Dashboard view
  • Configurable Alerts

Cons

  • 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

Return on Investment

  • Being a small shop with a small SQL Server BI footprint it was not worth the price

Alternatives Considered

IDERA SQL Diagnostic Manager for SQL Server, SolarWinds Database Performance Monitor (formerly VividCortex), Spotlight, Redgate SQL Monitor and SQL Sentry

Other Software Used

Visual Studio IDE, SQL Server Integration Services, Microsoft SQL Server, IDERA SQL Diagnostic Manager for SQL Server, IDERA SQL Safe Backup, IDERA SQL Doctor, Redgate SQL Compare, Redgate SQL Data Compare

The new way to monitor BI - SQL Server Business Intelligence Manager

Incentivized
Samir Patel, PMPView profile
SQL Development Team Lead in Information Technology at Allianz Asset Management (1001-5000 employees employees)

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

Return on Investment

  • More efficiencies throughout the BI stack
  • Less employees needed for monitoring all the BI processing
  • Proactive error handling

Alternatives Considered

Solarwinds Database Performance Analyzer for SQL Server

Other Software Used

SAP Business Objects, Oracle Advanced Analytics, SQL Server Data Access Components (SDAC)

My experience with BIDS

Incentivized
Verified User
Director in Engineering (11-50 employees employees)

Pros

  • Easy to use GUI
  • Integrates nicely with SQL Server
  • Simple single server deployment

Cons

  • Lacks versioning control.
  • Lacks support/native driver for alternative database.
  • Only plays well with other Microsoft products.

Return on Investment

  • 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.

Alternatives Considered

Amazon Redshift, Matillion and RedPoint Data Management & Quality

Other Software Used

Tableau Desktop, Tableau Server, Tableau Prep