Performance Monitoring

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,...

What’s that you say? You think it may not be appropriate that a technology blog dive into politics? Agreed. Instead, this blog highlights the breadth of Administration capabilities available in Foglight for Postgres. Administration options are ...

This blog series discusses each of the ‘tabs’ that can be found on the Database Home page in Foglight for Oracle. These monitoring options come included at no additional cost and illustrate how broad and complete Foglight is as an Oracle ...

Hello all.   I am a sales engineer at Quest, so I assist customers with Foglight for DB2 installations and evaluations.  People who manage performance of DB2 databases need a view in Foglight listing those SQL statements that have...

Just like most people’s goal towards incorporating more raw food into their daily diet, accessing and manipulating raw data is very much a coveted functionality. The Spotlight Statistics Repository database is a repository for historical data c...