A fast response means fewer performance issues. Spotlight Cloud’s rapid alert system sends immediate notifications and makes sure you see the most important issues first.
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 Mobile lets you monitor all of your SQL Server connections from your iOS or Android device. Heatmaps, smart alarms, alarm lists, and alarm details allows you to dive into first-level diagnostics from anywhere at any time.
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.
Spotlight Tuning Pack’s SQL Optimizer automatically rewrites your query using different syntax, forcing different indexes, or applying hints. SQL Optimizer then generates and tests new query plans and presents them in the most efficient order.