Performance Monitoring

Foglight has a retention policy for the data that is collected from the monitored environment. For SQL Server, the default is "medium" or 90 days. If an object (eg. a database) is removed from the monitored instance, Foglight will still keep a record…

Article Contributed by Lior Asta With more on your plate than ever, cross-platform database monitoring is critical. You can’t afford any database downtime or performance degradation. Foglight helps you to avoid risk and stress, spe...

Look what's new: Foglight for AWS Hosts 6.1.1: Full Coverage - Monitors all operating systems and database engines for EC2 and RDS Critical Availability and Performance Metrics - In-depth details on system health and performance Process Monitoring…

First, a big "Thank You!" to Gita Sharifi (Spotlight Product Owner) for organizing and providing the information contained in this blog. SQLServer DBAs may often find themselves accessing and viewing the SQLServer Error Logs via SQLS...

Here are some quick instructions on how to install and set up Spotlight so you can quickly find and diagnose issues in your SQL Server instance. You can start by downloading a free, 30-day trial of Spotlight here: https://www.quest.com/register/...

In Part 1 – I have covered OpsGenie Email Integration - https://www.quest.com/community/blogs/b/performance-monitoring/posts/foglight-for-it-ops-a-genie-approach---foglight-email-integration-part-1 . In Part 2 – let’s see how F...

The Foglight cartridge for Azure SQL DB (v. 6.1.5)  is now generally available (11/28/22). In this release, specific monitoring support for Azure SQL DB Elastic Pools (FOG-4248) was added. What is Azure SQL DB Elastic Pools? When resource cons...

...Violets are bluis Enable that Foglight SQLServer cartridge... ...and maybe the Redis one toois! Ok, then... The Foglight for Redis (v. 6.1.1) cartridge is now generally available (11/28/22). In the coming weeks, I suspect the SE team will deliv…

The PostgreSQL Global Development Group announced the release of Postgres version 15! Some of the notable feature enhancement additions include: 1. Addition of the MERGE command - SQLServer and Oracle have had this command for some time now a...

Once Foglight for Databases or Foglight for SQL Server has been installed, you’ll need to tell it what to monitor. Since Foglight doesn’t use any agents installed on the monitored systems, all you have to do is provide...

If you are reading this, chances are you’re considering a 30 day trial of ‘Foglight for Cross Platform Databases’. Before you do, here are a few tips that will help you get a fully functional Foglight installation up and running qui…

So, is parameter sniffing a think of the past with SQL Server 2022? Well, it looks promising, but I wanted to understand how Foglight SQL PI would show me what’s going on. I took some sample code from https://www.brentozar.com/sql/parameter-sn…