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…

A colleague of mine (Darren Mallette) wrote a great blog post explaining how to query the embedded Foglight Performance Investigator (PI) repository using tools which provide native PostgreSQL connectivity (i.e. Toad Data Point or pgAdmin).  While reading…

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…

Understand that this is a general, high-level guide outlining the steps you should expect to take during a Foglight for SQL Server upgrade. Since environments and upgrade circumstances are often different, it is important to review and familiarize yourself…

As the old saying goes, “the one constant in life is change”, and this is especially true in database environments.  There are many reasons why database environments experience change whether it be through typical maintenance efforts such…

We often get questions from customers wondering how much overhead will be put on a database server when monitoring that server with Foglight for SQL Server and/or Foglight for Oracle.  This blog post should act to explain exactly how Foglight collects…

As a DBA, you are responsible for many things, not to mention the ever changing landscape that is your database environment.  Documenting the server inventory is essential as it will come in good use when it comes to planning for a migration/upgrade,…

 I had a customer ask how they could use Foglight to find out when "dbcc checkdb" last ran against their SQL Server databases.

This is a great use case for User-Defined Collections!

As a refresher, my colleague Trent Mera wrote a great blog on…

Friends. Change is here. All of us DBAs are dealing with it. Look at the number of new database platforms. It’s relentless. They just keep coming. And we’re expected to take on any or all of them that’ll save our companies money. But it’s hard, right…

Many customers ask how they might integrate Foglight Alarms into other 3rd party monitoring tools.  One way to accomplish this is to send SNMP traps in response to a Foglight alarm.

To configure Foglight for this capability, you need to first download…

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…

What an exciting year it was for Foglight for Databases!

Foglight for Databases had an amazing year, with several releases for the various Database Cartridges. Here are some of the highlights of what we’ve done in 2017:

• Foglight for SQL Server…

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…