Locate the source of the highest-impact issue with at-a-glance alarm severity identification, so you can triage the most important problems first. Smart alarms help you locate blocked sessions and offers suggestions for how to unblock them.
With just a few clicks, Spotlight Cloud’s Workload Analyzer identifies the issues with the highest impact on your workload. The TempDB Usage Dashboard lets you proactively manage your TempDB by drilling down into usage and contention, as well as identifying and recommending solutions for resolving current issues. The Plan Advisory and Plan Viewer help you navigate the query plan and offer suggestions for how to fix performance issues.
Avoid performance issues at the OS level with Spotlight Cloud’s easy-to-understand OS Monitoring Dashboard. The Hyper-V and VMware dashboards keep you up to date on the status of all virtual machines hosting SQL Server instances.
Implement health checks for security, disaster recovery, index optimization, memory, I/O, and configuration. Get insight into the performance of each of your instances, including recent history of the instance’s performance, system waits, and I/O latency. See how your performance is trending over time and compare one instance with another.
Spotlight Cloud’s fully cloud-based model means no more software updates. You will have immediate access to the latest version and new features each time you log in.
A no-hardware, subscription-based SaaS solution, Spotlight Cloud offers a full browser front end and apps for mobile device monitoring. The zero-hassle setup lets you get up and running in minutes to leverage the power of cloud computing to store your data history longer and go deeper into analytics.
Easily execute your scripts, then view the SQL query plans from within SQL Server Management Studio. Spotlight Tuning’s Plan Visualization shows only the most important parts of the query plan initially, highlighting the highest-cost operators. Click on an operator to get more details, expand or collapse branches, and navigate around the query plan.
Spotlight Tuning’s Plan Analysis uses artificial intelligence to analyze your execution plan and determine how to change it so the SQL Server executes the operations more efficiently. Plan Analysis checks all possibilities for every query, then offers explanations and possible fixes for any issues.