• Tracking Oracle database instance CPU and memory on Windows with Foglight

    I was recently talking to a customer who wanted some help tracking Oracle process memory usage on Windows. They had a problem with a bug causing a memory leak and had a support case open for that. They were happy with the SQL PI feature in Foglight that…

  • 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…

  • Quest Foglight Trial – 3 Tips BEFORE you download!

    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 quickly…

  • Evaluating Foglight vs Oracle Enterprise Manager

    As part of most any database monitoring software evaluation, it includes comparing that software to similar solutions. Logically, it often means doing head-to-head comparisons to database tools that come bundled with that particular DBMS. Regularly, I…

  • Saving Money with Foglight: Part 2 - Enterprise Resource Management

    This is the second in a multi-part series on how to leverage Foglight to save money within your IT budgets.  To review the first part, managing monitoring vendor sprawl, check out the post linked here.

    This post is going to cover another way to save money…

  • It’s a Learning Bonanza – Database Training Days

    In our new reality of social distancing and remote work, it’s nice to hear a friendly voice that isn’t your spouse, kids or dog! It’s even better when that friendly voice is imparting words of wisdom that make your job easier. So, that’s what Quest has…

  • 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…

  • Plug-N-Play! Monitor Oracle Pluggable Databases with Foglight

    In 12c, Oracle introduced support for a new architecture - multi-tenant. As such, the Container database (or CDB) was introduced. Think of the CDB as the 'super database'. This multi-tenant container database allows for many 'sub-databases'. These are…

  • Tune Your Queries with SQL Optimizer (Pt 2)

    In Part 1 of this blog post, I review how you can get an evaluation copy and explain the various integration points from Quest’s monitoring solutions – Foglight and Spotlight Enterprise. You can find it here -> https://www.quest.com/community…

  • Tune Your Queries with SQL Optimizer (Pt 1)

    One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are:

    1. Minimize Response Time – End users who are interacting with data want that data as quickly as possible. It may…
  • Toad and Foglight in harmony – The PL/SQL Profiler

    My favourite feature in Toad has always been the PL/SQL Profiler. I love the way it can profile your code executions is integrated with the editor. It is such an easy and visual feature to use.

    So if you have Foglight for Oracle Performance Investiga…

  • Foglight for Databases Quick Tip - Rules and Alerts for Baseline Deviation

    For those of you that have been using Foglight for some time may have seen how the solution not only captures and retains metric data historically, but also applies baselines to estimate the system performance and help with system monitoring and planning…

  • Reconsidering the idea of monitoring pre-production database instances

    It is a foregone conclusion that performance monitoring is part and parcel of managing a database instance once it is in production.  But what about pre-production?  Especially when the instance itself is reaching critical phases of testing and quality…

  • Customer Question: Setting Up ASM Monitoring with Foglight for Oracle

    Recently, I spoke with a customer who's using Foglight for Oracle to monitor their RAC instance. They were able to successfully monitor the instance, but then asked "Why don't I see any data in the ASM tab?". I think this is a great question and I thought…

  • 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…