Exceptional Database Exceptions in Foglight
A common question is how to make an exception for 1 or 2 particular databases for certain rules in Foglight. A good example is the "days since last backup" rule for SQL Server. The global default appl...
Ch-Ch-Ch-Ch-Changes (-David Bowie)
“The Only Thing That Is Constant Is Change “- Heraclitus. Development, new applications, upgrades, patches, maintenance, schema updates…the list goes on and on around ways that changes are introduced ...
Diagnosing Historical Sessions in SQL Server TempDB
In the recent 5.7.5.50 release of Foglight for SQL Server, a change was made to the TempDB drilldown. Specifically, the Sessions tab would formerly show the current sessions, regardless of the time ra...
Exposing Foglight User-Defined Collection Data
This post will cover one way to make it easy easier to get the user-defined collection data onto a dashboard or report. For a quick refresher, please see User Defined Collections in Foglight for SQL S...
Tune Your Queries with SQL Optimizer (Pt 1)
One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are: Minimize Response Time – End users who are interacting wit...
Foglight for Databases Quick Tip – Using the Workload Column in the SQL PI Dashboard
Many of our Foglight users including myself have grown accustomed to using the "Databases" home as their starting point into their daily monitoring tasks. This dashboard provides a global view into a...
Foglight for DB 2017 Summary and Look to the Future
What an exciting year it was for Foglight for Databases! Foglight for Databases had an amazing year, with several releases for the various Database Cartridges. Here are some of the highlights of what ...
Measuring the Impact of Meltdown and Spectre Patching on your Databases
The new year kicked off with some big news on January 3rd, 2018 with the news of the Meltdown and Spectre chipset vulnerabilities. There are a lot of resources available to understand the details and ...
So you want to be a pro-active DBA?
During a recent installation of Foglight for SQL/Oracle the DBA announced how excited he was to get Foglight installed because he was desperate to become a pro-active DBA and stop being a re-active on...
Top 5 challenges of managing cross-platform databases
If you’re like many DBAs, your life is probably getting more complicated by the week. Are you under pressure to manage larger and larger numbers of database instances? Or to adopt new database technol...
Integrate Foglight by Sending SNMP Traps
Many customers ask how they might integrate Foglight Alarms into other 3rd party monitoring tools. One way to accomplish this is to send SNMP traps in response to a Foglight alarm. To configure Fog...
You’re Fired! Wait, What has Fired?
Foglight has many out of the box rules to evaluate performance and availability conditions for your databases, virtual and physical infrastructure, web pages, network devices, etc. Once it has been ru...