IDERA SQL Diagnostic Manager for SQL Server vs. Microsoft System Center Operations Manager (SCOM)

If you have several SQL servers and don't have a lot of time or resources to constantly monitor them, SQLdm will be very helpful. For one or two servers, it might be overkill. All of our servers are virtual, so having a tool that can monitor host metrics as well as guest metrics is a plus as well.

Incentivized

More appropriate for:

• Pure Microsoft ecosystem environments (Windows Server and SQL server) and the most common Linux and UNIX platforms.
• Environments where cost is less of a factor than settling on a single platform for monitoring
• Environments where the administrators are familiar with the setup and installation of SCOM.

Less appropriate for:

• Pure UNIX/Linux shops, especially versions not supported out of the box by SCOM.
• Shops that cannot afford the engagement to setup/configure and maintain on a continuous basis.
• Shops that cannot dedicate personnel to the care and feeding of SCOM, especially when supporting larger environments.

Incentivized

• Database query optimization.
• Monitoring of databases in real time.
• Performance analysis and trends in the database.

Incentivized

• Allows us to visualize our systems in a single interface and see the status of health as well as relevant performance metrics.
• A flexible and powerful interface with active alerting covering domain controllers, SQL servers, etc...
• Allows you to customize your views and workspaces for specific tasks and needs.
• Reporting is powerful and flexible.

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

• One of the biggest drawbacks to SCOM is the sheer scope and complexity of the system. This can be a pro and a con. The system is very customizable, what you put into it is what you'll get out of it. That said, the learning curve is fairly steep. An organization needs to be committed to putting time and resources into SCOM to get the most out of it. I've heard stories from colleagues of several different companies that invested in SCOM and then abandoned it due to the excessive time and care required.
• SCOM is expensive. Not only is the enterprise licensing costly, SCOM requires it's own servers, operational and warehouse databases to be maintained.
• The OOB SCOM reports are a bit clunky and feel outdated.

Incentivized

Hard to get support. The product is not being actively developed anymore, so it is hard to get new features for the product.

Incentivized

IDERA SQL Diagnostic Manager for SQL Server is an excellent tool, however I think Solarwinds Database Perfromance Analyzer is a slightly stronger more well rounded product

Incentivized

We used Altiris and WSUS and in the beginning Altiris had the better admin interface than SCOM, but it is no longer the case as SCOM has refined their admin interface. Altiris still has better and more robust group assignments for management roles and those two other tools can better manage non Windows OS devices than SCOM but for a large enterprise Windows shop, if you can afford it, SCOM is the way to go.

Incentivized

• It saves me a significant amount of time each week, freeing me up for other important tasks. I couldn't possibly monitor each server individually to the extent that SQLdm does.
• With the wealth of information I can get to easily, I can be more proactive in taking care of my environments rather than reactive. The times when other people notice something happening before I do are few and far between.

Incentivized

• It has allowed us to provide an Enterprise Event/Alert management solution to the Global company
• It has taken a long time to get it to provide valuable alerts and information, lots of user resources and investment.
• It assists with 24/7 monitoring and out of hours support

Incentivized