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…

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…

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…

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…

In 12c, Oracle introduced support for a new architecture - multi-tenant. As such, the Container database (or CDB) was introduced. Think of the CDB as the 'super database'. This multi-tenant container database allows for many 'sub-databases'. These are…

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…

Foglight has a robust rules engine for alerting and notification. It's often the case that you can get to the same end zone in Foglight by many different plays.

Using the Service Builder is an easy way to group "things" together. "Things" can be higher…

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…

I had a customer who was curious if Foglight could be used to monitor MariaDB running in Amazon RDS.  This customer was already monitoring SQL Server and MongoDB with Foglight, and was eager to see if it could extend to this new MariaDB based application…

Do you also feel lost sometimes when searching for a specific instance on the database overview dashboard? If you monitor hundreds of databases it is easy to lose the overview but there are some options to quickly find the database you need.

1. Table filter…

“The Only Thing That Is Constant Is Change “- Heraclitus.

Development, new applications, upgrades, patches, maintenance, schema updates…the list goes on and on around ways that changes are introduced into your environment. Sometimes these…

This post will cover one way to make it easy easier to get the user-defined collection data onto a dashboard or report.

For a quick refresher, please see User Defined Collections in Foglight for SQL Server: A Quick Walk-Through

With a "simple" UDC that…

One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are:

1. Minimize Response Time – End users who are interacting with data want that data as quickly as possible. It may…

The new year kicked off with some big news on January 3rd, 2018 with the news of the Meltdown and Spectre chipset vulnerabilities. There are a lot of resources available to understand the details and potential impact. This one from cnet.com is pretty…

If you’re like many DBAs, your life is probably getting more complicated by the week. Are you under pressure to manage larger and larger numbers of database instances? Or to adopt new database technologies like open source or NoSQL? With those changes…

Foglight has many out of the box rules to evaluate performance and availability conditions for your databases, virtual and physical infrastructure, web pages, network devices, etc. Once it has been running for some time, it's a good idea to evaluate which…