• 24 Jul 2017

    Making Dashboards Available to non-Foglight Users

    Some users only require simple access to Foglight dashboards, ideally being able to skip the logon step. The NoLoginUser was designed to allow the passing of a dashboard id via URL, and bypass the login step. This should only be used on Foglight Management Server version 5.7.5.6 and lower. An easier, more secure and more scalable solution was introduced in 5.7.5.7 in February 2017. WARNING - This NoLoginUser feature...
    • 24 Jul 2017

    “Pimp Your Ride” with Foglight Custom Dashboards

    Merriam-Webster defines ‘Custom’ as made or performed according to personal order. Tailored, fitted, personalized…or ‘pimped out’, slang meaning something is modified to extreme performance. There was a television serie...
    • 11 Jul 2017

    How DevOps can benefit from Continuous Monitoring of Application Databases

    Managing production application databases has become more demanding than ever before not only due to the complexity of the applications they support, but also the very small margins for performance slowdowns or outages. Being proactive and resolving issues quickly in production requires the collaboration of the operations, DBA and development teams. The Emergence of DevOps Over the years a lot has changed when it...
    • 27 Jun 2017

    What are Organizations in Spotlight Essentials and how do you manage them?

    It is now possible for you to sign in and create an organization in Spotlight that your whole team can join. You simply create the organization and invite others to join and share their monitoring and analysis data with you. Until now if your team each had their own separate Spotlight accounts you couldn’t easily share your monitoring and performance data with them, but now you can. You can now share data with...
    • 27 Jun 2017

    Setting up Foglight when SQL Server wants SSL

    A customer recently had this error message when trying to monitor a new SQL Server instance: Reason : [Foglight][SQLServer JDBC Driver]The SQL Server login requires an SSL connection. They didn't want to disable the requirement for an SSL connection, so we followed the following steps. Thanks to Jason Hall for the tip! Start by selecting the option to discover multiple SQL Server instances: Select the Foglight...
    • 21 Jun 2017

    Foglight Dashboard for Web Transactions

    Wondering where to find the Webmonitor metrics for use on a custom dashboard? You will find them on the Data tab, but there is no pre-defined category for them. Start by checking the "show all" box, and then expand Services and All Model Ro...
    • 20 Jun 2017

    Group By - Not Just a SQL Clause

    Foglight has many dashboards that you can give users access to. The Databases dashboard has built-in user access control to limit access to only the instances that a Foglight administrator grants. I had a customer ask if there was an easier way to limit access to their instances. They were mapping each Foglight user to individual instances. This is an ok practice if you've got a small number of instances and users...
    • 12 Jun 2017

    Customizing Spotlight on SQL Server Alarms

    Tweaking performance monitoring to work exactly the way you want Spotlight on SQL Server comes ready out-of-the-box to help you navigate your SQL Servers’ performance metrics in real-time . The settings that define what Spotlight sees as healthy and unhealthy ranges for performance metrics come pre-configured to values that work well for most IT departments. But Spotlight is highly customizable, and if you would...
    • 12 Jun 2017

    Saving Foglight Reports to Disk

    You can generate on-demand or scheduled reports in Foglight to a number of formats. These can be setup to be emailed at the time of generation, or they can be reviewed later via the Foglight UI (Reports -> Manage Reports). This post will show how to save a report to a disk local to the Foglight Management Server at the time of generation. I had some groovy code from 2011, so I thought it would be worth a refresh...
    • 1 Jun 2017

    Foglight Management Server 5.7.5.8 is now available

    The Foglight team is pleased to announce that Foglight Management Server 5.7.5.8 is now available for download. Over the past year, we have been delivering quarterly releases focused on improving the reliability, performance and manageability of Foglight. We have seen significant improvements in performance and stability, especially for large, multi-domain enterprise style installations, and have delivered many usability...
    • 31 May 2017

    Quest Customer Story: Foglight Performance Investigator Use Cases shared from the trenches

    As a Sales Engineer for the Database Performance Monitoring team, one of the more rewarding aspects of my role is to learn about specific ways that our customers are leveraging Quest solutions. With that in mind, I am a firm believer that if something proves useful to one user or team, it's a good bet it'll be helpful to many other end-users as well. That, and my mom always reminded me to share. So, here we go...
    • 30 May 2017

    Can Spotlight Monitor Tempdb Database?

    Absolutely! Spotlight performance monitoring can do it all. It can monitor the health of your Tempdb, so you can have the peace of mind of knowing that Spotlight’s got you covered. It not only ensures best practices by being on the lookout for configuration related issues. It also alerts you of any possible Tempdb contention and excessive database usage. Spotlight monitors tempdb and reports issues by through the...
    • 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...