What is our primary use case?
Foglight for Databases serves as a proactive database monitoring and performance troubleshooting tool for identifying bottlenecks such as blocked sessions, deadlocks, and resource contentions in database issues, particularly for SQL Server, Oracle, and PostgreSQL.
In my daily work, I regularly use similar monitoring tools to investigate SQL Server performance issues. For example, I recently investigated high CPU utilization and blocked sessions by analyzing active queries, wait statistics, and execution plans, which helped identify the root cause and improve database performance. I have used Foglight monitoring dashboards and historical performance analysis to follow the same troubleshooting approach.
Although my direct experience with Foglight is not advanced, I have extensive experience with similar database monitoring solutions. I see Foglight as a valuable tool to support monitoring, capacity planning, performance optimization, and incident prevention. It can also help DBAs like myself and infrastructure teams collaborate more effectively by providing centralized visibility, historical performance data, and alerts to improve availability and reduce downtime.
Our database infrastructure embraces a hybrid environment, combining on-premises systems with AWS and Azure for cloud services. We primarily use AWS and Microsoft Azure, with AWS being my primary cloud.
How has it helped my organization?
Foglight for Databases has positively impacted my work and organization by improving my team's efficiency through similar monitoring tools, which have reduced manual checks and helped prevent production incidents. The proactive monitoring has allowed us to quickly identify CPU spikes, blocked sessions, and resource bottlenecks.
What is most valuable?
The best features for me are the real-time performance monitoring, historical performance analysis, and the intelligent alerting in a centralized dashboard across multiple database platforms offered by Foglight for Databases. I find its ability to easily identify SQL bottlenecks, blocked sessions, and deadlocked resource contention very useful.
A centralized view helps my work by making it easier to monitor multiple database environments from a single dashboard, allowing us to quickly identify performance issues and prioritize the critical ones. In my experience with similar monitoring tools, this is particularly relevant when managing dozens of SQL Server, Oracle, and PostgreSQL instances. For example, during a high CPU or blocking incident, having consolidated metrics helps the team quickly find the affected database and reduce troubleshooting time.
Foglight for Databases provides near-real-time database activity monitoring. In a recent SQL Server production incident, I used the real-time monitoring to investigate high CPU utilization and a blocked session. I analyzed active queries, wait statistics, and execution plans, and identified resource contention in queries, helping the team address the performance bottleneck. Although I use monitoring tools other than Foglight for Databases, its real-time activity monitoring could support the same troubleshooting process, helping reduce investigation time and minimize application impact.
I have not directly used Foglight for Databases' Angular UI for proactive alerts, but I use a similar monitoring tool that alerts for long-running queries, blocked sessions, and performance bottlenecks. For example, configuring alerts based on query execution time, CPU consumption, and block duration helps our DBA team proactively identify issues, investigate the potential execution plan, and take corrective action before database performance is significantly affected.
I have not used Foglight for Databases for displaying intensive database queries, but I use a similar monitoring tool to identify resource-intensive queries based on CPU and I/O usage. Foglight for Databases' performance analysis capabilities can support the same proactive troubleshooting approach.
Foglight for Databases offers drill-down capabilities to investigate performance issues including SQL execution, wait events, blocked sessions, and resource utilization. Although my direct experience with Foglight for Databases is not advanced, I use similar functionality in other monitoring tools. For example, when investigating high CPU, I drill down into active sessions and specific queries and execution plans to find the root cause. This process reduces troubleshooting time and helps my team perform optimally.
Foglight for Databases supports monitoring multiple databases, including SQL Server, PostgreSQL, MySQL, and Oracle. My database environment includes these technologies across AWS, Azure, and on-premises infrastructure. I have not personally managed how these platforms integrate with Foglight for Databases, but a centralized solution that can provide performance and availability, CPU utilization, and blocked sessions for the application is crucial.
I see Foglight for Databases' cross-platform monitoring capability as a major advantage, especially for hybrid environments that combine AWS, Azure, and on-premises infrastructure. Correlating database performance with OS metrics, CPU, memory, storage, and infrastructure health provides a more complete view of system behavior and helps identify root causes faster. In my experience with similar monitors, this visibility is especially valuable for distinguishing database-level bottlenecks from infrastructure issues, improving troubleshooting efficiency, capacity planning, and overall system availability.
I consider Foglight for Databases' diagnostic capability a strong advantage. This feature is extremely important to me because I manage business-critical databases where rapid incident detection and root cause identification are essential. In my experience with similar tools, quickly identifying blocked sessions, inefficient database queries, and resource contention significantly improves troubleshooting efficiency, reduces MTTR, and minimizes production impact.
What needs improvement?
Foglight for Databases could improve by offering a more intuitive, responsive user interface, easier initial configuration, and more customizable dashboards. I would also like to see stronger AI-driven anomaly detection with more predictive and fewer active alerts to reduce false positives and integration with cloud platforms such as AWS and Azure.
A valuable improvement would be more automated root cause analysis, better integration with DevOps and incident management tools, and simplified monitoring configuration for large environments with hundreds of instances.
From a database and security perspective, Foglight for Databases should provide very strong governance with role-based access control, encryption, and data loss prevention of sensitive database information.
We could use infrastructure as code tools such as Terraform or Ansible to enable automated monitoring deployment configuration.
For how long have I used the solution?
I have been using Foglight for Databases for more than 10 years.
What do I think about the stability of the solution?
Foglight for Databases is very stable.
What do I think about the scalability of the solution?
Foglight for Databases offers strong scalability potential for growing environments, supporting centralization across multiple database platforms and instances and accommodating growing infrastructure. Proper sizing, configuration, and resource management are essential.
How are customer service and support?
However, I believe the biggest value would be fast access to experienced support engineers during critical production incidents. When managing business-critical databases, having good support and expanded guidance for quick issue resolution can significantly reduce downtime and operational risks.
In my experience, Premier Support is not a direct influence on additional license purchase decisions, as I have not been involved in those decisions. However, I believe that having a good support experience to assure resolution of vendor expertise would be very important for future decisions to expand the existing license.
I would rate the customer support a potential eight.
Which solution did I use previously and why did I switch?
I have experience with monitoring solutions such as Datadog and Zabbix.
What was our ROI?
A good database monitoring tool can significantly reduce operational costs by accelerating root cause analysis. While I do not have specific time and cost savings for Foglight for Databases, I know that faster troubleshooting reduces manual investigation and also lowers the business impact of performance issues.
While I cannot quantify an ROI for Foglight for Databases, I have seen clear benefits from similar monitoring solutions. For example, when managing approximately 40 database instances, centralized monitoring reduces the need to manually connect to each instance to check CPU, block, and storage utilization.
What other advice do I have?
I would rate Foglight for Databases an eight. I choose eight out of ten because Foglight for Databases offers strong database monitoring performance, but I see room for improvement for a better user experience, simplicity, AI-driven root cause analysis, and cloud integration. Since my direct experience is limited, this rating is primarily based on its capabilities and how they compare with similar monitoring solutions that I have used extensively.
Based on my experience with similar monitoring tools, AI-driven insights can be valuable for identifying anomalies, performance bottlenecks, and potential issues. I would always validate recommendations against actual data and historic trends, especially in critical production environments.
I recommend starting with a proof of concept focused on the most critical database to evaluate its accuracy, performance, scalability, and integration with existing tools.
Which deployment model are you using for this solution?
Hybrid Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)