IDERA SQL Diagnostic Manager vs. xMatters

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

We use xMatters for our alerting on critical matters. ServiceNow is our incident management system and it ties into xMatters. When a critical alert is generated it will notify the appropriate party. I'm trying to see if two other departments can use it. We are looking for a refrigeration system and for weather alerts when bad storms are coming

Incentivized

• SQLdm does a good job of providing information at a high level, but also allows me to drill down to specific queries and events if needed. I don't always need to sift through tons of details to get the information I need. It also gives a very wide range of information from SQL specific metrics, to OS metrics, to VM metrics, all the way up to host server metrics.
• I like how the alert and notification system can be customized. For example, if you know a certain server regularly has long-running queries, you can adjust the alert to not fire unless a query has been running for 30 minutes while the rest of the servers fire after 30 seconds. That is very helpful in not being bombarded at dinner with alerts from a server similar to, "I've been at 90% cpu for 26 milliseconds!!!!!!!...and now it's back down to 30%" Good information to know, but not something you need to literally lose sleep over.
• I like how you can configure different servers to be monitored differently. For example, you can have a group of servers called DEVELOPMENT that you can turn on heavier monitoring on so you can test how changes in applications might affect the SQL environment, but in the PRODUCTION group, you may only want to enable the heavier analysis and logging when performance issues are actively being reported.

Incentivized

• Close to real-time alert notifications over preferable options, like phone call, text, email, or app notification.
• Automated incident communication about critical system outages based on alerts received in the system.
• Automated on-call roster and notification deliveries to SME.

Incentivized

• Windows client has some issues. When you have small time intervals for your data collection, it can cause the client to become unresponsive and require you to restart it.
• It takes more time to get the web client running than it does to get the windows client running.
• The visualizations have been the same for the last eight years--could use a little bit of a refresh.

Incentivized

• granular notification settings
• Allowing users to create custom integration templates would provide more flexibility and control over how xMatters integrates with their systems
• Additional built-in integrations with other applications would be an area of improvement.

xMatters has a pretty good UI. However, its versatility does get in the way a little as the number of options can be overwhelming, and it sometimes takes a while to find the place you want, or get the result you want. I don't have any suggestions on how to fix this, it's just a side effect of the complexity that xMatters offers.

Incentivized

Working with xMatters support has been fantastic! Our support rep is very friendly, helpful, and knowledgeable. We get quick response times when asking questions, and when we have more complex problems, it's easy to schedule a call and spend some time working through our issues together. Every time we've had a problem we've been able to get the info we need and get a resolution easily.

Incentivized

IDERA SQL Diagnostic Manager for SQL, Redgate SQL, and MonitorLogicMonitor are similar products to each other. We decided on IDERA SQL Diagnostic Manager for SQL because our experience with locating heavy queries has been very good and it provides real-time monitoring of all servers and databases. It also allows you to have a large volume of historical data which allows you to analyze trends in the databases.

Incentivized

xMatters is a market leader among many new burgeoning products in the stakeholder notification space. They are historically one of two original enterprise products in this space. Great client base of large companies and good reputation. xMatters offers flexible licensing models, depending on functional needs. It's easy to learn and use but slightly more difficult to administer.

Incentivized

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

Incentivized

• Quicker response times for on-call personnel.
• Managers are able to pull reports faster for any incidents escalated to their team.
• When needing to contact another on-call associate from another team, xMatters provides conference bridge lines. You don't have to set up meetings through Outlook or Skype.

Incentivized