In this post, some tips for working with User-Defined Queries (UDC's) were introduced. We left off with the idea of creating a custom dashboard showing UDC results from multiple instances. The Fogligh...
The ability to enter your own queries into Foglight for SQL Server, Oracle and DB2 opens up a world of additional data that you can use with Foglight. These are called User-Defined Collections, or UDC...
While Foglight for SQL Server offers capabilities that go above and beyond most SQL Server monitoring products in the industry, Query Performance Monitoring is certainly a strength of the product that...
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 ...
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)...
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 da...
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...
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 ...
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 ...
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...
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...
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 o...
