This short video reviews Spotlight's Scheduling and Alarm Templates. (7:22)
This short video reviews Spotlight's Workload and Wait State Analysis dashboards. (4:53)
Are you looking for a laser-focused monitoring and diagnostics solution for SQLServer?
If so, you're in the right place!
This short video reviews Spotlight's architecture and requirements. (2:59)
Installation is simple and takes only a few minutes…
Quest is very excited to announce the General Availability of Spotlight on SQL Server Enterprise v13.3.
Spotlight on SQL Server Enterprise v13.3 is focused on a major aspect of SQL Server tuning - analyzing execution plans.
An execution plan…
Quest Software is excited to announce our extended Spotlight® Cloud offering which will deliver deep performance diagnostics to both on-premises and cloud SQL Server environments from a single, innovative SaaS platform.
Two years ago, we…
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…
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 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…
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…
Imagine this.... you're hosting a Holiday Party...and the phone rings. You answer and the person on the other end says with a tense voice, "I'm sorry but we will be unable to deliver your beer, wine, and liquor order. The product never shipped."…
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…
In Part 1 of this blog post, I review how you can get an evaluation copy and explain the various integration points from Quest’s monitoring solutions – Foglight and Spotlight Enterprise. You can find it here -> https://www.quest.com/community…
One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are:
So, you’ve downloaded and installed an evaluation of Spotlight Enterprise. Good news…it comes with a 30-day evaluation license key! Spotlight is fully functional (not limited trial functionality). It simply expires after the 30 days. There are a couple…
In an earlier blog, I wrote about a company’s success with Quest’s flagship SQL Server monitoring and diagnostics solution – Spotlight Enterprise. The blog detailed a customer success story and revealed detailed use cases explaining how this application…
I often get asked about monitoring SQL workload that is consuming a database instance’s resources. The first question that comes to my mind is, “What is the symptom you are trying to resolve?” Are you looking to understand the root cause of compute resource…
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 …
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…
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 want to address a specific issue in Spotlight, SQL Server performance monitoring tool, with filtering out blocking alert but the principal can be applied to other alarms. The scenario is that you only want to get email alerts for one specific database…
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…
