• Alerting when Foglight Data Collection has a Problem

    I was asked recently if there are any alerts when Foglight has a problem collecting data.

    The answer is, there are several ways.

    For SQL Server, there is a rule named "DBSS-Collection Status" that can be managed via alarm templates and notification channels…

  • Announcing Quest®︎ Foglight®︎ v6.3 General Availability

    Background

    We are very excited to announce the general availability of Quest® Foglight® version 6.3.

    Foglight is the world’s broadest and deepest monitoring and optimization solution for the hybrid enterprise. Foglight brings unique top-to-bottom…

  • Adding Email Notification to Database Alarms

    Foglight ships with a rich set of pre-configured rules to alert you when issues arise with your databases.

    The default action is to put an alarm message on the dashboards within Foglight. Email notifications aren't enabled by default - but it's an easy…

  • Foglight for Oracle - Invalid Objects Filtering

    With Foglight for Oracle, invalid objects are monitored and alerted upon for each schema. While it's possible to exclude schema's from monitoring, this can be tedious if you only have a handful of schema's that need to be monitored.

    There…

  • We Put It On Our Tab – Complementary Oracle Monitoring with Foglight Pt 3 (of 3) – CRS and Exadata

    This blog series discusses each of the ‘tabs’ that can be found on the Database Home page in Foglight for Oracle. These monitoring options come included at no additional cost and illustrate how broad and complete Foglight is as an Oracle monitoring solution…

  • We Put It On Our Tab – Complementary Oracle Monitoring with Foglight Pt 2 – ASM

    This blog series discusses each of the ‘tabs’ that can be found on the Database Home page in Foglight for Oracle.

    Part 1 of the blog covers Foglight’s monitoring for Oracle’s Data Guard.

    https://www.quest.com/community/quest/performance…

  • We Put It On Our Tab – Complementary Oracle Monitoring with Foglight Pt 1 – Data Guard

    Hold on, grammar and spelling enthusiasts. Already, you might be thinking, did he mean ‘Complementary’ or ‘Complimentary’? The answer? YES. This blog series focuses on additional Oracle monitoring capabilities beyond monitoring the Oracle instance…’complementary…

  • Don’t Worry About Your (Con)figure, Have The PI !

    Congratulations! You have Foglight installed and it is collecting meaningful performance data. There’s no doubt it is providing a ‘smorgasbord’ of actionable information about your mission-critical environment. Help yourself to delicious servings of baseline…

  • 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. I didn’t, either. But, listen, sometimes…

  • How to Add the SQL PI Extension to an existing Foglight SQL Server agent

    SQL Performance Investigator (SQL-PI) is an extension to the standard Foglight for SQL Server Cartridge, and adds Real-time and historical data.

    If you have used Performance Analysis for SQL Server, then SQL Performance Investigator should look very familiar…

  • Measuring the impact of changes on DB performance

    As the old saying goes, “the one constant in life is change”, and this is especially true in database environments.  There are many reasons why database environments experience change whether it be through typical maintenance efforts such…

  • 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 should act to explain exactly how Foglight collects…

  • 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 colleague Trent Mera wrote a great blog on…

  • How to Avoid Extinction in the Database Evolution

    Friends. Change is here. All of us DBAs are dealing with it. Look at the number of new database platforms. It’s relentless. They just keep coming. And we’re expected to take on any or all of them that’ll save our companies money. But it’s hard, right…

  • 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 Foglight for this capability, you need to first download…

  • Diagnosing IO Latency with Foglight for Databases

    Understanding the processes and configurations causing your bottlenecks

    IO is the single most important metric to know for creating optimal performance of your database systems.  To understand it, you’ll need to know the processes, resources and configurations…

  • Foglight for DB 2017 Summary and Look to the Future

    What an exciting year it was for Foglight for Databases!

    Foglight for Databases had an amazing year, with several releases for the various Database Cartridges. Here are some of the highlights of what we’ve done in 2017:

    • Foglight for SQL Server…
  • 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 doubt to a DBA than those (well, maybe…

  • Meet Our Experts! The Voices behind @QuestExperts on Twitter: Nicola Flucke

    Former Member
    Former Member

    We are lucky enough to work with a number of extremely talented and passionate people. Some of our coworkers have been here for a number of years and have some great stories to tell. We wanted to use this interview as an introduction to one such individual…

  • 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 Investigator (PI) Advisories - Fully automated engine…
  • Performance Analysis to Performance Investigator - Part 3: Making the Move!

    So you've now taken a look at the architectural differences and enhancements between Performance Analysis and Performance Investigator (if you haven't, check them out here).  You've also hopefully been wow'ed by the new and enhanced features that…

  • Performance Analysis to Performance Investigator - Part 2: New and Enhanced Features

    In part one of Performance Analysis to Performance Investigator, I discussed the history of Performance Analysis and its transformation into Performance Investigator, as well as the architectural differences between the platforms.  In part two, we will…

  • Performance Analysis to Performance Investigator: Part 2 - New and Enhanced Features

    In part one of this blog series (here: https://www.quest.com/community/b/en/posts/performance-analysis-to-performance-investigator-part-1-introduction-and-architecture) I discussed the history of Performance Analysis and its transformation into Performance…

  • Performance Analysis to Performance Investigator: Part 2 - New and Enhanced Features

    In part one of this blog series, I discussed the history of Performance Analysis and its transformation into Performance Investigator, as well as the architectural differences between the platforms.  In part two, we will discuss the new and enhanced features…

  • Performance Analysis to Performance Investigator: Part 2 - New and Enhanced Features

    In part one of this blog series (here: https://www.quest.com/community/b/en/posts/performance-analysis-to-performance-investigator-part-1-introduction-and-architecture) I discussed the history of Performance Analysis and its transformation into Performance…