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…
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 times may lead to performance latencies and degradation…
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…
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…
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…
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…
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…
I normally write about specific aspects of the solutions that I support, but I thought I'd try something a little different today. For those of you that don't know, I'm a sales engineer supporting Quest's Database Performance Monitorin…
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:
Naturally, it's VERY important to know when things are going wrong with our monitored instances. What's not helpful is the dreaded "False Positive." You know the scenario I'm about to describe. It's 03:00 and you're sleeping soundly and dreaming of the…
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…
I recently spoke to a user of Spotlight on SQL Server Enterprise who wanted to be able to drill into the individual SQL Server instances that are participating in an Availability Group. The customer had successfully created a connection to the Availability…
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…
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…
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’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…
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 on SQL Server provides excellent real-time monitoring, workload analytics and more for SQL Server. You can download the complete software for a 30-day trail on as many systems as you'd like. A previous post walked through the installation
…It never gets old hearing about how Quest Performance Monitoring solutions offer actionable insight to mission-critical systems. Upon visiting a customer for a 'health check' of their environment, we had the pleasure of learning about two distinct ways…
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…