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 ...
Analysis Time. Foglight & Rogue OS Processes
Investigating a rogue OS process is a pain; digging through the multitude of metrics, different times of days have different outcomes, alarms that come and go and customer complaints to accompany it a...
Tune Your Queries with SQL Optimizer (Pt 2)
In Part 1 of this blog post, I review how you can get an evaluation copy and explain the various integration points from Quest’s monitoring solutions – Foglight and Spotlight Enterprise. You can find ...
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...
Reporting on Changes to Foglight Registry Variables
Registry variables in Foglight are mostly used as placeholders in rules in order to avoid hard-coding in values. For example, a rule to check cpu utilization over a certain percentage could be coded ...
7. Foglight Anwendertreffen
Am 10.4. 2018 findet das siebte Foglight Anwendertreffen in Köln statt. Das Treffen bietet Ihnen die Möglichkeit, sich über Neuheiten und Entwicklungen im Bereich Foglight zu informieren und Erfahrung...
Foglight Agent Manager in Docker Containers
Docker is an open platform for developing, shipping, and running applications. It provides the ability to package and run an application in a loosely isolated environment called a container. A contain...
The International Day of Awesomeness is upon us and you should celebrate
DBAs are all kinds of awesome. We’re smart. Stylish. Capable of administering databases! Who else can say that? Yeah. Just DBAs. Our technical wizardry is second to none. Because we’re awesome. And g...
Do you have sensitive database rules?
You say “No” - well - I say “Yes”. All database rules are sensitive and have a sensitivity level. What does that mean? What is a sensitivity level? Where can I find it and can it be modified? Ok - a l...
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...