*Record Scratch*

*Freeze Frame*

Yup, that's me. You're probably wondering how I got into this situation...

I was just minding my own business, trying to configure a SQL Server connection in Spotlight Enterprise, when it starts chirping about…

SQL Server provides us with a number of high availability and disaster recovery solutions. Two of them are Always On Availability Groups and Always On Failover Cluster offerings. In order to leverage these options, they themselves need to be constantly…

When dealing with large number of connections, the power and advantage of PowerShell API can be leveraged to manage, automate, and administer Spotlight configuration. The efficiency gains obtained through command line access to automate configuration…

Auditing an application of its users’ activities can be useful and at times a mandatory task in tightly-secured environments. Spotlight has many robust capabilities such as deleting or disabling connections to changing alarm threshold values or stopping…

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…

The pursuit of historical data and its analysis is a significant part of the functionality that Spotlight on SQL Server users have come to expect and continue to seek improvements upon.  In the past, users have expressed the need for ad-hoc query capability…

Spotlight notifies DBAs of performance issues via triggered alarm messages. More importantly, specific actions can be taken based on these alarms, by configuring the Alarm Actions feature of Spotlight. Read our blog about Alarm Actions configuration …

Spotlight’s vast alarm customization capabilities enables users a wide variety of options.  Setting alarm severity levels, their start and end threshold values, or disabling them completely are just a few. Fortunately, Spotlight performance moni…

System administrators find themselves frequently applying required updates to their server hardware, operating system, security packages, or disaster recovery processes in order to maintain system and data integrity.  Such enterprise modifications occasionally…

Spotlight Cloud is a cloud hosted database monitoring and diagnostics application providing DBAs with diagnostic tools to quickly identify and help resolve performance issues.  The Workload Analyzer of Spotlight Cloud is a very robust query evaluator tool…

We all get excited when our cell phone plan includes so called “Unlimited Data.”  But, you know what happens if we push your luck.  That’s right; we start to experience performance issues and get tossed into the dreaded 2G zone!

A similar…

Spotlight Enterprise 12.4 comes with some neat features you do not want to miss!

Query Execution Plans available when needed the most:

The Workload Analysis and the Query Execution Statistics drilldowns expose the most resource intensive transactions…

Just like most people’s goal towards incorporating more raw food into their daily diet, accessing and manipulating raw data is very much a coveted functionality.

The Spotlight Statistics Repository database is a repository for historical data collected…

Spotlight 13.0 introduces a brand new feature of managing access to monitored connections at the user level. It provides the ability to assign or deny a user access to a set of connections that have been configured to be monitored in Spotlight.

The need…