What is our primary use case?
On a day-to-day basis, my main use case for Foglight for Databases is a centralized database for performance monitoring and troubleshooting. I use it to monitor database health, review CPU and memory usage, identify slow-running queries, and performance bottlenecks. I also investigate issues when an application becomes slow. I use the dashboards, alerts, and historical performance data to identify unusual behavior early.
One example was when Foglight for Databases gave me an alert indicating unusually high CPU usage on one of our databases. I used the product performance information to investigate and found that a query was taking much longer than usual and consuming a lot of significant resources. We were able to identify the query and work with the DBA team to address it before it caused noticeable application slowdown. This helped us avoid waiting for users to report the problem and reduced troubleshooting time.
How has it helped my organization?
Foglight for Databases has a positive impact mainly by reducing the time my team spends on routine monitoring and troubleshooting. With the centralized dashboards, we have dashboards and alerts ready. In the morning, I can simply look at them, and if there is anything concerning, I can investigate it. This has reduced the amount of manual effort needed to gather performance information across different databases, allowing the team to spend more time addressing issues rather than collecting data.
We have seen a noticeable reduction in the time spent on monitoring and troubleshooting, estimating that twenty to forty percent of troubleshooting activities have been reduced. Although we have not formally measured this, we have been able to manage more databases without increasing our day-to-day monitoring workload. The main benefit is the faster identification of issues and less effort rather than a specific reduction in the number of incidents.
What is most valuable?
The features that are most valuable to me in Foglight for Databases are real-time monitoring, performance dashboards, and alerts. I particularly value the ability to identify slow queries and investigate what is contributing to a performance issue. The historical performance data is also useful because it helps me compare the current behavior with previous periods and understand when an issue has started. Having multiple databases visible from a central data dashboard makes day-to-day monitoring more efficient.
Foglight for Databases offers centralized monitoring and performance analysis with visibility across the database environment, which supports more consistent oversight and faster issue detection. I appreciate that the tool has AI capability, and I feel confident about the governance and security features. I trust Foglight for these aspects.
The performance and AI capability, accuracy, and reliability of output from Foglight for Databases is good, giving accurate results that I can rely on. Although I still validate the information myself, it gives me trustworthy data.
Foglight for Databases allows me to monitor multiple database platforms from a centralized view. In our environment, I use it across different database platforms, making it easier to monitor overall health and performance without having to manage each platform separately. I monitor Microsoft SQL Server, Oracle Server, PostgreSQL, MySQL, Azure SQL, MongoDB, IBM DB2, SAP HANA, and Snowflake.
I assess Foglight for Databases as very effective for quickly diagnosing emerging database issues. Its real-time monitoring and alerts help me identify unusual behavior early, particularly when a performance issue arises. Using Foglight for Databases, I can understand when the issue starts and look at the timeline for any recent changes, which helps me identify the root cause without impacting performance. It is a vital tool for developers who may not have the capability to run tests independently, as it enables them to assess what is happening after changes are made.
I use Foglight for Databases' monitoring and alerting capability to identify long-running or resource-intensive queries. This capability helps us catch potential performance problems before they have a broader impact on other applications. When a query starts taking significantly longer than usual and consumes excessive CPU, the alert prompts me to investigate the query and its resource usage, allowing the DBA team to address the issue proactively instead of waiting for users to report slow application performance.
I use the solution's user interface to access database performance information. I find the data fairly easy to locate once I am familiar with the interface, as the centralized dashboards provide access to database health, resource utilization, query performance, alerts, and historical trends. When investigating a slow database, I can start from the dashboard and drill into the relevant performance information rather than collecting data manually from multiple sources. The main challenge is that some troubleshooting views can take time to learn and navigate, so a more intuitive interface would improve the experience.
I find Foglight for Databases useful for getting a centralized view of my database environment, especially when database platforms and cloud resources are involved. The ability to bring monitoring information into one place makes it easier to compare performance and understand any unusual behavior. I can determine whether an issue is isolated to one database or is a broader problem with more than one database. When an application becomes slow, I can check database health and resource allocation, monitor query performance, and see alerts and historical trends, which gives me more context while troubleshooting. This reduces the need to check each platform separately, as I can directly analyze what is performing well and what is not.
What needs improvement?
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.
For how long have I used the solution?
I have been using Foglight for Databases for about one year.
What do I think about the stability of the solution?
Foglight for Databases is stable.
What do I think about the scalability of the solution?
Regarding scalability, as our databases grow, we can add additional databases to the monitoring setup without changing the overall architecture. Once a database is configured, mapping it to the centralized monitoring setup is fairly straightforward.
How are customer service and support?
The customer support for Foglight for Databases has been very good, supportive, and responsive. We do not encounter issues when they involve complicated requirements. However, more complicated issues can sometimes take longer to resolve when multiple teams are involved. Overall, I am satisfied with the support, but faster resolution times and more practical troubleshooting guidance would improve the experience.
I would rate the customer support six out of ten because the support team has been generally helpful with technical issues, although for complex cases, they took considerable time to resolve.
Which solution did I use previously and why did I switch?
Before using Foglight for Databases, I mainly relied on native monitoring tools provided with our databases, along with some manual reporting. Those tools were adequate for basic monitoring, but managing different database platforms separately became more difficult as our environment grew. I moved to Foglight for Databases because I wanted centralized monitoring, historical performance data, and reporting in one place. I still use native tools for certain tasks, but Foglight for Databases has made overall database monitoring more convenient.
What was our ROI?
I have seen a return on investment through time savings and better use of my team's resources rather than reducing headcount. I estimate that monitoring and troubleshooting activities take around twenty to forty percent less time. Although this has not been formally measured, we can manage more databases without increasing our day-to-day monitoring workload. Another benefit is that historical performance data makes monthly performance reviews and reporting much less manual.
What's my experience with pricing, setup cost, and licensing?
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 according to my requirements. The licensing cost can become significant as the number of monitored databases grows. However, once the initial setup is completed, ongoing management is straightforward. I would appreciate more flexible pricing options when expanding the monitored environment.
Which other solutions did I evaluate?
I evaluated SolarWinds Database Performance Analyzer and Redgate SQL Monitor before choosing Foglight for Databases. I was looking for a solution that could provide centralized monitoring across my database environment, along with historical performance analysis and reporting. I considered each product's capability, licensing, cost, and setup requirements before selecting Foglight for Databases.
What other advice do I have?
Foglight for Databases provides strong centralized monitoring across all my needs, and I would rate the tool nine out of ten.
When someone is looking for a tool like Foglight for Databases, I would recommend first identifying the database and performance metrics that are most important to your environment rather than trying to monitor everything at once. Start with critical databases, configure them, then create dashboards and alerts around your requirements, and gradually expand. It is worth spending time learning the reporting and historical analysis features.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure