• 21 Sep 2017

    Be Ready for Tomorrow. Quest VROOM 1.2 launches and we're bringing Hybrid Cloud management to Microsoft Ignite

    What's great about being a product manager? To me, the list is long, however, today it's the release of Quest VROOM 1.2 and Foglight for Virtualization 8.7, and it's not for the normal reasons. Sure, I'm excited about a new release, i always am, they take an unbelievable amount of hard work, that aside, this release is special. The RnD team I work with has done a brilliant job; they not only met the...
    • 19 Sep 2017

    How to configure Foglight to run as a daemon on a Unix Machine?

    Once you installed Foglight on a Unix machine, you might want the Foglight processes to start/stop automatically when you reboot the machine. This is not difficult to do and the Foglight installation includes already init.d-styled scripts which can be used. As Unix machines are often customized, the scripts are model scripts and provide the basic required functionality. You might need to customize the scripts further...
    • 1 Sep 2017

    Creating your own cartridge

    To create your own cartridge, you need to install the Cartridge Builder. If you haven’t done yet, go the blog “ Installing the Cartridge Builder tool ”. If you have done it already, you can start to create your own cartridge to export custom dashboards, rules, report, … from your test server to apply it on your production server. The example below shows how to export specific rules. So first...
    • 1 Sep 2017

    Installing the Cartridge Builder tool

    Do you wonder how the Quest technical stuff creates cartridge files to hand over customized dashboard, reports or agents to you? Well, everyone can do that, this is no rocket science. And best is, you have all what you need available in your Foglight installation already. No need to download additional files! The needed tool is the Cartridge Builder (previously known as FglIDE) which is designed to extract custom dashboards...
    • 28 Aug 2017

    Spotlight Enterprise Migration

    System administrators find themselves frequently applying required updates to their server hardware, operating system, security packages, or disaster recovery processes in order to maintain system and data integrity. Such enterprise modifications occasionally require updates to the server applications within the system. Consequently, administrators have to address the migration of these tools as well. The good news...
    • 17 Aug 2017

    Combat GDPR with Quest's Microsoft Platform Management Tools

    As we become ever more reliant on technology we are seeing more and more threats to our data. These threats are not only coming from the “bad guys” out there knows as hackers like Hank . They can also come from malicious employee who feel hard done by and want to get their own back. The negligent new IT admin making changes to their Active Directory without thinking of the repercussions to the business, followed...
    • 8 Aug 2017

    Monitoring Workload – Heads or Tails, it's two sides of the same coin

    I often get asked about monitoring SQL workload that is consuming a database instance’s resources. The first question that comes to my mind is, “What is the symptom you are trying to resolve?” Are you looking to understand the root cause of compute resource consumption such as CPU, I/O, memory and timing? Or are you looking to get to the bottom of a specific set of wait events that have been present...
    • 1 Aug 2017

    "Foglight Skills 101” Webcast Series

    We recently started this webcast series directed specifically at existing Foglight administrators and users within your organization. We call the series, “Foglight Skills 101.” We present topics that have a broad interest among administrators and users – people who use Foglight often, but who might need some help getting up to speed with an important feature/function of Foglight. This series takes...
    • 1 Aug 2017

    Using tokens for Foglight dashboard access

    Some users only require simple access to Foglight dashboards, ideally being able to skip the logon step. In Foglight Server version 5.7.5.7, the user security option of an auth token was introduced. My colleague @Beam.Liu wrote an excellent blog on the subject . Start by going to dashboard that you wish to share via URL. From the right hand drawer select Properties->Link to this Page. From the dialog note the...
    • 31 Jul 2017

    Foglight for SQL Server Quick Tip - Database Exclusion

    If you are someone who is responsible for administering Foglight when used for monitoring SQL Server Instances, you will likely run into the situation where you want certain databases to be neglected from the overall monitoring. There are going to be those databases that don't conform to the overall monitoring policies and practices and can create a lot of noise when it comes to alerts related to backup, availability...
    • 27 Jul 2017

    Refine Spotlight on SQL Server Enterprise Alarms Using Key Values

    In a previous post, I explained how to customize alarms in Spotlight on SQL Server Enterprise. Recently, I had a customer inquire how he could refine the "Days Since Last Full Backup" alarm. He wanted to be able to exclude specific databases, but specify different thresholds for different databases. For example, user databases are backed up every 3 days, but system databases are backed up every 10 days. How...
    • 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...