• 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

    A Wait-Free Introduction to Spotlight on SQL Server's Wait Events and Workload Analysis Views

    I once attended an excellent training on giving effective software demonstrations, and the main point was simple: Don’t make your audience wait - show them the good stuff FIRST! So here it is, in just three steps in Spotlight on SQL Server Enterprise ‘s Wait Events drilldown, you can find out what your heaviest queries were, for any recent time range: This really “turns on the lights” in...
    • 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 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 Updates New Releases Foglight...
    • 5 Dec 2016

    Quest Customer Story: Time Savings Realized by Large Hospital in South Florida Using Spotlight on SQL Server Enterprise

    In April of 2016, upon engaging with a customer, we learned that the DBA team for the hospital managed an environment of over 70 SQLServer instances and had trouble keeping up with the ‘fires’ and reacting, as end-users reported performance issues. After a Spotlight ‘Lunch and Learn’ session, the team eagerly agreed to re-discover the Spotlight solution and start using it. A couple of Q & A...
    • 5 Dec 2016

    Minimize SAP ERP Migration Downtime with SharePlex

    Now that SAP has announced that the latest release of their ERP Software (S4) will support only their Hana database, customers are facing time-consuming data migrations to move their data from Oracle to Hana. SharePlex can help While there are many s...
    • 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...
    • 3 Dec 2016

    Importance of Securing All Software Vulnerabilities

    Technology advances at a seemingly exponential rate. With these advances in everything from operating systems to applications to Internet of Things, software vulnerabilities also increase. We are constantly introducing more and more electronic devices with more and more vulnerabilities into our daily lives: both at home and in the office. While many systems are running some form of AntiVirus software, malware still impacts...
    • 2 Dec 2016

    Troubleshooting Scheduled Automation Scripts in Toad Data Point

    Automation simplifies life – until that script fails to run. All these processes are stuck in the “log jam”, with the problem waiting to be determined and cleared. In this blog, the following tips and procedures will assist one in troubleshooting Automation Script problems when a script does not run when scheduled. In this blog installment, the following troubleshooting techniques are covered: ...
    • 2 Dec 2016

    Monitoring Raspberry Pi with Foglight - Part 1

    In a prior post, we looked at installing Raspberry Pi (version 3) as a host to run the Foglight Agent Manager. Since we don't yet have an installer compiled for the ARM processor, it wasn't a very long post! But, wait! Can Foglight do anything to monitor the Raspberry Pi, or is that a dead end too? The TL;DR version is that yes, Foglight can monitor the Raspberry Pi just like any other host. I started by...
    • 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...
    • 1 Dec 2016

    How is Your Parking? Foglight can Help.

    Have you ever looked at Resource Monitor in Windows and wondered why some of your cpu cores were "parked"? That sure doesn't sound good! This post does a good job at explaining the details. Needless to say I was intrigued, and I wanted to find out if Windows does a good job at managing core parking, or if manual intervention might be better. I downloaded the Passmark Performance Test utility (free...