Welcome to the Foglight Community!

 Read Blog  Watch Videos  Get Support  Learn More
Foglight Forums
Foglight Forum Posts
Foglight Wikis
Foglight Blog Posts
    • 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...
    • 27 Jan 2017

    Fun with the Foglight Rule Editor

    A previous post showed how to modify a registry variable to apply a value to a specific host . It would be good if the actual value that is going to be used when the rule fires could be validated. The "Run Condition Query" feature in the Rules Editor will help. As a reminder, here are the scoped values that we used for the Page In rate. The global value is 256.0. We scoped the value to host fglstudent5...
    • 26 Jan 2017

    Setting Different Alarm Thresholds for Different Hosts

    In a previous post, the Rules dashboard was used to show how to modify the global value of an alarm threshold . For this particular rule, that value would then apply to all hosts that are being monitored. What if we only want a subset of hosts to take on a different value? This tutorial will show you how to do that. Starting in the Rules dashboard, locate the rule to modify. Clicking the button shown in the image below...
    • 26 Jan 2017

    Spotlighting the 3:00AM Call

    As a former database administrator , one of my biggest concerns was getting a call in the middle of the night. Sometimes the call would be a system alarm going off, but most of the time it was a member from an overseas we supported. There is nothing l...
    • 25 Jan 2017

    Do you know what your applications look like? Application Topology even for Composite applications

    The bigger the application, and the more composite it is, understanding its Topology becomes a lot more important. What is connected to what? How are the flows for the transactions? Where are the bottlenecks and the slowdowns? I have seen some really ugly Topology diagrams. The one that comes to mind was one that one of my customers showed me. It was a ring. I should say it was like a pearl necklace, with about 50 pearls...
    • 25 Jan 2017

    A Blog About the Foglight Alarm Log

    I recently showed a customer how to modify the thresholds and severity levels of Database alarms by using the Foglight for Databases administration dashboard. A follow-up question was about how to do the same thing for alarms that were appearing for ...
    • 24 Jan 2017

    What are Foglight services and what do they mean to me?

    In a number of different areas, you will notice a reference to ‘services’. What are these and why should I care? Services could change the way you interact with Foglight. Services are nothing more than a group of objects. You can create static lists of specific objects (something like all the most critical servers, or all the servers in a specific site, etc…), or dynamic lists that are built and maintained...
Recommended For You