No more typing reviews! Try our Samantha, our new voice AI agent.

Foglight for Databases vs Terracotta comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 1, 2026

Review summaries and opinions

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

Categories and Ranking

Foglight for Databases
Ranking in Database Development and Management
1st
Average Rating
8.6
Reviews Sentiment
6.5
Number of Reviews
33
Ranking in other categories
No ranking in other categories
Terracotta
Ranking in Database Development and Management
20th
Average Rating
7.0
Reviews Sentiment
7.8
Number of Reviews
1
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2026, in the Database Development and Management category, the mindshare of Foglight for Databases is 3.9%, down from 4.4% compared to the previous year. The mindshare of Terracotta is 1.1%, up from 0.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Database Development and Management Mindshare Distribution
ProductMindshare (%)
Foglight for Databases3.9%
Terracotta1.1%
Other95.0%
Database Development and Management
 

Featured Reviews

AkshayChaudhari - PeerSpot reviewer
Data Specialist at TCS
Centralized monitoring has reduced troubleshooting time and improves visibility across databases
I would improve the user interface of Foglight for Databases, as I feel it is somewhat complex, especially when using the specific troubleshooting view, particularly for new users. I would also appreciate more flexibility when customizing the dashboards and alerts, so better prioritization based on impact would be beneficial. Reporting could also be more straightforward with more ready-made reports and easier customization. Clearer recommendations during troubleshooting would help users move from identifying a problem to understanding the likely root cause. There is still room for improvement in the user interface, reporting, and alert customization, but overall Foglight for Databases has been valuable.
reviewer2727468 - PeerSpot reviewer
Senior Application Engineer at a comms service provider with 11-50 employees
Enhancing User Experience with Clustering While Potential Exists for Better Customization
My total experience with Terracotta is installing it in the architecture to do the clustering in WebMethods Integration Server. This provided to tackle the memory and the processes of those servers in the same pool. Terracotta, as per my understanding, is used for caching. The first function is used for clustering the requests. Regarding improvements, I cannot imagine what could be improved because my actual work in Integration Server is not totally restricted to Terracotta. The main function was restricted to developing services using integration servers in Software AG. The use of Terracotta is just for implementing caching. In this part, I create a cache manager for this response, and from a UI perspective, I am unable to suggest improvements.

Quotes from Members

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

Pros

"Foglight offers a lot of out-of-the-box, database-related metrics, which the DB teams here are looking for."
"Foglight is also able to help the DBAs proactively fix problems before they become an issue. It provides them with real-time activity screens that help in this regard. The DBAs are able to go to these screens and look at what's happening in real time, and that buys them time. It helps them see problems ahead of time and find solutions to them."
"From my experience as a user for almost nine years, I can say that it is a great product and a good investment for monitoring databases, especially in a SQL Server environment."
"Foglight for Databases allows us to save up to four months of data, enabling us to track performance data for at least one quarter."
"It's a great product, it's probably one of the best in this class and people should not hesitate getting on board with the product."
"We were able to see its benefits immediately, quickly identifying issues by drilling down into real-time activity to find the query causing slowdowns and address it."
"Based on my experience, I would estimate we are able to resolve database-related performance issues about thirty to forty percent faster than before."
"Foglight for Databases offers valuable features including the ability to view and compare historical data against the current workload, which is invaluable for understanding any changes or issues and for responding to client inquiries where I can drill down to identify the exact users and queries that are creating problems."
"The impact of Terracotta's high availability and failover capabilities on the organization's data consistency and reliability is significant."
 

Cons

