Integrate Foglight by Sending SNMP Traps
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 Fog...
Checking When DBCC CheckDB Last Checked Your DB
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 ...
The Juggling Act of Modern DBAs
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...
A General Guide to a Foglight for SQL Server Upgrade
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 diffe...
Documenting your SQL Server inventory with Foglight
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 ...
Why is my Database Server Slow?
We've all been there, the dreaded ticket that comes across our inbox. Always light on detail, just a single sentence: "The database server is slow." No five words bring as much fear, uncertainty and...
Discussing the Overhead of Foglight for SQL Server and Oracle
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 ...
Foglight for SQL Server Quick Tip – Database Exclusion
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 ...
Quest Customer Story: Foglight Performance Investigator Use Cases shared from the trenches
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 t...
Using SQL Server to Query the PI Repository
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 connect...
Foglight for Databases (SQL Server and Oracle): New Release – Version 5.7.5.35
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 In...
Foglight for SQL Server: Business Intelligence Monitoring – SQL Server Integration Services
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 Mi...