• Uncover the Culprits: Identify Time-Consuming Queries with Foglight

    Query Insights: Coming soon in Foglight v6.3!

    As organizations rely more on data to make critical business decisions, ensuring that their databases are running efficiently becomes increasingly important. A database slowdown or crash can result in a significant…

  • Adding Service Emails to Foglight

    Foglight has rules which fire alarms on specific events, but it can also fire alarms for a group of objects as part of the service builder configuration. This is important if you have a service, let’s say a mixture of monitored objects, like OS, databases…

  • "Foglight Skills 101” Fine-Tuning Your Monitoring

    Put to use some of the built-in facilities of Foglight to make your monitoring even more effective and valuable:  registry variables, schedules, services, and the security model.

     

     

    Find More Time for Innovation and Helping Your Business:  Invoke Variables…

  • Can you believe this Administration?!

    What’s that you say? You think it may not be appropriate that a technology blog dive into politics?

    Agreed. Instead, this blog highlights the breadth of Administration capabilities available in Foglight for Postgres.

    Administration options are available…

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

  • Identify Long Running Queries with Foglight

    April 15, 2019.....Let’s give a shout out to all those men and women running the Boston Marathon today.

    Man, running for that long must be taxing. Taxing…..wait…what day is it again?

    So, as my way of giving a nod to long runners,…

  • The Wonderful World of Service Definitions in Foglight

    A UI Query can be used to add either static or dynamic components to a service definition via the Service Builder dashboard. This in turn offers a
    great range of additional things Foglight can do. This post will introduce creating a service definition…

  • Where can UI Queries be Used in Foglight?

    In my Introduction to UI Queries  post, the building of a simple query to return all SQL Server Agent Jobs was shown.

    Let's back up a step, and take a look at where UI Queries can be used in Foglight. This post will be updated with links as the topics…

  • The Foglight Countdown

    We have all done it. We think we know the lyrics to a song. We sing them passionately….and incorrectly. Here are a few classics.

    • "Sweet dreams are made of cheese”. Correct lyric: “Sweet dreams are made of these” from The Eurythmics’…
  • Simple Way to Add E-Mail Notifications

    Foglight has a robust rules engine for alerting and notification. It's often the case that you can get to the same end zone in Foglight by many different plays.

    Using the Service Builder is an easy way to group "things" together. "Things" can be higher…

  • Monitor Postgres Disk Space Usage with Foglight

    Many things can happen if the database runs out of disk space. None of them are good. DBAs understand that it is essential to monitor database disk space so that critical business processes are uninterrupted. Quest’s Foglight provides peace of mind by…

  • Lost on the Database Overview dashboard?

    Do you also feel lost sometimes when searching for a specific instance on the database overview dashboard? If you monitor hundreds of databases it is easy to lose the overview but there are some options to quickly find the database you need.

    1. Table filter…
  • 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…
  • Foglight API - 0 to 100 MPH in 2 demos

    The purpose of this post is to familiarize Foglight stake-holders and developers with the new Foglight API.  I will go from showing something very basic in the first 10 minute video, to a more advanced coding use case in the second video.  Before we start…

  • I’ve Forgotten Why I’m Out of Memory: JVM Settings for Foglight

    As you might suspect, I had difficulty coming up with a witty title for this blog. However, I rather enjoy people rolling their eyes when I make bad jokes. Given the topic is about memory settings for Foglight’s Management Server (FMS) and Foglight’s…