Performance Monitoring Blog

Welcome to our blogs

To help our user community locate the latest information about trends that are impacting their primary interest, we organize our community blogs by solution area.

  • Rechnen mit Metriken – Derived Metrics in Foglight

    Die Agenten in Foglight sammeln eine große Anzahl an Metriken, wie die CPU Utilization eines Hosts, die Memory Auslastung, die Anzahl der Ausführungen eines Statements usw.. Derived Metrics bieten die Möglichkeit, mit gesammelten Metr...
    • 20 Jun 2018
  • 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. Table ...
    • 19 Jun 2018
  • DBAs: The Ultimate Jugglers in the IT Circus

    Database projects have been growing in demand leaving DBA's responsible for numerous critical tasks at once. Check out our database management resources available to keep up on the latest trends.
    • 14 Jun 2018
  • SQL de Mayo - SQL Saturday #734 Dallas Recap

    Having fun with the "SQL de Mayo" theme at the conference One of the best things about working for Quest has been the numerous opportunities we get to participate in conferences, user groups and meet-ups related to the database technologies.  ...
    • 25 May 2018
  • Exceptional Database Exceptions in Foglight

    A common question is how to make an exception for 1 or 2 particular databases for certain rules in Foglight. A good example is the "days since last backup" rule for SQL Server. The global default applies to all databases. It's possible from the Databases dashboard to change the setting for a particular instance, or to add a database to an exclude list, but an exception to the default can't be done there.…

    • 1 May 2018
  • Ch-Ch-Ch-Ch-Changes (-David Bowie)

    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…

    • 1 May 2018
  • Analysis Time. Foglight & Rogue OS Processes

    Bubble Charts in Foglight for Virtualization for VMware, Hyper-V and OS Monitoring Analytics.
    • 26 Apr 2018
  • Exposing Foglight User-Defined Collection Data

    This post will cover one way to make it easy easier to get the user-defined collection data onto a dashboard or report.

    For a quick refresher, please see User Defined Collections in Foglight for SQL Server: A Quick Walk-Through


    With a "simple" UDC that returns a single value, adding it to a dashboard or report is a matter of finding it in the data model, and dragging it over. But what happens with a query that…

    • 10 Apr 2018
  • Reporting on Changes to Foglight Registry Variables

    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…

    • 6 Apr 2018
  • 7. Foglight Anwendertreffen

    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…

    • 9 Mar 2018
  • Foglight Agent Manager in Docker Containers

    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...
    • 6 Mar 2018
  • Do you have sensitive database rules?

    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…

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

    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…

    • 14 Feb 2018
  • Foglight for Virtualization - A Year in Review

    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...
    • 8 Feb 2018
  • REST API Updates for Foglight 5.9.2

    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...
    • 6 Feb 2018
  • Foglight for DB 2017 Summary and Look to the Future

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

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

    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…

    • 29 Jan 2018
  • SQL or NoSQL, Foglight has you covered

    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…

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

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

    • 23 Jan 2018
  • Foglight.. Start Your Engine!

    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…

    • 15 Jan 2018
  • Diagnosing IO Latency with Foglight for Databases

    Understanding the processes and configurations causing your bottlenecks

    IO is the single most important metric to know for creating optimal performance of your database systems.  To understand it, you’ll need to know the processes, resources and configurations involved.  Here you’ll see how Foglight for Databases gives you a clear view of these in a few clicks.

    Foglight can alert you with an email when unusual…

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

    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…

    • 9 Jan 2018
  • Top 5 challenges of managing cross-platform databases

    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…
    • 4 Jan 2018
  • Toad Cross Country Vacation

    Woohoo!  Just got word that my boss approved my January vacation and now I’ll get the opportunity to check several items off my bucket list as I hop across country to the Quest Database Fed Forum in DC on February 20th.  

    On my First stop I will meet up with SharePlex System Consultant Susan Wong @lasgav for a swim in the Pacific Ocean on New Year’s Day (she tells me; “it’s a thing”)!  I am…

    • 4 Jan 2018