Redgate Monitor vs. SQL Server Business Intelligence Manager

Redgate SQL Monitor is well suited for database administrators or companies who implement software that relies on SQL servers. It will help them test new changes and ensure this will not impact the performance of their software. It is a last resort for MSPs to use to get to the bottom of an ongoing performance issue with their SQL server.

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

• It will tell you if your server is under attack.
• You can quickly see how your server is performing and which queries are taking the longest
• I gives you the feeling that you are in control of your database, that you know what is going on for when they users ring up and tell you that the server is slow

Incentivized

• Types of alerts
• Dashboard view
• Configurable Alerts

Incentivized

• Incremental releases can be buggy
• Isn't the best for pinpointing performance issues
• Web interface can be sluggish

Incentivized

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

Incentivized

Access to metrics is simple but I like easy access to top SQL

Fast support responses from Redgate

Incentivized

Redgate SQL Monitor is a lot cheaper than SolarWinds Database Performance Analyzer. I prefer the SolarWinds' design and that it offers integration with other SolarWinds products we already use. SolarWinds supports more than SQL servers (Oracle, MySQL, Maria DB, IBM DB2) and the analysis seems to be much better. The Spiceworks SQL Server monitoring is a free tool and is ideal for monitoring small business SQL instances.

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

• The quality of the product and give a negative investment impression, on the plus side when it does work it is a god send.
• Day to day tasks as made simpler, and a feeling of security of realised. Just don't change anything.

Incentivized

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

Incentivized