Select a technology trend
Internet of Things
Identity and Access Management
Select a solution area
Microsoft Platform Management
Select a type
Products News and Updates
Performance Monitoring Forums
Virtualization and Storage
Application Performance Monitoring
Custom Dashboards and Scripts
All blogs RSS
Subscribe by email
Subscribe by email
By view count
By comment count
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 18.104.22.168 and lower. An easier, more secure and more scalable solution was introduced in 22.214.171.124 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 126.96.36.199 is now available
The Foglight team is pleased to announce that Foglight Management Server 188.8.131.52 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...
Subscribe by email