Welcome to the Foglight NMS Community!

 Read Blog  Watch Videos  Get Support  Learn More
Foglight NMS Forum Posts
Foglight NMS Blog Posts
    • 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.
Recommended For You