OpsGenie vs. SQL Server Business Intelligence Manager

Well suited for cases where you just need to alert relevant team members when alerts and incidents come in and make sure that nothing falls through the cracks. Generally OpsGenie just forwards the alerts it receives and allows you to schedule team members to be on-call. It's good for that simple use case and extra helpful if you have Jira or Atlassian Open DevOps since it has nice integrations with those platforms and you can easily monitor ticket progress. If you don't have those, it would be good to check and see if they integrate with whatever you use to track tickets or bugs. The dashboarding and analytics are relatively basic so if you're looking for extensive and highly customizable analytics, this might not be the right solution.

Incentivized

SQL Server [Business Intelligence] Manager is useful for tracking performance across SSIS, SSRS and SSA and have the data represented in dashboards. It helps improve performance and helps end users. However, several features are redundant for smaller organization that can use the tools that comes with existing Microsoft products. These features also takes time to learn and use.

Incentivized

• Notifying through all the possible way like sms,mail and call.
• Ita shows the activity log it is usefull when your paging team through the incident through that you can check who has acknowledged or not.
• Notify the alerts to engineer as well as you can also add the description about alerts related what is it.
• Here you can schedule for on-call engineers

Incentivized

• Types of alerts
• Dashboard view
• Configurable Alerts

Incentivized

• OpsGenie New Jira design has made it difficult for those not familiar with that style.
• OpsGenie could benefit from nested escalation flows for team schedules. Creating a product alert that uses and Tech Schedule as well as an Incident Manager Schedule that already exists would create less overhead and ease management.

Incentivized

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

Incentivized

They are fully available at all times via chat, phone, or email and follow up thoroughly.

Incentivized

We also looked at PagerDuty but decided to go with OpsGenie as it had more features on the plan we needed compared to PagerDuty which would have required us to spend a lot more for what we felt were non-premium features. Everything felt like an add-on - automation for an additional $20 a user per month seemed like a lot on top of the base plan

Incentivized

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.

Incentivized

• Time savings with configuration of on call schedules and personnel. Quick and easy to make changes on short notice.
• We have essentially eliminated the dropped/missed call complaints which used to be routine. Now customers are quickly connected to us hassle free.

Incentivized

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

Incentivized