"Foglight for Databases could improve by offering a more intuitive, responsive user interface, easier initial configuration, and more customizable dashboards."
"The data model needs improvement when it comes to creating custom reports. That is an area where it needs a bit of improvement. Foglight gathers a lot of information around our databases as part of its monitoring. While I know all this information is in there, trying to pull the metric we want out for custom reports is sometimes hard to find. One nice thing about Foglight is that you can create custom dashboards, which you can easily convert to reports. We would be doing a lot more of that if it weren't for the challenging data model."
"One thing that I would like, and it's probably something that I could set up internally, is something other than a dashboard which I have to look at to know that a server is down. I'd like bells and whistles to go off... If I look at the dashboard I know there's a server down. But if I'm not looking at it, if I'm looking at some other problem, I want to know about it. You can do that, you can use SMSs and alerts to your phone, and I could set it up to handle that, but it would be nice if, out-of-the-box, Foglight did that."
"It would be amazing if they could enable the "Performance Investigator" functionality across all database platforms."
"It is a good tool, but I would like to see improvements in the dashboard for a more user-friendly experience or to get all the details on a single screen."
"The system is not that stable. We have been facing a lot of issues. We built a new store environment of Foglight, an environment for monitoring the Lowe's store servers, which are all Db2 servers. The objective is to monitor 800 Db2 servers in each Foglight instance. Up to 150 Db2 servers, the environment was working fine. The moment it crossed 150 or 160, we started having a lot of stability issues."
"Foglight for Databases can be improved as sometimes, when checking the current query in SQL PI, it does not show the complete large query as the text gets truncated."
"The data model needs improvement when it comes to creating custom reports."
"I know that we have many other solutions that do the same functionality as Terracotta. I don't recall the names of the products now, but I believe there are many products that may be better than Terracotta."
 

Pricing and Cost Advice

"It is cost-effective. With our EA, it is really based on the scale of our database environment. We found the Quest team to be reasonable and flexible when it comes to pricing and scaling of licenses."
"Compared to the other tools on the market, Foglight is okay in terms of pricing and licensing."
"The price is worth it, if you have the time to go through the information."
"This is like the "Cadillac" of performance monitoring software. It's not cheap... I am currently with a company that I was able to convince that the product is worth the cost."
"The price of Foglight could be a little more competitive in Chile, and it should be lowered for long-time customers— at least by 20 percent. Sometimes the price is a limitation. We have seven instances and nearly 5 million users. If Quest Foglight could reduce its prices for the clients that have been with it for a long time, we would be able to have more instances."
"Pricing is very reasonable. We were able to construct a pretty easy contract with Quest, who were very easy to work with and very amenable to what we are trying to do. It worked out well for us."
Information not available
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
920,769 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
14%
Manufacturing Company
10%
Outsourcing Company
10%
Government
8%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business6
Midsize Enterprise3
Large Enterprise26
No data available
 

Questions from the Community

What is your experience regarding pricing and costs for Quest Foglight for Databases?
In terms of pricing, the setup cost and licensing require planning from both perspectives. The initial configuration takes effort because I have to decide which database to monitor and configure ac...
What needs improvement with Quest Foglight for Databases?
I think Foglight for Databases could improve its user interface. It can be complex to navigate sometimes, especially when you are trying to troubleshoot a specific issue. It can be overwhelming for...
What is your primary use case for Quest Foglight for Databases?
My main use case for Foglight for Databases is to monitor database performance and identify issues before they affect our applications. I mainly use it to keep track of database health, check slow ...
What needs improvement with Terracotta?
My total experience with Terracotta is installing it in the architecture to do the clustering in WebMethods Integration Server. This provided to tackle the memory and the processes of those servers...
What is your primary use case for Terracotta?
Terracotta is actually a product used for clustering. It is not used standalone in architecture but is used in the Software AG architecture to cluster the request or state the request data between ...
What advice do you have for others considering Terracotta?
I may not be the best one to provide advice, but during my experience with Terracotta, I didn't face major issues with this product. I recommend this product to be used in any architecture. On a sc...
 

Overview

 

Sample Customers

CommitDBA
Kiabi, Wipro Technologies, CERN, Essent, Nielsen
Find out what your peers are saying about Quest Software, Oracle, SolarWinds and others in Database Development and Management. Updated: October 2026.
920,769 professionals have used our research since 2012.