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

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

  • Using Foglight to restart your windows services if they stop or fail.

    I was helping a customer recently in relation to database monitoring and they asked if Foglight could also help them with their windows OS service monitoring. The answer was yes of course, the OS agent used alongside the DB monitoring can also monitor…

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

  • Spotlight Enterprise Workload Analysis

    While your database handles requests from end-users, it starts to consume various resources. With increased number of requests, the database may suffer from resource waits. Excessive wait types and times may lead to performance latencies and degradation…

  • Monitoring Strategy Considerations

    IT Administrators need to keep an eye on Availability, Performance, and Storage of mission-critical environments.

    There are many things to consider as you develop a Monitoring and Diagnostics strategy. 

    Items to consider include:

    • All-in-one or Specialized…
  • Database Monitoring for Developers with Foglight

    Traditionally, DBAs are the ones primarily tasked with maintaining high availability and peak performance of the database environment. Therefore, they assume the responsibility of evaluating Performance Monitoring solutions. This requires identifying the…

  • A Review of Postgres version 12

    Postgres version 12 is here. Did you miss its introduction like me? My excuse is the year-end holidays (what's yours?). 

    Well, version 13 isn't planned for release until the fall, so there's plenty of time to brush up on v.12

    To give the nod…

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

  • How to Query the Spotlight Statistics Repository Database

    Just like most people’s goal towards incorporating more raw food into their daily diet, accessing and manipulating raw data is very much a coveted functionality.

    The Spotlight Statistics Repository database is a repository for historical data collected…

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

  • Spotlight Federation Steps

    We all get excited when our cell phone plan includes so called “Unlimited Data.”  But, you know what happens if we push your luck.  That’s right; we start to experience performance issues and get tossed into the dreaded 2G zone!

    A similar…

  • 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’…
  • Foglight, Play Some Funky Music

    We haven't added voice command to Foglight yet, but we can still get Foglight to play some tunes.

    I setup a small monitoring environment with a Foglight Management Server in a public cloud. I put a local Foglight Agent Manager on my laptop to talk…

  • "These go to eleven"

    PostgreSQL has entered an exciting new chapter with the release of version 11 (10/18/18). This blog highlights some of the version 11 additions and improvements to PostgreSQL.

    ** The information shared in this blog was largely gathered from the postgresql…

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

  • You serious, Clark?

    Imagine this.... you're hosting a Holiday Party...and the phone rings. You answer and the person on the other end says with a tense voice, "I'm sorry but we will be unable to deliver your beer, wine, and liquor order. The product never shipped."…

  • Adding Host Monitoring - Easy as 1-2-3 (4-5-6-7)

    When you first monitor a database instance, you have the option of adding the host too. But sometimes, the checkbox is un-checked. Now what?

    To add a host to monitor on it's own, switch the left-hand panel to Expert Mode, select the Infrastructure dashboard…

  • DBA Saves the World from Bad Pizza and Gets Promoted with Spotlight

    Imagine a world without tomatoes.

    Sure, it’d be great if you’re Fozzie Bear or some other old-timey comedian. But for the rest of us? It would totally suck.

    Pizza would just be circular cheesy bread.

    Spaghetti, a pile of sad, limp noodles…