Performance Monitoring Blog

    • Ch-Ch-Ch-Ch-Changes (-David Bowie)

      1 May 2018
    • The Only Thing That Is Constant Is Change “- Heraclitus.

      Development, new applications, upgrades, patches, maintenance, schema updates…the list goes on and on around ways that changes are introduced into your environment. Sometimes these changes improve system performance and other times, they have unintended consequences and break something. Either way, if you are tasked with maintaining the overall health…

    • Diagnosing Historical Sessions in SQL Server TempDB

      19 Apr 2018
    • In the recent 5.7.5.50 release of Foglight for SQL Server, a change was made to the TempDB drilldown. Specifically, the Sessions tab would formerly show the current sessions, regardless of the time range selected on the dashboard. Now, it will allow you to drilldown to the sessions that had activity in TempDB during the desired time range.

      To start, drilldown to the Databases dashboard, select TempDB (1), select your…

    • Reporting on Changes to Foglight Registry Variables

      6 Apr 2018
    • Registry variables in Foglight are mostly used as placeholders in rules in order to avoid hard-coding in values. 

      For example, a rule to check cpu utilization over a certain percentage could be coded as:

      1- #utilization# > 99.0

      or

      2- #utilization# > registry(cpu_high)

      The registry variable "cpu_high" would have a default value, and could be changed as needed. We would change it once on the Manage Registry Variables…

    • 7. Foglight Anwendertreffen

      9 Mar 2018
    • Am 10.4. 2018 findet das siebte Foglight Anwendertreffen in Köln statt. Das Treffen bietet Ihnen die Möglichkeit, sich über Neuheiten und Entwicklungen im Bereich Foglight zu informieren und Erfahrungen auszutauschen. Die Referenten kommen aus den technischen Bereichen, aus dem Produktmanagement und der Entwicklung der Quest Software GmbH. In diesem Jahr bieten wir die Möglichkeit am Vortag an einem halbtägigen Workshop…

    • Foglight Agent Manager in Docker Containers

      6 Mar 2018
    • Docker is an open platform for developing, shipping, and running applications. It provides the ability to package and run an application in a loosely isolated environment called a container. A container is lightweight and portable, which make it easy...
    • Do you have sensitive database rules?

      23 Feb 2018
    • You say “No” - well - I say “Yes”. All database rules are sensitive and have a sensitivity level.

      What does that mean? What is a sensitivity level? Where can I find it and can it be modified?

      Ok - a lot of questions, so let's start with the details.

       

      What is a sensitivity level?

      A sensitivity level is a template that defines which rule condition is being triggered. Different levels are available…

    • Foglight for Databases Quick Tip - Using the Workload Column in the SQL PI Dashboard

      14 Feb 2018
    • Many of our Foglight users including myself have grown accustomed to using the "Databases" home as their starting point into their daily monitoring tasks.  This dashboard provides a global view into all of the instances being monitored and gives the Foglight administrator access to alarm configuration and other settings related to the monitoring setup.  From a metric perspective, the Databases home provides some…

    • Spotlight on SQL Server Enterprise Tip: Reduce Noise Using Planned Outages

      13 Feb 2018
    • Naturally, it's VERY important to know when things are going wrong with our monitored instances. What's not helpful is the dreaded "False Positive." You know the scenario I'm about to describe. It's 03:00 and you're sleeping soundly and dreaming of the yacht you'll be sailing during your retirement. Suddenly, you're awakened by an alert that your instances are unavailable! During your fight for consciousness you start…

    • “License and Registration, please…” Spotlight

      12 Feb 2018
    • So, you’ve downloaded and installed an evaluation of Spotlight Enterprise. Good news…it comes with a 30-day evaluation license key! Spotlight is fully functional (not limited trial functionality). It simply expires after the 30 days. There are a couple of situations where you will need to apply a Spotlight license. Perhaps the Sales Rep you’re working with has provided an extended license to allow you more time to evaluate…

    • Foglight for Virtualization - A Year in Review

      8 Feb 2018
    • Wow! What a year and what a way to wrap it up. Foglight for Virtualization 8.7.5 is out and with it brings a brand new SaaS offering from Quest that enables connectivity from any Foglight for Virtualization installation in the world to the cloud. Try...
    • REST API Updates for Foglight 5.9.2

      6 Feb 2018
    • Foglight REST APIs have been firstly introduced in Foglight from version 5.7.5.7. Now, we embrace Foglight 5.9.2 release with awesome REST API new features as well as improvements which might help you to save your time working with Foglight. If you d...
    • Foglight for DB 2017 Summary and Look to the Future

      5 Feb 2018
    • 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 & Foglight for Oracle – In February 2017 we’ve released Foglight for SQL Server & Foglight for Oracle Performance Investigator v.5.7.5.35 which included 2 main…
    • Evaluating Foglight vs Oracle Enterprise Manager

      2 Feb 2018
    • 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 see evaluators take note of similarities and differences of architecture, usability and navigation, and product features that present specific information to help address…

    • Monitoring the Status of your TempDB using Foglight for SQL Server

      29 Jan 2018
    • In every SQL Server instance the TempDB database is the common global resource for all the operations taking place and DBA's are particularly cautious about the use of it.  Given the nature of applications and ad-hoc queries by users, one must keep track of the usage of the TempDB by various applications and process and take appropriate actions when the size falls below a certain limit.  To ensure optimal health of…

    • SQL or NoSQL, Foglight has you covered

      26 Jan 2018
    • Maintaining a cross-platform database environment has been common for twenty years or more. For all kinds of business or technical reasons, companies leverage different database types including Microsoft SQL Server, Oracle, IBM DB2 LUW, SAP Sybase, and open-source options like MySQL, MariaDB, and PostgreSQL.

      What all of these databases have in common is that they are all relational databases. The information is structured…

    • How to test connectivity if Telnet or Putty is not available

      23 Jan 2018
    • When reporting a Foglight connectivity issue, support people are always asking to test the connection using Telnet or Putty. But what to do if you do not have Telnet or Putty installed?

      There are some other options, for example using an Internet browser or running command line tools like curl or netcat.

      So let’s start with the browsers. To test the connection you type in the address line:

      http://<host>:<port>…

    • Foglight.. Start Your Engine!

      15 Jan 2018
    • This post is short but hopefully useful. When you start the Foglight server and navigate to the home page URL (http://foglight_server:8080 or https://foglight_server:8443), you may see a startup splash page (below). If you see a login page, then the Foglight server has started and is ready to use.

      You may wonder what the startup process is doing. Or not. If you're in the former group, you can click the lower part of the…

    • MySQL im Griff – Hilfe für den DBA durch TOAD Edge und Foglight

      9 Jan 2018
    • Neben den klassischen Datenbankderivaten, spielt MySQL eine immer größere Rolle in den Unternehmen. An den täglichen Aufgaben im Umgang mit Datenbanken ändert sich jedoch nichts. Auch MySQL Datenbanken müssen verwaltet und auf ihre Performance und Verfügbarkeit überwacht werden.

      Am 11. Januar 2018 um 16 Uhr findet zusammen mit GoodQuest IT Solutions und Quest Software das Toad User…

    • Top 5 challenges of managing cross-platform databases

      4 Jan 2018
    • If you’re like many DBAs, your life is probably getting more complicated by the week. Are you under pressure to manage larger and larger numbers of database instances? Or to adopt new database technologies like open source or NoSQL? With those changes, are you still required to ensure the best performance and stability for your entire environment? 

      A survey by Unisphere Research1 showed:

      • 72 percent of DBAs are responsible…