Sign in

Spotlight Cloud and Spotlight Tuning Pack

Spotlight Cloud is a database performance monitoring tool that leverages cloud computing to provide 24/7 monitoring and instant diagnostics. Spotlight Tuning Pack provides powerful SQL optimization and query plan analysis within SQL Server Management Studio to ensure consistent performance and high availability.

These no-software, low-cost/low-maintenance SQL Server performance monitoring, diagnostic, and tuning solutions allow you to respond instantly to SQL Server issues and pinpoint and fix the highest priority issues with ease.

Spotlight Cloud Basic

Spotlight Cloud Basic

Perfect for lightweight monitoring of up to five SQL Server and host OS connections. Spotlight Cloud Basic offers performance-focused monitoring 24/7 operational monitoring and real-time monitoring on your iOS or Android device.

All Basic plans come with a 30-day trial of Spotlight Cloud Pro.

Learn More
Spotlight Cloud Pro

Spotlight Cloud Pro

Spotlight Cloud’s Professional solution locates pain points in your SQL Server environment and helps you fix them. Spotlight Cloud Pro includes all the features in the Basic plan, and even more features, including: no connection cap, multidimensional workload analysis, alarm root cause analysis, blocking analysis, smart alarms, and up to 12 months of historical data.

Learn More
Spotlight Tuning Pack Basic

Spotlight Tuning Pack Basic

Spotlight Tuning Pack Basic analyzes your execution plans and provides advice and scripts to make your plans more efficient. Features include: query plan analysis to detect issues and offer potential solutions to correct them, query history panel for tracking changes to your SQL, and query plan visualization, which zooms in on operations that are causing inefficiencies.  

Learn More
Spotlight Tuning Pack Pro

Spotlight Tuning Pack Pro

Spotlight Tuning Pack Pro provides powerful SQL optimization and query plan analysis within SQL Server Management Studio. Get all the features of the Basic plan plus automated SQL tuning, unlimited rewrites, SQL execution statistics, optimization history, and much more.

Learn More
Spotlight-Customize-Alarms-header-V2

Spotlight Cloud Key Features

Maintain the health and performance of your SQL Server environment with proactive monitoring and smart alarm technology

  • Health Checks: Spotlight Cloud lets you hone in on key system health issues within your SQL Server infrastructure. You can also pinpoint and correct issues affecting security, configuration, memory, disaster recovery, and I/O, or choose to ignore issues that frequently show as false positives.
  • Smart Alarms: Spotlight Cloud’s smart alarms not only tell you there is a problem, they also tell you how, when, and where to fix it. By providing the alarm details, what was happening immediately before and after the alarm, and possible causes, this feature allows you to begin diagnosing and fixing the issue immediately.
  • Mobile Monitoring: Spotlight Cloud offers a completely native mobile application that allows you to receive smart alarms and get started troubleshooting from anywhere at any time.

With its rapid, customizable alerting, visibility into issue priority and resolutions, and the flexibility of a cloud-based, mobile-friendly environment, Spotlight Cloud helps you maintain high-availability, high-performance databases and quickly resolve issues.

Learn More

Spotlight-Tuning-Update-blog-header

Spotlight Tuning Pack Key Features

Analyze SQL query plans and tune the SQL statement from within SQL Server Management Studio

  • Plan Visualization: Spotlight Tuning Pack lets you execute your scripts and then view the query plans from within SQL Server Management Studio. To maximize efficiency and reduce noise, only the important parts of the query plan are shown initially, with the highest cost operators highlighted. You can then click on each operator for more details, expand or collapse any branches, and navigate around the query plan.
  • Plan Analysis: Spotlight Tuning Pack helps you navigate the underlying factors that are affecting execution time. The AI engine automatically checks all possible considerations for every query, then offers explanations and suggestions for fixing issues and executing the operations more efficiently.
  • Automated SQL Optimization: Spotlight Tuning Pack shortens the execution time of your procedures or reports and improves the performance of your SQL instance by reducing the workload of your most inefficient queries. It analyzes your SQL and then automatically rewrites it until it finds the variation that produces the best execution time.

Spotlight Tuning Pack refines and improves your query plan using visualization, AI-driven analysis, and automated optimization, all within SQL Server Management Studio.

Learn More

"Half the problem is sometimes I don’t even know what I should be looking for. So, the diagnostic server actually solved that for me because I had all these pre-configured alerts that would monitor things and show them on my dashboard."

Daniel B. - Lead Software Engineer, Corelogix

Contact Sales