Try our new research platform with insights from 80,000+ expert users

Foglight for Databases vs IDERA ER/Studio comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Nov 23, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
7.3
Users describe Foglight for Databases as invaluable for reducing downtime, saving time, and ensuring proactive database management.
Sentiment score
5.8
Users appreciate IDERA ER/Studio for ease, graphical presentation, and efficiency, despite not fully utilizing its capabilities.
For root cause analysis, it definitely provides us additional capabilities of getting down to where the core issue is.
Global Head of Engineering for Cloud Operations at SAI Global Compliance
 

Customer Service

Sentiment score
7.7
Foglight for Databases support is praised for prompt, knowledgeable service, though occasional delays are noted by some users.
Sentiment score
7.1
IDERA ER/Studio's customer support is praised for responsiveness and professionalism, despite occasional delays, especially for East Coast users.
Generally, whenever we send something to them, we get a response within a few hours, and it is pretty straight to the point.
Global Head of Engineering for Cloud Operations at SAI Global Compliance
We use support when we come across issues, and they are very responsive.
Senior IT Manager at a wholesaler/distributor with 1,001-5,000 employees
There is plenty of documentation available online for assistance, making it straightforward to address any issues.
Managing Partner at DXC Technology
 

Scalability Issues

Sentiment score
6.9
Foglight for Databases scales well for growing needs, enhancing reports and extending adaptability beyond SQL Server.
Sentiment score
7.4
Most users find it scalable; performance improves in new versions, especially using cloud environments for large data models.
It scales well to teams of one hundred plus people.
Works at a energy/utilities company with 10,001+ employees
 

Stability Issues

Sentiment score
8.2
Foglight for Databases generally performs well with stable support, though some users face issues with updates and larger loads.
Sentiment score
7.8
IDERA ER/Studio is generally stable, though occasional issues exist with older versions, complex models, and server performance.
Erwin is a very stable product.
Works at a energy/utilities company with 10,001+ employees
 

Room For Improvement

Users seek better performance, customization, interface simplicity, real-time monitoring, communication, language support, and integration of feedback in Foglight.
IDERA ER/Studio needs deployment, licensing, documentation, performance, and feature enhancements for better user experience and functionality.
It would be amazing if they could enable the 'Performance Investigator' functionality across all database platforms.
Senior IT Manager at a wholesaler/distributor with 1,001-5,000 employees
The monitoring capabilities for Postgres should be at par with SQL Server.
Global Head of Engineering for Cloud Operations at SAI Global Compliance
Both Erwin and ER/Studio do not have AI or machine learning features for automation.
Works at a energy/utilities company with 10,001+ employees
 

Setup Cost

Foglight for Databases offers flexible licensing and pricing, considered reasonable yet expensive, with helpful discounts and contract negotiations.
IDERA ER/Studio is costly and complex to license, but many find its features offer valuable returns.
Pricing is very reasonable.
Global Head of Engineering for Cloud Operations at SAI Global Compliance
The pricing is palatable.
Senior IT Manager at a wholesaler/distributor with 1,001-5,000 employees
The setup cost may have been around $1500 to $2000.
Data Modeler at Ascendion
In terms of pricing, ER/Studio is slightly more expensive compared to Erwin, by about five to ten percent.
Works at a energy/utilities company with 10,001+ employees
 

Valuable Features

Foglight for Databases provides comprehensive monitoring, detailed query analysis, multi-platform support, and customizable dashboards for efficient troubleshooting.
IDERA ER/Studio enables comprehensive data modeling, collaboration, and automation with user-friendly interfaces and integration with versioning tools.
The profiler allows us to look at the profiles of the database queries that are being run over time.
Global Head of Engineering for Cloud Operations at SAI Global Compliance
I find it extremely helpful to use Foglight to triage any database issues, specifically performance issues using what Foglight calls PI investigator.
Senior IT Manager at a wholesaler/distributor with 1,001-5,000 employees
When we built an application, it facilitated the development process by providing the skeleton of the application and the foundation for functions.
Managing Partner at DXC Technology
It has strong versioning support and can even integrate with third-party versioning tools like GitHub.
Works at a energy/utilities company with 10,001+ employees
 

Categories and Ranking

Foglight for Databases
Ranking in Database Development and Management
2nd
Average Rating
8.4
Reviews Sentiment
7.2
Number of Reviews
14
Ranking in other categories
No ranking in other categories
IDERA ER/Studio
Ranking in Database Development and Management
8th
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
38
Ranking in other categories
Enterprise Architecture Management (7th)
 

