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 rea...
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 thi...
I'm surprised by the number of people that aren't aware that our Spotlight Performance Monitoring tool provides a tremendous number of reports. I suspect this is because we do not create the Spotlight...
Spotlight on SQL Server Enterprise‘s main purpose in life is to inform you of SQL Server performance problems, and then give you a quick way to diagnose their root causes so you can take action quickl...
Configuring alarms in Spotlight on SQL Server Enteprise is quite easy. Configuring alarms across multiple connections, however, wasn’t always so easy. In versions prior to 11.5, you were required to s...
Differential backups make perfect sense….backup only what has changed since the last Full backup. Differential backups dramatically reduce the storage needed to maintain backups, while lowering mainte...
Summary This is one of those special Enterprise Monitoring use cases that I mentioned in my last blog post; The Not So Obvious Enterprise System Monitoring Essentials. While this is not the only way ...
A customer would like to forward alarms from Foglight with all the appropriate information, such as alarm time, source, severity, message, and the rule name, to a pager script which in turn pages the ...
Foglight can now monitor the MS SQLServer BI stack – SSIS, SSAS, and SSRS. Foglight supports monitoring SSIS for MS SQLServer 2012 and above. For this SSIS monitoring, Foglight needs to access the SSI...
In my last post, I covered the four stages of capacity management, and talked about some of the reasons why managing your virtual capacity is equally as important as physical capacity management. Now...
Can Foglight run on a Raspberry Pi running Linux? This blog answers the question. Interestingly, I've been asked more than once recently if the Foglight Agent Manager can be installed on a Raspberry ...
As the old saying goes, “the one constant in life is change”, and this is especially true in database environments. There are many reasons why database environments experience change whether it be th...
