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…

I'm very happy to report that a new release of Spotlight on SQL Server Enterprise (version 11.7) is now available.  This is a relatively minor release, mostly including fixes, although there are two enhancements worth mentioning.  One that has been…

Whether it’s hitting sys.dm_io_virtual_file_stats DMV with calculated queries, collecting Perfmon Disk Counter statistics, reviewing Resource Monitor Disk information, or keeping your storage admin close by, I/O issues are all too familiar a concern.…

While it’s no secret that cloud technologies are rapidly changing the way that organizations are running their IT infrastructures, for many organizations that I speak with, databases (and data in general) seem to be the slowest to move.  There are…

A wealth of knowledge on SQL Server Wait Types awaits you in our Waitopedia site. Our in-depth information on SQL Server wait types gives you the upper hand when SQL Server performance is hindered due to one of these wait types.  Wait statistics can point…

Here is an annoying issue that hopefully will never happen to you.

For the most part, there is just one service account to run the Diagnostic Server; however, some users may decide, "Hey, I'm  going to monitor one or two connections with my own…

 If you've been noticing that you're not getting deadlock email alerts from Spotlight on SQL Server Enterprise even though alarms are popping up in Spotlight itself, then this workaround might be for you.

Before you move on though, I am assuming…