Using UI Queries for Reporting in Foglight
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...
Where can UI Queries be Used in Foglight?
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....
Spotlight Enterprise 12.4 New Features
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 drilldow...
Introduction to UI Queries in Foglight
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...
Spotlight Federation Steps
We all get excited when our cell phone plan includes so called “Unlimited Data.” But, you know what happens if we push your luck. That’s right; we start to experience performance issues and get toss...
The Foglight Countdown
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 ma...
Foglight, Play Some Funky Music
We haven't added voice command to Foglight yet, but we can still get Foglight to play some tunes. I setup a small monitoring environment with a Foglight Management Server in a public cloud. I put a lo...
May All of Your Lights be Green this Holiday Season
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 c...
Adding Host Monitoring – Easy as 1-2-3 (4-5-6-7)
When you first monitor a database instance, you have the option of adding the host too. But sometimes, the checkbox is un-checked. Now what? To add a host to monitor on it's own, switch the left-hand...
Monitor Postgres Disk Space Usage with Foglight
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 uninte...
Optimize Postgres Query Performance with Foglight
One of the primary tasks of any DBA is to find and optimize poorly performing queries. This is not a trivial job as often times there is too much data to sort through and pinpoint problems. Quest’s Fo...
Monitoring and Managing Locks in Postgres with Foglight
One of the most valuable capabilities of Postgres is its support for concurrent ACID transactions. ACID is an acronym for Atomicity, Consistency, Isolation, and Durability. These database transaction ...
- Go to the previous page
- 1
- …
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- …
- 23
- Go to the next page