Mindshare comparison

As of January 2026, in the Database Development and Management category, the mindshare of Foglight for Databases is 3.8%, down from 7.6% compared to the previous year. The mindshare of IDERA ER/Studio is 2.5%, down from 2.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Database Development and Management Market Share Distribution
ProductMarket Share (%)
Foglight for Databases3.8%
IDERA ER/Studio2.5%
Other93.7%
Database Development and Management
 

Featured Reviews

Stuart Dairiki - PeerSpot reviewer
Senior IT Manager at a wholesaler/distributor with 1,001-5,000 employees
Empowers efficient database monitoring and performance troubleshooting with powerful workload analysis
I find it extremely helpful to use Foglight to triage any database issues, specifically performance issues using what Foglight calls PI investigator. It is a very powerful workload analysis tool that helps me understand where bottlenecks are. It allows me to see performance issues as end users report them. It can save time and effort when doing root cause analysis. It enables me to obtain information quicker and easier compared to manually compiling it. Foglight provides us with a near-real-time activity database. It's not 100% real-time. It has less than a minute latency. It allows us to see performance issues as end-users report them. We started seeing benefits pretty much immediately. We use Foglight to display intensive databases. However, it's not something we monitor regularly. It's only something we kind of dig into as we troubleshoot and triage issues. It does help us determine potential IT help issues. When we use Foglight, we find it helps drill down holistically into potential bottlenecks. It helps us to see what is going on in the database. Foglight allows us to monitor multiple database platforms. We use, for example, Oracle, SQL Server, Postgres, Amazon Redshift, and SAP HANA. It gives us insight into our entire landscape of production workloads in near real-time. The solution saves costs when performing root cause analysis. It can save time and effort when doing root cause analysis. It allows us to obtain information quicker and easier than by manually compiling information.
KP
Works at a energy/utilities company with 10,001+ employees
Enables large teams to collaborate seamlessly with comprehensive integration and strong versioning support
ER/Studio is excellent for large teams; it scales well to teams of over one hundred plus people. It has strong versioning support and can even integrate with third-party versioning tools like GitHub. It has a rich set of integration options with various products in the market. The tool also supports both logical and physical data modeling, and it has out-of-the-box support for data vault methodologies. ER/Studio allows the enforcement of naming conventions, which is beneficial for maintaining standards within the organization.
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
879,899 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
13%
Government
11%
Manufacturing Company
10%
University
6%
Energy/Utilities Company
14%
Financial Services Firm
13%
Manufacturing Company
8%
Computer Software Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business2
Midsize Enterprise2
Large Enterprise10
By reviewers
Company SizeCount
Small Business4
Midsize Enterprise11
Large Enterprise25
 

Questions from the Community

What is your experience regarding pricing and costs for Quest Foglight for Databases?
The pricing is palatable. We've already done one renewal and we are in our second contract. We're happy thus far.
What needs improvement with Quest Foglight for Databases?
It would be amazing if they could enable the "Performance Investigator" functionality across all database platforms. I've been talking to their product development team about enhancements that I wo...
What is your primary use case for Quest Foglight for Databases?
I primarily use the solution for database monitoring, specifically for Oracle, Microsoft SQL Server, Postgres, SAP HANA, and AWS Redshift.
What is your experience regarding pricing and costs for IDERA ER Studio?
In terms of pricing, ER/Studio is slightly more expensive compared to Erwin, by about five to ten percent.
What is your primary use case for IDERA ER Studio?
I have been working with data modeling tools. Personally, I have been working with Erwin for many years now. ER/Studio is something I am currently trying to evaluate for acquiring it for our organi...
What advice do you have for others considering IDERA ER Studio?
I would strongly recommend ER/Studio for large teams. Erwin is a very stable product, but for smaller teams, it's okay. If I had to rate ER/Studio, I would give it nine out of ten because the absen...
 

Also Known As

No data available
IDERA ER Studio, ER/Studio, ER/Studio Enterprise Team Edition
 

Overview

 

Sample Customers

CommitDBA
Newmont Mining, Entrust, Accolade, TalkTalk, Catalina, Protective Life, NTT Data, dir systèmes, Microsoft; American Express, Astellas Pharma, AstraZeneca, Coriant, Fedex, GlaxoSmithKline, PepsiCo, Prudential, Wells Fargo
Find out what your peers are saying about Foglight for Databases vs. IDERA ER/Studio and other solutions. Updated: December 2025.
879,899 professionals have used our research since 2012.