• 13 Jan 2017

    Spotlight 11.7.1 Is Now Available For Download

    Hear ye, hear ye! Spotlight version 11.7.1 is here! There are several fixes and a few enhancements included in Spotlight 11.7.1. The product fixes included are listed below for your reference: ID 6097 - Resolved an issue with the Spotlight Connection Manager, where Spotlight Connection Manager sometimes selected the wrong connection type to delete in cases where the request to delete a connection and the name...
    • 12 Jan 2017

    Making Connections with Spotlight on SQL Server (Now with Bonus Info)!!!

    Spotlight on SQL Server Enterprise provides excellent real-time monitoring and workload analytics for SQL Server and more, but before it can do that, you’ve got to point Spotlight to what you’d like it to watch. Luckily, that’s as simple as going to Configure > Connections to get to the Connection Manager: As you can see in the screenshot above, Spotlight can connect to a number of different types...
    • 12 Jan 2017

    Before you Migrate that VM to the Cloud

    When the day arrives that your IT leadership decides to incorporate modern cloud technologies into operations some new realities will come into play. First you need to put cloud computing into it’s proper perspective which makes the process for migration easier to define and execute. Cloud infrastructure is quite simply a collection of software defined computing resources managed and hosted by someone outside...
    • 10 Jan 2017

    Quest Customer Story: Spotlight on SQL Server Enterprise Provides Twofold Benefit for International Application Delivery Company

    It never gets old hearing about how Quest Performance Monitoring solutions offer actionable insight to mission-critical systems. Upon visiting a customer for a 'health check' of their environment, we had the pleasure of learning about two distinct ways Spotlight is providing value for them. The DBA Team Lead shared a recent experience in which Spotlight was instrumental in maintaining peak performance of their...
    • 9 Jan 2017

    Foglight Tip: Silence Alarms Using Blackouts

    During periods of scheduled maintenance, you may wish to prevent Foglight from sending alarms about the systems involved in the maintenance task. The use case is quite obvious. You know the system's down for maintenance and there's no need for you to be alerted to this fact. This is known as "blackouts" in Foglight. The process is quite simple: Decide whether you want to stop collecting data or...
    • 4 Jan 2017

    Why be NORMAL?

    When monitoring databases for performance , we certainly want to understand things like CPU spikes, memory pressure, I/O latency, and the like. If we see this type of performance, the next step is to take a closer look and attempt to find out what's causing it, right? But taking a step back for a moment, have you ever realized one of the first questions you are often asking yourself when you notice performance deviations...
    • 3 Jan 2017

    I Found My Foglight Hosts Services!

    I previously shared a challenge I had with finding the services that were created in the Hosts dashboard . Ideally we want to be able to use them in the Hosts and Infrastructure dashboards, but also add them to the Service Operations Console or attach them to an existing service definition in the Service Builder. To start, we'll add a new category in the Service Builder. Next, we'll add a child service to...
    • 30 Dec 2016

    Where Did My Foglight Hosts Services Go?

    I had a customer create a service definition for the result set of a search that was done in the Hosts dashboard. But we weren't able to view it in the Service Operations Console nor add it to an existing service definition in the Service Builder. For some background, in the Hosts dashboard, you can search for a string or a host name and view the matching results. From there, you can give that result set a name...
    • 28 Dec 2016

    End to end monitoring: How can I troubleshoot from the VM all the way to my storage array?

    Today I would like to share with you some content I created that can help an admin troubleshoot their environment from a single pane of glass. No more bouncing between different performance monitoring tools . No more trying to correlate different metrics derived in different ways from different tools. One Tool to rule them all, One Tool to find them, One tool to bring them all and out in the light bind them. I created...
    • 23 Dec 2016

    Spotlight on SQL Server Enterprise: Just the Facts! Part 4: What is the Alarm Setting?

    As we continue our navigation of Spotlight on SQL Server Enterprise and we can diagnose an alarm that triggers. Let us see what setting caused an alarm to trigger. The fact is when you start monitoring an Instance it is assigned the preset “Factory Settings. Those settings may need to be adjusted it may be a good practice to familiarize yourself with the setting values and determine if you should adjust them to...
    • 22 Dec 2016

    Spotlight on SQL Sever: Just the Facts! Part 2: Acknowledging Alarms from Spotlight Today

    Just the facts! Part 2 Acknowledging Alarms in Spotlight on SQL Server Enterprise Now that we have establish a view of the facts let’s see what we can do with them. Some on these alarms are set by default to be acknowledged before they will clear for the alarm list. I would like to take this opportunity to walk to through the process of “acknowledging” these alarms from the “Spotlight Today”...
    • 22 Dec 2016

    How to query Spotlight’s Statistics Repository database for historical transactions?

    The pursuit of historical data and its analysis is a significant part of the functionality that Spotlight on SQL Server users have come to expect and continue to seek improvements upon. In the past, users have expressed the need for ad-hoc query capability in order to review historical data. The ability to review historical monitoring data via a query or a report is a capability that Spotlight users are often requesting...
    • 22 Dec 2016

    Performance Analysis to Performance Investigator - Part 2: New and Enhanced Features

    In part one of Performance Analysis to Performance Investigator , I discussed the history of Performance Analysis and its transformation into Performance Investigator, as well as the architectural differences between the platforms. In part two, we will discuss the new and enhanced features that come with Performance Investigator. All along, our goal in this transition was to maintain the feature set that customers have...
    • 21 Dec 2016

    Optimizing Virtual Data Center with Foglight

    10 years ago, the synergy between application developers/administrators and systems administrators was very simple: dev team is building applications and sysadmins are building servers. Dev team owned application lifecycle, and sysadmins owned hardware lifecycle process. But, because it was generally difficult to predict application performance demand, in most cases application team would typically request a new server...
    • 19 Dec 2016

    Hyper-V vs VMware

    When it comes to choosing a virtualization platform there are many questions to ask, and often it's not just the technical requirements; financial pressures will impact the decision as well. With the release of Windows Server 2016, Hyper-V and SCVMM, many organizations will again be looking at diversifying their virtual environments across multiple platforms. To help, we have put together a short collection of resources...
    • 16 Dec 2016

    Capacity Planning Top Challenges – Part 2

    In this post, I’d like to focus on what has changed over the last 10 and 20 years in Capacity Planning and its challenges. Make sure to read Capacity Planning Part 1 before continuing on. I will start by covering couple of very important issues that Capacity Planners have to deal with. 1. Software License Cost Hardware used to be very expensive and it used to be a large part of any IT budget. Today that is very...
    • 14 Dec 2016

    Hyper-Converged VMware Virtual San (vSAN) Monitoring with Foglight

    When working with new and existing Foglight customers as they are planning to upgrade from vCenter 5.x to vCenter 6.x Infrastructure, the question is usually always asked, "Does Foglight support monitoring vSAN?" YES, Foglight supports monitoring vSAN. vSAN is Software-Defined Storage (SDS) or can be simply described as server-attached hard disks and/or flash devices, in 2 or more Hosts to create a high performing...
    • 13 Dec 2016

    Just the Facts! Part 3-Diagnose the Issue

    The original “ Just the Facts ” blog I discussed how to see just the Alarms displayed in “Spotlight Today” within Spotlight on SQL Server Enterprise. Now it is time to see what we can do with those Facts or Alarms. Spotlight comes with factory settings, these setting can be customized to your environment. However it would be advantageous to determine what the alarms are telling us as they are triggered...
    • 12 Dec 2016

    Foglight LDAP Group Integration for Virtualization Administrators

    A customer recently asked if it was possible for Foglight to integrate with Active Directory. To take it a step further, use the Member(s) of a existing Active Directory Group to access Foglight and when the Group Member(s) login, they can only see VMware related dashboards. In Foglight, Go-To Administration ->Users & Security Management -> Configure Directory Services Edit and Enter the Location of...
    • 8 Dec 2016

    A Quest Approach to API Monitoring with Foglight

    Quest has recognized the growing importance of APIs and has taken steps to ensure they are properly addressed in the most recent versions of Foglight . It’s a great way to augment Foglight’s Virtualization and database performance monitoring so that correlations to the health of a host and/or database can be correlated to the performance of their transactions. This is an area of interest that I will be spending...
    • 8 Dec 2016

    Bridge the Monitoring Gap with Spotlight Developer

    Recently, I presented our Spotlight on SQL Server Enterprise solution to someone who expressed concerns about being notified of problems in the monitored environment. In this person's scenario, he mentioned that their organization did not have a Help Desk or Operations group. Essentially, he couldn't rely on a team of people to be watching the Spotlight console and waiting for the alarm conditions to occur. As...
    • 7 Dec 2016

    Monitoring Raspberry Pi with Foglight - Part 2

    In part one of monitoring Raspberry Pi with Foglight , I showed that the Infrastructure agent worked pretty much as expected when collecting from the Raspbian OS. I was curious though if it exposed any metrics via snmp. The first step was to check if snmpd was even installed and running. I ran "sudo /etc/init.d/snmpd restart" and to my mild surprise, it showed the service restarting. Now it was time...
    • 6 Dec 2016

    Foglight Newsletter – December 2016

    Announcements Coming soon…A new Quest We are on a quest – one that’s built upon an exceptional past and is sure to deliver an unprecedented future. And we want you to be a part of it! Watch the new Quest, join the innovation video now and get a preview at what's coming next. Then, register to be one of the first to receive all the latest news as we transition to this new chapter. Product...
    • 4 Dec 2016

    Keep Your Pi from Burning with Foglight - Part 2

    In Keep Your Pi from Burning with Foglight , I showed how to use script agents to collect data from a Raspberry Pi's built-in CPU temperature sensor and display a graph like this: In this installment, I'll show you how to create a rule that will check those temperatures to be sure your Pi's not burning. We'll start by defining some thresholds, one each for Warning, Critical and Fatal temperature...
    • 2 Dec 2016

    Report for Duty, Part II - Spotlight Performance Monitoring

    Customizing and Automating Spotlight on SQL Server Enterprise Reports In my previous post, I wrote about configuring and executing reports using Spotlight on SQL Server Enterprise. The purpose of this entry is to describe, at a very high-level, what's needed to customize and automate the execution of these reports. I'll introduce the topics of Microsoft's Report Definition Language (RDL) and SQL Server Reporting...