Understand how Foglight’s architecture can affect the availability and the performance of your monitoring.

Best Practices for Architecture Configuration & Scalability

View webcast here

 This webcast covered:

• Embedded vs. External Foglight…

Learn how to interpret and react to various types of alarms and to problematic resource usage by workloads.  Equip yourself to track down causes of degrading performance.

Dashboards for various IT stakeholders

View webcast here

This webcast covered:

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…

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 problems result in…

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

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

“Read me a story about cloud migration,” said the teddy bear to the little girl.

“I left that one at home," said the girl. "But I can read this one to you.”

The little girl opened her favorite book.

“Once upon a time…

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

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…

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

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…

Spotlight Enterprise 12.4 comes with some neat features you do not want to miss!

Query Execution Plans available when needed the most:

The Workload Analysis and the Query Execution Statistics drilldowns expose the most resource intensive transactions…

The average DBA, managing a cross-platform database environment. Does this even SEEM like a good idea? Hmmm?

On a scale of one to “Bird Box,” how stressful is cross-platform database management? Uh, yeah. It’s full-blown soccer-mom-in-a-pink-sweatsuit…