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

April 15, 2019.....Let’s give a shout out to all those men and women running the Boston Marathon today. Man, running for that long must be taxing. Taxing…..wait…what day is it again? So, as my way of giving a nod to long runners,...

A UI Query can be used to add either static or dynamic components to a service definition via the Service Builder dashboard. This in turn offers a great range of additional things Foglight can do. This post will introduce creating a service definitio…

In the first part of this series, we will learn how to export SQL statements from Foglight SQL Performance Investigator, and import them into SQL Optimizer. Start by opening SQL PI, and selecting a database from the Databases dimension. This simplifi…

A UI Query can be used as a shortcut to building a custom dashboard or report. This can save time and frustration by publishing either frequently accessed or hard to find data in an easy to use spot. In my Introduction to UI Queries  p...