Background

We are very excited to announce the general availability of Quest® Foglight® version 6.3.

Foglight is the world’s broadest and deepest monitoring and optimization solution for the hybrid enterprise. Foglight brings unique top-to-bottom…

Query Insights: Coming soon in Foglight v6.3!

As organizations rely more on data to make critical business decisions, ensuring that their databases are running efficiently becomes increasingly important. A database slowdown or crash can result in a significant…

Way back in 2020, these posts formed the building blocks of using the command line to automate alarm blackouts in Foglight:

Part 1

Part 2

Part 3 

In Part 3, we looked at adding objects (instances, hosts, etc.) to a service definition, and then having the…

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…

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…

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…

Foglight for SQL Server Business Intelligence (BI) provides analysis monitoring for SQL Server BI services: Integration services, Reporting services, and Analysis services.

In this (Part 3) blog, the focus is SQL Server Analysis Services or ‘SSAS’.…

Foglight for SQL Server Business Intelligence (BI) provides analysis monitoring for SQL Server BI services: Integration services, Reporting services, and Analysis services.

In this (Part 2) blog, the focus is SQL Server Reporting Services or ‘SSRS’.…

Foglight for SQL Server Business Intelligence (BI) provides analysis monitoring for SQL Server BI services: Integration services, Reporting services, and Analysis services.

In this (Part 1) blog, the focus is SQL Server Integration Services or ‘SSIS’…

So you've now taken a look at the architectural differences and enhancements between Performance Analysis and Performance Investigator (if you haven't, check them out here).  You've also hopefully been wow'ed by the new and enhanced features that…

We are lucky enough to work with a number of extremely talented and passionate people. Some of our coworkers have been here for a number of years and have some great stories to tell. We wanted to use this interview as an introduction to one such individual…

We are pleased to announce the general availability of Foglight for SQL Server and Foglight for Oracle versions 5.7.5.35.  This release provides the following significant enhancements:

• Performance Investigator (PI) Advisories - Fully automated engine…

Database performance monitoring can be a real circus! And with an ever-growing amount of technology platforms to manage, we’ve become the ultimate jugglers.  

Didn’t sign up to be a clown?

Hey, I know. I didn’t, either. But, listen, sometimes…

Understanding the processes and configurations causing your bottlenecks

IO is the single most important metric to know for creating optimal performance of your database systems.  To understand it, you’ll need to know the processes, resources and configurations…

I've done a number of posts recently that touch on Foglight administration, customization, or some of the more advanced capabilities of the product.  I felt it was a good time to circle back on some of the more basic use cases that Foglight can help…

If you are someone who is responsible for administering Foglight when used for monitoring SQL Server Instances, you will likely run into the situation where you want certain databases to be neglected from the overall monitoring.  There are going to be those…

As a Sales Engineer for the Database Performance Monitoring team, one of the more rewarding aspects of my role is to learn about specific ways that our customers are leveraging Quest solutions. With that in mind, I am a firm believer that if something…

Microsoft has evolved their marketing over the past several years to focus on the fact that SQL Server is more than just a Relational Database Management System (RDBMS).  You may have noticed, that Microsoft commonly now refers to SQL Server as the SQL…