SQL Diagnostic Manager for Microsoft SQL Server helps database administrators to find and fix Microsoft SQL Server performance problems in physical, virtual, and cloud environments. Unlike its competition, it provides effective scalability, advanced SQL query analysis and optimization, prescriptive analysis with corrective SQL scripts, powerful automated alert responses, broad PowerShell integration, complete customization, and extensive support for current and legacy Microsoft SQL Server and…
$1,996
per instance with first year maintenance included
Microsoft Power BI
Score 8.5 out of 10
N/A
Microsoft Power BI is a visualization and data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in governance and security.
$168
per year per user
Pricing
IDERA SQL Diagnostic Manager
Microsoft Power BI
Editions & Modules
Standard via eCommerce
1,996.00
per instance with first year maintenance included
Power BI Pro
$14
per month (billed annually) per user
Power BI Premium
$24
per month (billed annually) per user
Offerings
Pricing Offerings
IDERA SQL Diagnostic Manager
Microsoft Power BI
Free Trial
Yes
Yes
Free/Freemium Version
No
Yes
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
Power BI Desktop is the data exploration and report authoring experience for Power BI, and is available as a free download.
More Pricing Information
Community Pulse
IDERA SQL Diagnostic Manager
Microsoft Power BI
Features
IDERA SQL Diagnostic Manager
Microsoft Power BI
SQL Performance Monitoring
Comparison of SQL Performance Monitoring features of Product A and Product B
IDERA SQL Diagnostic Manager
8.0
7 Ratings
5% below category average
Microsoft Power BI
-
Ratings
Performance dashboard
9.07 Ratings
00 Ratings
Intelligent alerting
8.07 Ratings
00 Ratings
Top SQL
9.07 Ratings
00 Ratings
Historical trend data
9.06 Ratings
00 Ratings
Virtualization support
5.06 Ratings
00 Ratings
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
IDERA SQL Diagnostic Manager
-
Ratings
Microsoft Power BI
8.3
197 Ratings
1% above category average
Pixel Perfect reports
00 Ratings
8.3168 Ratings
Customizable dashboards
00 Ratings
8.7196 Ratings
Report Formatting Templates
00 Ratings
8.0179 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
IDERA SQL Diagnostic Manager
-
Ratings
Microsoft Power BI
8.0
195 Ratings
0% below category average
Drill-down analysis
00 Ratings
8.3192 Ratings
Formatting capabilities
00 Ratings
7.8192 Ratings
Integration with R or other statistical packages
00 Ratings
7.4143 Ratings
Report sharing and collaboration
00 Ratings
8.4190 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
IDERA SQL Diagnostic Manager
-
Ratings
Microsoft Power BI
8.0
188 Ratings
3% below category average
Publish to Web
00 Ratings
8.3178 Ratings
Publish to PDF
00 Ratings
8.0173 Ratings
Report Versioning
00 Ratings
7.7145 Ratings
Report Delivery Scheduling
00 Ratings
8.3148 Ratings
Delivery to Remote Servers
00 Ratings
7.9111 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
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.
Has significantly improved collation of data and visualisation especially with business across Europe. Has given me the ability to see the Site availability at the click of a button to see which Site is in the "money" and seize opportunities based on Market data
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.
Options for data source connections are immense. Not just which sources, but your options for *how* the data is brought in.
Constant updates (this is both good and bad at times).
User friendliness. I can get the data connections set up and draft some quick visuals, then release to the target audience and let them expand on it how they want to.
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.
Microsoft Power BI is an excellent and scalable tool. It has a learning curve, but once you get past that, the sky is the limit and you can build from the most simple to the most complex dashboards. I have built everything from simple reports with only a few data points to complex reports with many pages and advanced filtering.
Automating reporting has reduced manual data processing by 50-70%, freeing up analysts for higher-value tasks. A finance team that previously spent 20+ hours per week on Excel-based reports now does it in minutes with Microsoft Power BI's automated Real-time dashboards have shortened decision cycles by 30-40%, enabling leadership to react quickly to sales trends, operational bottlenecks, and customer behavior.
It is a fantastic tool, you can do almost everything related with data and reports, it is a perfect substitutive of Power Point and Excel with a high evolution and flexibility, and also it is very friendly and easy to share. I think all companies should have Power BI (or other BI tool) in their software package and if they are in the MS Suite, for sure Power BI should be the one due to all the benefits of the MS ecosystem.
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.
Microsoft Power BI is free. If I didn't want to create a custom platform (i.e. my organization insisted on an existing platform that I *had* to use), I'd use Microsoft Power BI. For any start-up or SMB, I'd just use Claude & Grok to build it quickly, also for free. Would not pay for Tableau or Sigma anymore. Not worth it at all.