*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…
*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…
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 default this path in Spotlight is C:\Program Files (x86…
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…
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…
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 version 12.0 which provides a display view of the estimated…
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…