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…

A Picture is worth a thousand words!

Execution plans can help us identify the performance hog sections of SQL code that impact CPU usage and I/O operations.  Addressing these bottlenecks can ultimately help us achieve the best execution times.  What if…

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…