Performance Monitoring

I recently had a customer ask if they can audit SELECT operations for 1 table and 1 view in a specific database where the SELECT only contains certain keywords. This article covers advanced filtering in ApexSQL Audit. This post will provide a tutoria…

Hey look, an Amazon Cloud! To recap,  Part 1 covers 'As A Service' (...aaS) options - https://www.quest.com/community/blogs/b/performance-monitoring/posts/are-your-database-implementations-becoming-a-bit-cloudy-part-1-3-part-series...

The First 80 Hours as a Foglight Admin View the webcast here This webcast covered: Access to Support / Community Resources Version checks and upgrade requirements Deployment validation Security audit Alarm review Report Setup Access to dashboards fo…

These are difficult times we are in now but we will persevere. Hopefully, you and your loved ones are staying safe and healthy. Most of us are anxious to get back to some sort of normalcy. But, for now, for many of us, the situation has created the n…

Learn the top tips for SQL performance tuning for SQL expert, Janis Griffin, including monitoring wait time, SQL execution plans, and more.

Foglight can help identify SQL Tuning candidates? Yes! Foglight can tune the SQL? With seamless integration with Quest’s SQL Optimizer, yes! OK, let’s stick a fork in this.... (Click on images to enlarge) What is SQL Optimizer? Caution...

  In the spirit of keeping my blogs light and fun (?), the title was an attempt at that. In these interesting times (COVID-19 pandemic) and the need to stay home, I have been doing my share of yard work. It is the time of the year with lots of p...

We were recently asked if Foglight can be used to monitor Google Cloud SQL instances, specifically MySQL, PostgreSQL and SQL Server. To clarify, these are the PaaS (or DBaaS) offerings from Google. Within Google Cloud Platform, you can use Compute En…

Pinal Dave addresses the age-old question, “Who doesn't have a database performance issue?” He discusses SQL execution plans, SQL performance after an upgrade and SQL query execution.

On the Foglight for Databases main dashboard, you can create groupings of instances. These can be used to filter the dashboard, enable easier user-level access, and even allow fine tuning of alarms. These database groups can also be used in custom d…

Attend Quest Database Training Days for top SQL Server & Oracle expertise. Chat live with Pinal Dave, Janis Griffin and Brent Ozar.

Cumulus, Stratus, Cirrus….no…not that THAT kind of CLOUDY. The increasing number of cloud options can be confusing. With that in mind, I thought I’d ‘clear the air’ and review some of the more popular implementations....