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 or custom…

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 Business:  Invoke Variables…

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 -> Agents -> Agent…

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, you find yourself…

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 available…

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 monitoring solution…

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 been the largest resource…

This blog series discusses each of the ‘tabs’ that can be found on the Database Home page in Foglight for Oracle.

Part 1 of the blog covers Foglight’s monitoring for Oracle’s Data Guard.

https://www.quest.com/community/quest/performance…

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 definition…

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 simplifies…

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  post, the building of…

Hold on, grammar and spelling enthusiasts. Already, you might be thinking, did he mean ‘Complementary’ or ‘Complimentary’? The answer? YES. This blog series focuses on additional Oracle monitoring capabilities beyond monitoring the Oracle instance…’complementary…

A UI Query can be used as an input to a report. This can simplify and offer a broader range of inputs when running or scheduling a report.

For a refresher on creating UI Queries, this post  covers the basics. 

WCF reports have inputs in order to properly…

In my Introduction to UI Queries  post, the building of a simple query to return all SQL Server Agent Jobs was shown.

Let's back up a step, and take a look at where UI Queries can be used in Foglight. This post will be updated with links as the topics…

Think of a UI Query as a shortcut to data that you can use in a report, dashboard, service definition, etc. This post will show how to get started building queries. 

The example today will be to get a list of all SQL Server Agent Jobs, regardless of the…

We have all done it. We think we know the lyrics to a song. We sing them passionately….and incorrectly. Here are a few classics.

• "Sweet dreams are made of cheese”. Correct lyric: “Sweet dreams are made of these” from The Eurythmics’…

Creating your own dashboard in Foglight is as easy as putting up the Festivus pole.

In this post, a service containing all MySQL instances was created. 

A great feature of Foglight is the ability to create your own custom dashboards and reports. Expand…

When you first monitor a database instance, you have the option of adding the host too. But sometimes, the checkbox is un-checked. Now what?

To add a host to monitor on it's own, switch the left-hand panel to Expert Mode, select the Infrastructure dashboard…

Many things can happen if the database runs out of disk space. None of them are good. DBAs understand that it is essential to monitor database disk space so that critical business processes are uninterrupted. Quest’s Foglight provides peace of mind by…

One of the primary tasks of any DBA is to find and optimize poorly performing queries. This is not a trivial job as often times there is too much data to sort through and pinpoint problems. Quest’s Foglight provides alerts for Postgres queries that have…

One of the most valuable capabilities of Postgres is its support for concurrent ACID transactions. ACID is an acronym for Atomicity, Consistency, Isolation, and Durability. These database transaction properties help verify data validity. It is important…

To compare is to measure, estimate, or make note of two or more “ things’ “ similarities and/or differences. It helps us better understand the items. A versus B. Sometimes it is done to learn which one is ‘better’. Other times, it is to determine those…

During installing of an database agent Foglight requests an admin account to grant the needed database privileges to the Foglight database user. In some environments it is not allowed to do a remote admin connection to the database. Or you might not have…

A customer recently asked if there was a way to find the top application servers that were placing load on their database instances.

With Foglight Performance Investigator, it is very easy.

Start with the usual tasks - setting the time range and specifying…