Quest Foglight for Databases Overview
Quest Foglight for Databases is the #8 ranked solution in our list of top Database Development and Management tools. It is most often compared to Quest Spotlight: Quest Foglight for Databases vs Quest Spotlight
What is Quest Foglight for Databases?
Foglight identifies and resolves performance issues across your applications, databases and virtual environments. The Foglight family of products easily integrates with your existing tools, so you can monitor and analyze data from almost any source across your infrastructure and view it through a single interface with our customizable, unified monitoring platform
Quest Foglight for Databases Buyer's Guide
Download the Quest Foglight for Databases Buyer's Guide including reviews and more. Updated: January 2021
Quest Foglight for Databases Customers
CommitDBA
Quest Foglight for Databases Video
Pricing Advice
What users are saying about Quest Foglight for Databases pricing:
- "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."
Quest Foglight for Databases Reviews
Filter by:
Loading...
Filter Unavailable
Loading...
Filter Unavailable
Loading...
Filter Unavailable
Loading...
Filter Unavailable
Loading...
Filter Unavailable
Order by:
Loading...
Search:
Vinothsingh Elumalai
Lead Software Engineer at Lowe's Companies
Really helpful for assessing database performance, but we have had issues with the stability
What is our primary use case?
We are using version 5.9.5 as well as 5.9.7. Ours is a huge database infra so we are using two different environments to monitor our corporate and store servers. We have thousands of DB servers that have to be monitored across our environment, which includes Lowe's stores across the U.S. We support the infra and the monitoring for all the stores and the store-related applications, as well as the servers which support those applications. With the DB servers being an integral part of all those applications, we thought we should have a separate monitoring tool just to monitor them. Foglight… more »Pros and Cons
- "We can visualize all the different types of DB servers that we are monitoring in a single pane of glass. It uses a 360-degree overview of the database, for each of those databases that we are monitoring. That includes what kind of resource utilization is happening and what kind of DB parameters are getting monitored, as well as the different types of DB parameters that are being offered for each database type."
- "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."
What other advice do I have?
We have had a lot of stability issues since we brought in Foglight to Lowe's. From the stability standpoint, Foglight really has to work and improve. I know that Foglight is capable of monitoring OS parameters as well as cloud DB instances, but we're not really using those features. We're just using Foglight to monitor the DB infra, purely from the database metric standpoint. The time it saves us when it comes to a root cause analysis differs from case to case. There are instances where the metrics that we are monitoring on the DB servers have really helped us to narrow down the root cause…
Anthony Nicoletti
Database Administrator, Information Technology at a healthcare company with 1,001-5,000 employees
Tells me, from the ground up, what's going on and when, and enables me to do much more than I could otherwise
What is our primary use case?
We use it to monitor about 500 instances, 500 servers, and it keeps up with everything. I monitor Foglight. I wake up in the morning and it's the first thing I look at, because I can depend on it. We have it on VMs in-house and it performs very well.Pros and Cons
- "Foglight's Change Tracking capabilities are another huge feature. It is wonderful to be able to do that. People don't realize the amount of information that Foglight gathers from a given server or instance. It gets down to the version of SQL, the disk array, everything that's there. Any change that's made, any upgrade to SQL, shows up on the dashboard almost immediately. You don't know how much time you save just having a tool in your back pocket that does that for you."
- "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."
What other advice do I have?
The biggest thing I've learned from using it is the reduction in effort that is required to do my job. Don't tell my boss that. My advice is "buy it." You won't know until you use it. I've been a DBA for 22 years and it really is an awesome tool. We use Foglight to display the most intensive database queries, but it's on a per-server, per-instance basis. We haven't created a dashboard for that, although we probably should. I can drill down into a server and I can tell you, from top to bottom, which queries are the most expensive. It could help us to improve query efficiency but we don't use it…
Find out what your peers are saying about Quest Software, IDERA, SolarWinds and others in Database Development and Management. Updated: January 2021.
456,495 professionals have used our research since 2012.
Kenneth Slate
Sr. Database Administrator at a sports company with 1,001-5,000 employees
Performance Investigator module enables us to dig into issues and resolve them much faster
What is our primary use case?
We monitor quite a few database servers. The actual number jumps up and down on a regular basis, but on average we're doing 120 servers at a time. It gives us one pane of glass to be able to see which ones are having actual issues and which ones are just going along.Pros and Cons
- "The PI module allows [my colleague] to identify which new indexes or modified indexes are going to make the biggest impact."
- "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."
What other advice do I have?
If you've got the time for it, the time to focus on databases in general, then Foglight is definitely worth the expense because of the information that it can provide for you. The biggest lesson I have learned from using this solution is that it's worth it. It enables you to pin down troubleshooting within 30 minutes to an hour, whereas before, you'd be pouring over reports or data from queries for days. That's huge. The CIO has told me that since we've started using Foglight, we've actually gotten ahead of some of these issues and we're actually being proactive instead of reactive. We're in…Product Categories
Database Development and ManagementPopular Comparisons
Quest Spotlight
SolarWinds Database Performance Analyzer
IDERA SQL Diagnostic Manager for SQL Server
Oracle Enterprise Manager
Toad Data Modeler
Redgate SQL Toolbelt
IDERA DB Optimizer
Protegrity Data Security
Buyer's Guide
Download our free Database Development and Management Report and find out what your peers are saying about Quest Software, IDERA, SolarWinds, and more!
Quick Links