Getting the Maximum Out of SQL Server Engine

Products
Spotlight Product Family

Making it simple to monitor on premise or cloud based SQL servers and tune your SQL

Solutions

Learn how to solve the problems you face each day in your SQL Server Environment.

Resources

Find all the information you need in our documentation, from our community, or learning center.
- Overview
- Spotlight Cloud
- Spotlight Tuning Pack
Solutions
Spotlight Product Family

Making it simple to monitor on premise or cloud based SQL servers and tune your SQL

Solutions

Learn how to solve the problems you face each day in your SQL Server Environment.

Resources

Find all the information you need in our documentation, from our community, or learning center.
- Monitoring & Diagnostics
- SQL Tuning & Plan Analysis
Features
Resources
Spotlight Product Family

Making it simple to monitor on premise or cloud based SQL servers and tune your SQL

Solutions

Learn how to solve the problems you face each day in your SQL Server Environment.

Resources

Find all the information you need in our documentation, from our community, or learning center.
- Documentation
- Support
  - Spotlight Cloud Support
- Learning Center
- Community
  - Collective IQ - SQL Server Demographics
  - Waitopedia - SQL Server wait type guide
Blog

The Secret to Getting the Maximum Out of SQL Server Engine

Featuring Guest Speaker - Pinal Dave

Most DBAs understand how indexes work and how to write efficient queries. However, the secret to efficient indexes and queries are actually hidden in behind-the-scene configurations. When these essential configurations are not set correctly, database application performance goes downhill. SQL Server Optimizer Engine produces many different possibilities and helps build an optimal execution plan for any query.