• Multi-dimensional performance analysis and monitoring using Foglight’s SQL Performance Investigator (SQL PI) - Part 2

    Part 2 of this series will show you how to tune the queries you found by using Workload Analysis (see Part 1).  Additionally, we'll look at the different 'Context' dimensions to help you quickly focus on the right problem. 

      2. SQL Statements…

  • Has Anyone Seen My Indexes?

    As part of one’s Database Management strategy, one of the primary tasks at hand is to keep queries running at peak performance. One of the most impactful ways to do this is to identify ‘Missing Indexes’.

    Simply put, Indexes can allow…

  • (Another) Foglight Countdown!

    ( * This blog has been updated from last year's.... )

     

    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.

    • “Excuse me while I kiss this guy”. Correct lyric: “Excuse…
  • 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,…

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

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