• 25 May 2017

    What's Cool in Spotlight Enterprise Version 12.0

    On Tuesday, May 23rd, Spotlight Enterprise version 12.0 was released to the wild. There are a considerable number of enhancements, both big and small, that are included in this release (for the full list, check out the release notes ). Without diminishing the value of each and every enhancement (many of which came straight from our customers requests), I wanted to highlight those enhancements that I am most excited about...
    • 15 May 2017

    Overview of Foglight Management Server and Agent Manager upgrades

    How would you like to have a quick reference point for your Foglight Management Server (FMS) or Foglight Agent Manager (FglAm) upgrades? This article is designed to help you determine the best steps to take to upgrade your type of FMS and FglAm. Hyperlinks are included for specific topics which direct to the area of interest in the Upgrade Guide. FMS Types Standalone FMS - Typical installation FMS HA - High...
    • 11 May 2017

    Getting Started with the Storage SDK: Monitor any Storage Array with Foglight Storage Management SDK

    Foglight Storage Management provides support for monitoring Dell Compellent (including Dell Storage Manager) & Equalogic , EMC Clariaon , CX , VMAX , VNX & Isilon , Hitachi AMS , VSP & USP , HP EVA and 3PAR , NetApp OnTap 7, 8, 9 including Cluster Mode. However, there are many arrays on the market and here at Quest, we want to ensure that anyone can monitor whichever array their business has invested in. This...
    • 1 May 2017

    Considerations when projecting database growth using Foglight

    Every now and then I run into a conversation with my clients around planning capacity for anticipated database growth. Although there are straight forward methods for calculating data/log file and object growth rates from catalogued views in the database which lead to linear predictions, there are several considerations that must be taken to make this exercise more appropriate in the real-world. Figure 1 – Instance...
    • 19 Apr 2017

    Auto Refreshing the Performance Investigator Dashboard

    The SQL Performance Investigator dashboard provides a rich set of data to analyze workload on your SQL Server and Oracle instances. The main use case is to use the data for historical analysis - after the problem has occurred. However, if you'd like to use it in near real-time so that it refreshes automatically, you can make a simple change to do that by following these steps: 1- click the > on the right...
    • 18 Apr 2017

    Foglight Educational Webcast on Tuesday, April 25: Tips for Rule and Alarm Management

    If you use Foglight and are responsible for ensuring that performance monitoring alarms are helping your organization focus on important performance bottlenecks and resource constraint problems, you'll benefit from learning important aspects of handling rules and alarms in Foglight. Alarms are generally fired by rules that detect an alarm state in something of importance to you - perhaps a key performance indicator...
    • 28 Mar 2017

    Getting Ready to Query the Foglight Performance Investigator Repository

    The backend repository for the Foglight Performance Investigator is based on Infobright , an analytics engine for machine generated data. However, you can connect natively via anything that can connect to PostgreSQL. The schema reference for Performance Investigator is available for Oracle and SQL Server from support. But how do we get setup to start building queries? We'll need some tools. Naturally, I prefer...
    • 20 Mar 2017

    Benchmark Factory - Getting Started With SQL Server Custom Workloads

    Quite often when I discuss BMF with customers they want to understand how to generate workload for their existing stored procedures. As part of their development life cycle if a change is made to a stored procedure they want to re-run a test and make sure response and scalability hasn’t degraded. While BMF has capture replay capabilities, this distinct feature for regression testing can be tricky to workout. ...
    • 9 Mar 2017

    Slacking off? How to Send Foglight Alarms to #slack

    This post will show how to integrate Foglight alarms into a #slack channel. It is a very easy and quick process. The longest step will likely be to request email app access from your slack admin. Once you have received approval to use the slack email integration, you can add an email integration to your slack channel. Either pick a channel from the list, or create a new channel. You can then customize the name that...
    • 3 Mar 2017

    Three Routes Through an Ocean of Performance Metrics

    Navigating with Foglight for Databases Behind the opening screen of Foglight for Cross-Platform Databases lies a wealth of overview and detail screens to give you a clear picture of database performance issues and their causes. But to really take advantage of what the tool provides, you need to have a sense of how to get around. In this post, I’ll show the three key ways to navigate. First, we’ll cover...
    • 27 Feb 2017

    Customize Alarm Key Values in Spotlight

    Spotlight’s vast alarm customization capabilities enables users a wide variety of options. Setting alarm severity levels, their start and end threshold values, or disabling them completely are just a few. Fortunately, Spotlight performance monitoring takes customization to another level. In general, alarms are generated based upon the value returned from a collected set of data. Alarms can be further classified...
    • 27 Feb 2017

    Spotlight Alarms and Powershell Execution

    Spotlight notifies DBAs of performance issues via triggered alarm messages. More importantly, specific actions can be taken based on these alarms, by configuring the Alarm Actions feature of Spotlight. Read our blog about Alarm Actions configuration steps to learn more. Some common actions are sending an email, suppressing the alarm or running a program. Additionally, executing a Powershell script is another available...
    • 20 Feb 2017

    The Importance of Performance Benchmarking to Decrease Op Ex

    Throughout my career I have conversed with many IT leaders that have adopted the practice of measuring the performance of their technology assets by monitoring key performance indicators (or KPIs). Most of them will tell you that there needs to be some standard against which KPIs are measured and compared. The process of comparing a set of key performance metrics against some kind of objective standard is a form of benchmarking...
    • 2 Feb 2017

    Foglight for Virtualization: Top 5 Reports You Should be Running (but probably aren't!)

    Find out what reports you should be running to gain better insight into your environment.
    • 1 Feb 2017

    Creating Rule for User-Defined Queries in Foglight

    One of the powerful features of Foglight for Oracle and Foglight for SQL Server is the ability to enter your own database queries (SQL) and have the Foglight collector execute these and return data. Trent Mera wrote a great blog on this topic called User-Defined Collections (UDC). Once the data "hits" Foglight, it can be used like any other metric. For example, you could add the results to a drag 'n drop...
    • 31 Jan 2017

    Spotlight on SQL Server Installation Requirements (and Optional Walk-Through)

    Installing Spotlight on SQL Server If you’d like to take Spotlight on SQL Server for a spin, this post will tell you what you’ll need to do it in terms of hardware, permissions and settings. First, you’re going to need the installer, which you can get from Spotlight on SQL Server Enterprise . Download the .exe file, along with the docs available. The trial software is the full Spotlight product with...
    • 31 Jan 2017

    Foglight Skills 101: Send Emails when Alarms Fire

    Foglight administrators and other Foglight performance monitoring users who are asked to configure alarms to send email notifications sometimes struggle if they miss a step or two in the process. This post is meant to take you through the basics, and help you be successful the first time. No matter which Foglight cartridges you have installed and have put into use, a few requirements need to be met to send email notifications...
    • 31 Jan 2017

    Foglight for SQL Server: Business Intelligence Monitoring - SQL Server Integration Services

    Microsoft has evolved their marketing over the past several years to focus on the fact that SQL Server is more than just a Relational Database Management System (RDBMS). You may have noticed, that Microsoft commonly now refers to SQL Server as the SQL Server Data Platform, highlighting the fact that SQL Server includes Business Intelligence capabilities, on top of it's industry leading relational database system....
    • 31 Jan 2017

    Send a VM Performance Report to a User

    Are your users constantly asking for VM performance reports? Get them off your back by following these easy steps!
    • 30 Jan 2017

    How Do I Configure Foglight to Send Me Text Message Alerts?

    Want to receive Foglight alerts on your mobile device? Follow this guide to learn how!
    • 30 Jan 2017

    Monitoring IT Operations in the Datacenter

    The question for those in data center operations management is not which tool but rather what combination of tools will provide the right metrics at the right time. Quest solutions are part of the larger IT ecosystem and thus our products tend to integrate well with other complimentary and even competitive solutions. Foglight is one such product. It is often times made the record of truth for enterprise performance monitoring...
    • 30 Jan 2017

    Your Performance Monitor Might be Alerting Exactly How You Told it To - Badly

    The first lesson in my first computer class in school taught this: “garbage in, garbage out”. The point, of course, was that an information system can only act according to what it’s been told. It can’t read minds and assume what you meant rather than what you’ve told it. Well, maybe some can now, but that’s for another discussion. If you look at your performance monitor as an information...
    • 29 Jan 2017

    Installing a New SSL Certificate on Your FMS (In 6 simple steps!)

    Follow these simple steps to install your own SSL certificate on your FMS.
    • 27 Jan 2017

    How to Turn Off Specific Foglight Alarms

    In a previous post, we learned how to disable specific Foglight alarm severities . For example, maybe you don't want a warning alert when cpu utilization is only at 70% - if so, you can disable that, while keeping the rule active to alert when the condition gets worse. After letting Foglight monitor your environment for "a while", you might find some rules that aren't relevant for you. In that case...
    • 27 Jan 2017

    Getting Spotlight on SQL Server Deployment Numbers

    A customer recently had the need to get a count of the number of SQL Server instances that Spotlight on SQL Server is deployed to. There are several ways to do this, depending on requirements and how fancy you'd like to get. The simplest way is to simply look at the Spotlight interface on the left hand panel for the default "SQL Server" view and note the number of instances that Spotlight is configured...