*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...
For environments that have lots of instances to be monitored, registering each of them one by one can be a bit time-consuming. A time-saving alternative is to import your instance list from a file. S...
While your database handles requests from end-users, it starts to consume various resources. With increased number of requests, the database may suffer from resource waits. Excessive wait types and ti...
Spotlight reports are designed in SQL Server Report Definition files (RDL) and stored in the local installation folder of Spotlight client application making them accessible to Spotlight users. By def...
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 thr...
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 b...
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 da...
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 drilldow...
We’re excited to announce that with Spotlight version 12.3, the Plan Visualizer feature now includes several new enhancements. In my last blog, I covered the Plan Visualizer feature included in versio...
In a previous post, I explained how to customize alarms in Spotlight on SQL Server Enterprise. Recently, I had a customer inquire how he could refine the "Days Since Last Full Backup" alarm. He wanted...
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 ultimatel...
Tweaking performance monitoring to work exactly the way you want Spotlight on SQL Server comes ready out-of-the-box to help you navigate your SQL Servers’ performance metrics in real-time. The settin...
