Performance Monitoring

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…

Cloud Migration – How Foglight can eliminate guesswork on workloads and cloud costs View webcast here This webcast covered: How to optimize your virtual machines to get prepared for the cloud Learn how to find the correct subscription for my v…

Quick Start Guide to Foglight (5) You’ve just been handed access to Foglight. Now what? These basic sessions will help any NEW Foglight administrator or user get familiar with the tool. We suggest you start here in order to understand the funda...