• 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

    Execute queries on multiple SQL Server Instances

    Back in my SQL Server DBA days, I worked for an Application Service Provider (ASP) which would now be called Software as a Service (SaaS). I recall during application upgrades I often had to run a few thousand line script in each of our client's databases. Now this would be fine if it were only 5-10 client databases but we had anywhere from 75-100 at any given time. At that time we had to use native tools so I would...
    • 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 terms...
    • 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...