Sign in

Spotlight Cloud

SQL Server Performance Tuning Overview
product-preview

Respond Instantly

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.

Features

Respond Instantly

Reduce Resolution Time

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.

Features

Reduce Resolution Time

Root Cause Analysis

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.

Features

Root Cause Analysis

Full-Stack Monitoring

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.

Features

Full-stack monitoring

World-Class Database Performance Monitoring

It’s never been easier or more efficient to monitor SQL Server performance.

Learn More

Prevent Downtime

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.

Features

Prevent Downtime

Monitor Via Mobile

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.

Features

Monitor via Mobile

The No-Software Advantage

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.

The No-Software Advantage

Low-Cost, Low-Maintenance

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.

Features

Low Cost, Low Maintenance

Plan Visualization

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.

Features

Plan Visualization

Plan Analysis

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.

Plan Analysis

SQL Optimization

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.

Features

SQL Optimization

Want to know more? Get in touch!

Learn More