So you've now taken a look at the architectural differences and enhancements between Performance Analysis and Performance Investigator (if you haven't, check them out here). You've also hopefully been wow'ed by the new and enhanced features that…
So you've now taken a look at the architectural differences and enhancements between Performance Analysis and Performance Investigator (if you haven't, check them out here). You've also hopefully been wow'ed by the new and enhanced features that…
When monitoring databases for performance, we certainly want to understand things like CPU spikes, memory pressure, I/O latency, and the like. If we see this type of performance, the next step is to take a closer look and attempt to find out what's causing…
I previously shared a challenge I had with finding the services that were created in the Hosts dashboard. Ideally we want to be able to use them in the Hosts and Infrastructure dashboards, but also add them to the Service Operations Console or attach…
10 years ago, the synergy between application developers/administrators and systems administrators was very simple: dev team is building applications and sysadmins are building servers. Dev team owned application lifecycle, and sysadmins owned hardware…
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 monitori…
The Database Administration Manager communicated his need to efficiently gather and report upon growth data in the QA and Production environments. The project at hand was to build an accurate growth model for 6, 12, and 24 month time windows. He explained…
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…
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…
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…
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 Statistics Repository during the initial installation…
