Getting the “All Clear” from Foglight
A customer asked how to implement and email that indicates an alarm has been cleared. In Foglight, there are typically several ways to do that. In this post, we'll look at creating a new rule that fi...
Five common risks to successfully managing multiple database platforms
Digital transformation is everywhere Organizations are changing fast to keep up with business demands. Digital transformation is being driven by the business, but IT (central and business-run) is maki...
“Foglight Skills 101” Tuning Expensive Queries
The Need for Speed in your Sql Server database View webcast here This webcast covered: Learn how to effectively use wait types to quickly identify bottlenecks and get clues on the best tuning approac...
Announcing Foglight Evolve 9.3
We are very excited to announce the general availability of Foglight Evolve 9.3. This release brings major product enhancements that have been requested by many of our customers, including (but not li...
Tuning SQL Statements: Manual and Automated Tips for Improved Tuning
Let’s face it, tuning SQL statements is time-consuming, often frustrating and just plain hard. For many years, I’ve been giving performance tuning presentations, and through those years I’ve managed t...
Take the Guesswork out of Cloud Migrations with Foglight
Cloud migration is speeding up Not surprisingly, cloud migration – the movement of data and applications to the cloud from on-premises hardware – has been a significant trend for several years. Approx...
Lil’ Help?
Many of us don’t like to ask for directions…. https://www.youtube.com/watch?v=mqVzRD_nWLQ&t=16s That said, getting advice, directions, help, or suggestions will provide a faster path to success. My ...
Series Finale – Automating Foglight Blackouts
Way back in 2020, these posts formed the building blocks of using the command line to automate alarm blackouts in Foglight: Part 1 Part 2 Part 3 In Part 3, we looked at adding objects (instances, hos...
The Widening Database Skills Gap in Hybrid IT – Bridge it with Foglight
Is there a database skills gap for complex hybrid IT environments? In research published by Unisphere Research in 2020, the database professionals they surveyed responded that 84% had two or more data...
Announcing Performance Investigator for Azure SQL DB
We are very excited to announce the general availability of Foglight for Databases v5.9.7.20, featuring the new Performance Investigator (PI) for Azure SQL DB. Background PI is one of Foglight’s most ...
Automating Alarm Blackouts – Part 3
Time to wrap up automation of alarm blackouts in Foglight. In this post, we looked at using the command line to implement alarm blackouts. We used topology queries to match a host name or pattern for...
Announcing Deeper Execution Plan Diagnostics with Spotlight v13.3
Quest is very excited to announce the General Availability of Spotlight on SQL Server Enterprise v13.3. Spotlight on SQL Server Enterprise v13.3 is focused on a major aspect of SQL Server tuning - an...