Many Foglight users wish to produce reports or custom views that visualize important key performance indicators about some of the monitored things in their environment.  Reports can be produced and shared, whether template out-of-the-box reports...

Put to use some of the built-in facilities of Foglight to make your monitoring even more effective and valuable:  registry variables, schedules, services, and the security model.     Find More Time for Innovation and Helping Your Bus...

Foglight fires alarms when something being monitored is experiencing a lower- or higher-than-desired level, or “abnormal” behavior.  You can help Foglight understand what “reasonable” levels of performance are, and which ...

SQLServer Differential Backups make a lot of sense...they backup only what has changed. However, it seems that many Database Administrators choose not to leverage them. When digging into reasons for this, it is often because DBAs prefer to avoid some…

In this post, I alluded to 2 ways to capture VMware metrics with Foglight for SQL Server. The steps below apply to SQL Server running on Windows only. Since VMware Tools pulls metrics into the VM, we can access those by querying the WMI Performance C…

There are a couple easy, free ways to get VMware metrics collected by Foglight for SQL Server. This first part shows the easier way. When setting up the monitor for SQL Server, you can select (or not) to provide VMware credentials. Foglight will con…

Find out how to tackle the growing horrors of modern database performance management in three simple steps.

More and more companies are moving in part or even attempting a complete move to Software-as-a-Service (SaaS) as they are realizing the benefits. I'm even seeing a trend of company management mandates.. "If it is available as-a-service, go t...

With Foglight for Oracle, invalid objects are monitored and alerted upon for each schema. While it's possible to exclude schema's from monitoring, this can be tedious if you only have a handful of schema's that need to be monitored. There are 2 way…

Spotlight 13.0 introduces a brand new feature of managing access to monitored connections at the user level. It provides the ability to assign or deny a user access to a set of connections that have been configured to be monitored in Spotlight. The n…

Depending on how many databases, hosts, etc. that you wish to monitor, the JVM memory settings for the Foglight Agent Manager (Fglam) may need to be adjusted.   There is a way to do this from the Foglight UI. Navigate to Administration -> Age...

Before application users are affected!  That’s when everyone would like to see database performance problems addressed.  However, if you’re like many of the DB2 LUW customers I work with, and how I functioned during my DBA days,...