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 quickly. Email and mobile app notifications along with…
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 quickly. Email and mobile app notifications along with…
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 select a connection and then apply your configuration…
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 through typical maintenance efforts such…
One of the lesser known features of Foglight the ability to monitor log files. One of our customers has a process that collects and prints documentation required for truck movement. Before a truck can leave the loading dock, the dispatcher requests a…
As we continue our navigation of Spotlight on SQL Server Enterprise and we can diagnose an alarm that triggers. Let us see what setting caused an alarm to trigger. The fact is when you start monitoring an Instance it is assigned the preset “Factory Settings…
Just the facts! Part 2
Acknowledging Alarms in Spotlight on SQL Server Enterprise
Now that we have establish a view of the facts let’s see what we can do with them. Some on these alarms are set by default to be acknowledged before they will clear for…
The original “Just the Facts” blog I discussed how to see just the Alarms displayed in “Spotlight Today” within Spotlight on SQL Server Enterprise. Now it is time to see what we can do with those Facts or Alarms. Spotlight comes with factory settings…
You will see that our quest for a fully web-enabled client is full steam ahead! We just released Stat 5.8.1. This is a maintenance release that previews some cool new features and fine tuning of the infrastructure that will be a part of the upcoming Stat…
User-Defined Collections enable you to tell Foglight for SQL Server to go beyond the data points it collects out-of-the-box to also collect the results of queries that you define. So in addition to the vast amount of commonly-needed metrics that Foglight…
One of the pitfalls of creating custom rules for Foglight is failure to take into account assumptions being made when crafting a custom rule. As a result this can cause unexpected results when different assumptions are made, for example when the individual…