• 19 Apr 2018

    Diagnosing Historical Sessions in SQL Server TempDB

    In the recent 5.7.5.50 release of Foglight for SQL Server, a change was made to the TempDB drilldown. Specifically, the Sessions tab would formerly show the current sessions, regardless of the time range selected on the dashboard. Now, it will allow you to drilldown to the sessions that had activity in TempDB during the desired time range. To start, drilldown to the Databases dashboard, select TempDB (1), select your...
    • 10 Apr 2018

    Exposing Foglight User-Defined Collection Data

    This post will cover one way to make it easy easier to get the user-defined collection data onto a dashboard or report. For a quick refresher, please see User Defined Collections in Foglight for SQL Server: A Quick Walk-Through With a "simple" UDC that returns a single value, adding it to a dashboard or report is a matter of finding it in the data model, and dragging it over. But what happens with a query...
    • 6 Apr 2018

    Reporting on Changes to Foglight Registry Variables

    Registry variables in Foglight are mostly used as placeholders in rules in order to avoid hard-coding in values. For example, a rule to check cpu utilization over a certain percentage could be coded as: 1- #utilization# > 99.0 or 2- #utilization# > registry(cpu_high) The registry variable "cpu_high" would have a default value, and could be changed as needed. We would change it once on the Manage...
    • 5 Mar 2018

    The International Day of Awesomeness is upon us and you should celebrate

    DBAs are all kinds of awesome. We’re smart. Stylish. Capable of administering databases ! Who else can say that? Yeah. Just DBAs. Our technical wizardry is second to none. Because we’re awesome . And guess what today is. It’s our day. That’s right. March 10 doesn’t just represent the seven-day countdown for ingesting so much green beer the sewers run emerald with the evidence of our Saint...
    • 23 Feb 2018

    Do you have sensitive database rules?

    You say “No” - well - I say “Yes”. All database rules are sensitive and have a sensitivity level. What does that mean? What is a sensitivity level? Where can I find it and can it be modified? Ok - a lot of questions, so let's start with the details. What is a sensitivity level? A sensitivity level is a template that defines which rule condition is being triggered. Different levels...
    • 16 Feb 2018

    Tune Your Queries with SQL Optimizer (Pt 1)

    One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are: Minimize Response Time – End users who are interacting with data want that data as quickly as possible. It may be mission-critical data ( e.g. medical, financial). Often, the speed with which the data is returned shapes the level of customer satisfaction. No one likes to...
    • 13 Feb 2018

    Spotlight on SQL Server Enterprise Tip: Reduce Noise Using Planned Outages

    Naturally, it's VERY important to know when things are going wrong with our monitored instances. What's not helpful is the dreaded "False Positive." You know the scenario I'm about to describe. It's 03:00 and you're sleeping soundly and dreaming of the yacht you'll be sailing during your retirement. Suddenly, you're awakened by an alert that your instances are unavailable! During...
    • 12 Feb 2018

    “License and Registration, please…” Spotlight

    So, you’ve downloaded and installed an evaluation of Spotlight Enterprise. Good news…it comes with a 30-day evaluation license key! Spotlight is fully functional (not limited trial functionality). It simply expires after the 30 days. There are a couple of situations where you will need to apply a Spotlight license. Perhaps the Sales Rep you’re working with has provided an extended license to allow you...
    • 8 Feb 2018

    Foglight for Virtualization - A Year in Review

    Wow! What a year and what a way to wrap it up. Foglight for Virtualization 8.7.5 is out and with it brings a brand new SaaS offering from Quest that enables connectivity from any Foglight for Virtualization installation in the world to the cloud. Try...
    • 5 Feb 2018

    Measuring the Impact of Meltdown and Spectre Patching on your Databases

    The new year kicked off with some big news on January 3rd, 2018 with the news of the Meltdown and Spectre chipset vulnerabilities. There are a lot of resources available to understand the details and potential impact. This one from cnet.com is pretty good. As the patches from the operating system vendors are being rolled out, a question often comes up - "How will this impact me?" Specifically, it's the...
    • 2 Feb 2018

    Evaluating Foglight vs Oracle Enterprise Manager

    As part of most any database monitoring software evaluation, it includes comparing that software to similar solutions. Logically, it often means doing head-to-head comparisons to database tools that come bundled with that particular DBMS. Regularly, I see evaluators take note of similarities and differences of architecture, usability and navigation, and product features that present specific information to help address...
    • 29 Jan 2018

    Monitoring the Status of your TempDB using Foglight for SQL Server

    In every SQL Server instance the TempDB database is the common global resource for all the operations taking place and DBA's are particularly cautious about the use of it. Given the nature of applications and ad-hoc queries by users, one must keep track of the usage of the TempDB by various applications and process and take appropriate actions when the size falls below a certain limit. To ensure optimal health of...
    • 15 Jan 2018

    Foglight.. Start Your Engine!

    This post is short but hopefully useful. When you start the Foglight server and navigate to the home page URL (http://foglight_server:8080 or https://foglight_server:8443 ), you may see a startup splash page (below). If you see a login page, then the Foglight server has started and is ready to use. You may wonder what the startup process is doing. Or not. If you're in the former group, you can click the lower...
    • 12 Jan 2018

    Required Ports For Spotlight

    Spotlight Diagnostic Server must be able to maintain bi-directional communication with every monitored host. Additionally, it must be capable of sending and receiving data from every Spotlight Client application in addition to sending data to any properly configured Spotlight Cloud. Spotlight utilizes designated ports for such communication protocol which facilitates the monitoring. These ports also allows for provisioning...
    • 4 Jan 2018

    Top 5 challenges of managing cross-platform databases

    If you’re like many DBAs, your life is probably getting more complicated by the week. Are you under pressure to manage larger and larger numbers of database instances? Or to adopt new database technologies like open source or NoSQL? With those changes, are you still required to ensure the best performance and stability for your entire environment? A survey by Unisphere Research 1 showed: 72 percent of DBAs...
    • 4 Jan 2018

    Toad Cross Country Vacation

    Woohoo! Just got word that my boss approved my January vacation and now I’ll get the opportunity to check several items off my bucket list as I hop across country to the Quest Database Fed Forum in DC on February 20th . On my First stop I will meet up with SharePlex System Consultant Susan Wong @lasgav for a swim in the Pacific Ocean on New Year’s Day (she tells me; “it’s a thing”)! I am...
    • 27 Dec 2017

    How to use GDPR compliance as your competitive edge

    It’s all too apparent that most organisations facing the General Data Protection Regulation (GDPR) are seeing it as a costly, time consuming hurdle that they need to reluctantly resolve with as little financial investment or business interruption as possible. However, we really need to be looking at why GDPR came into existence in the first place, and how it is an excellent opportunity for organisations to gain...
    • 22 Dec 2017

    Can multiple emails be used to access one Spotlight Cloud account?

    Spotlight on SQL Server Enterprise users would like to share the instances that are being monitored by Spotlight to their bosses and other employees without installing the Spotlight client on their desktop. The question is, how can this be done? Does the Spotlight Cloud ( www.spotlightessentials.com ) have this feature available? Can multiple emails be used to access one Spotlight Cloud account? Yes, multiple emails...
    • 15 Dec 2017

    Want faster backup and recovery? Attend our webcast on LiteSpeed for SQL Server

    From my posts about LiteSpeed for SQL Server and juggling cross-platform databases with Foglight® , you guys know how much I dig being a DBA, right? I mean, it’s not like I make much of a secret of it. I was even born with the right initials to be a DBA. It’s the kind of work my parents raised me to do. Who wouldn’t like that? You wanna know one thing I don’t like? Going slow. I like...
    • 7 Dec 2017

    Customer Conversation: Diagnose SQL Server Instances in an Availability Group

    I recently spoke to a user of Spotlight on SQL Server Enterprise who wanted to be able to drill into the individual SQL Server instances that are participating in an Availability Group. The customer had successfully created a connection to the Availability Group listener, but he couldn't figure out how to further diagnose problems that were occurring on a specific member of that group. I love it when customers provide...
    • 4 Dec 2017

    Foglight for SQL Server: Back to Basics - Diagnosing Blocking

    I've done a number of posts recently that touch on Foglight administration, customization, or some of the more advanced capabilities of the product. I felt it was a good time to circle back on some of the more basic use cases that Foglight can help DBA's with. In this series of posts, we'll take a look at some of the more common challenges that DBA's face, and show you how Foglight for SQL Server can help...
    • 4 Dec 2017

    Integrate Foglight by Sending SNMP Traps

    Many customers ask how they might integrate Foglight Alarms into other 3rd party monitoring tools. One way to accomplish this is to send SNMP traps in response to a Foglight alarm. To configure Foglight for this capability, you need to first download the MIB file. ‘MIB’ stands for Management Information Base. The file is a collection of definitions that define the managed object properties. (Note: Port...
    • 30 Nov 2017

    Toad and Foglight in harmony – The PL/SQL Profiler

    My favourite feature in Toad has always been the PL/SQL Profiler. I love the way it can profile your code executions is integrated with the editor. It is such an easy and visual feature to use. So if you have Foglight for Oracle Performance Investiga...
    • 29 Nov 2017

    You're Fired! Wait, What has Fired?

    Foglight has many out of the box rules to evaluate performance and availability conditions for your databases, virtual and physical infrastructure, web pages, network devices, etc. Once it has been running for some time, it's a good idea to evaluate which rules are enabled, and which ones are triggering the most alarms. The first step to see what rules apply to a "device" is to check the Agent Status page...
    • 27 Nov 2017

    Monitor Unix/Linux Servers in Spotlight

    Use Spotlight on SQL Server Enterprise to monitor performance health of Unix/Linux servers that host your SQL Server databases. Spotlight offers: Spotlight can monitor the following operating systems: Red Hat Enterprise 7.3 Ubuntu® 16.04 and 16.10 The required connection parameters are: Server Address, User, Password and Port Number. Our Release Notes document outlines the required user permissions in...