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
32
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

"The PI module allows [my colleague] to identify which new indexes or modified indexes are going to make the biggest impact."
"The best features offered by Foglight for Databases allow me to see in real time the resources and the amount of resources being used at that moment, and that helps me identify if during that period of time there were issues or which issues or which statements generated the greatest impact within the database."
"I do not find anything I dislike about Foglight for Databases."
"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."
"Foglight for Databases positively impacts our organization by enabling us to identify slow-running queries and check the historical performance of any SQL Server instance, which is why we have relied on this tool for nine years without facing significant issues."
"If you used to work without it, once you've used it, I'm not sure you'd want to do your job without it anymore."
"Foglight for Databases has helped us reduce the time we spend monitoring and troubleshooting database issues."
"Its reporting capabilities are immense."
"The impact of Terracotta's high availability and failover capabilities on the organization's data consistency and reliability is significant."
 

Cons

"Foglight for Databases is very useful; however, the negative side we face is that customer care support is not frequent."
"The data model needs improvement when it comes to creating custom reports."
"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."
"I get a lot of alerts that, while important, are not critical. Then I have to dig in and figure out how to turn alerts off, but not the logging. I want to be able to go back, once we get the other big issues out of the way, and start fine-tuning some of those other areas, but I don't necessarily want to receive an email for all of them."
"I would like the rule development code to be made available so we don't always have to be referred to professional services for custom solutions. For example, if we want to exclude certain databases from a particular rule, we shouldn't have to go to support and to professional services for that solution. If the code and syntax were available, we have resources that could quickly turn something like that around."
"Foglight for Databases could improve by offering a more intuitive, responsive user interface, easier initial configuration, and more customizable dashboards."
"Foglight for Databases does provide real-time activity data, which I find very useful in my database operations, although sometimes it triggers false alarms."
"When we decided to go with Foglight, a lot of people stopped using the diagnostics part because it was very intimidating... They still won't use it because they feel it's too intimidating. They will open something up and not know what to do. It's not very user-friendly. You have to click on a lot of stuff to find the information."
"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

"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."
"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."
"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."
"Compared to the other tools on the market, Foglight is okay in terms of pricing and licensing."
"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."
"The price is worth it, if you have the time to go through the information."
Information not available
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
919,919 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 Enterprise25
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.
919,919 professionals have used our research since 2012.