For the best web experience, please use IE11+, Chrome, Firefox, or Safari

Foglight for SQL Server

Proactively tune your SQL Server databases for more uptime and better performance. With Foglight® for SQL Server, you can quickly diagnose and resolve SQL Server performance problems and optimize your workloads to prevent future issues. This SQL Server tuning tool includes real-time and historical diagnostics, reporting and more, so you can confidently ensure the health of your entire database environment.
Foglight for SQL Server
Foglight for SQL Server ensures the health of your SQL Server infrastructure 01:53

Ensure SQL Server health with real-time diagnostics, SQL Server performance tuning and more

Your SQL Server environment continues to grow and you’re working harder than ever to improve SQL Server performance. But you can’t fix what you can’t see. Once a SQL Server performance problem occurs, you’re already in reactive mode, spending time fixing issues instead of innovating and preventing problems. But what if you had a better SQL Server performance monitor? Switching from subpar SQL Server tuning tools to a more powerful, all-inclusive solution would enable you to proactively manage SQL Server health.

Key benefits

Global view

See critical issues across platforms and take immediate action to improve SQL Server performance.

Built-in intelligence

Understand health and activity at a glance. Get pop-up advice with workflows. Simplify SQL Server performance tuning.

Adaptive baselines

Receive alerts when activity deviates from normal metrics.

Rich historical data

Resolve SQL Server performance issues through diagnostics and alarm data from any drilldown screen.

Drag-and-drop reporting

Use data you have collected to develop customized views and reports.

SQL workload analytics

Investigate workload by drilling into data on users, programs, SQL and sessions.

Historical lock analysis

Resolve concurrency issues with historical reviews of blocking-lock scenarios.

Automated change tracking

See changes to server, instance, database and schema environments and SQL degradations.

Supported platforms

No matter which database platforms you use, Foglight can help you monitor, predict, diagnose and resolve database performance issues quickly. Foglight offers comprehensive support for cloud databases - including: Amazon RDS, Azure SQL DB (single/elastic pools), Azure SQL Managed Instance and more.

Foglight solves common DBA Challenges

68%

MANAGE MULTIPLE PLATFORMS

72%

PERFORMANCE #1 RESPONSIBILITY

75%

IMPROVED RESOLUTION TIME

Features

Comparison reporting

Identify the root cause of a performance deviation in your application environment.

Wait-event analysis

View wait-event data at the statement level to resolve resource-related performance problems.

Automatic instance discovery

Rapidly deploy through automated discovery of instances and specific hosts.

Alarm workflow

Search for past solutions, set up blackouts and manage your alarms.

Easy integration

Integrate your other end-to-end enterprise monitors seamlessly.

Wait-state analysis

Determine the location and cause of waits by diagnosing your wait statistics.

Wizard-driven installation

You can easily add database monitoring to your infrastructure or configure as a standalone solution.

Powerful performance investigation

Proactively optimize performance with an analytics engine that collects and investigates data on baselines, lock analysis and change tracking.

Tour

Overview
SQL-PI: top SQL
I/O Analysis
Change Tracking
Compare
Tempdb
Plan Analysis
VMware ESX metrics
Easily manage multiple databases
View the complete Instance health status in a single view.

Overview

View the complete Instance health status in a single view.
Investigate workload by drilling into top SQL then go deeper into data.

SQL-PI: top SQL

Investigate workload by drilling into top SQL then go deeper into data.
Examine top objects, files and disks I/O statistics and wait-events.

I/O Analysis

Examine top objects, files and disks I/O statistics and wait-events.
Track Changes and correlate them with the workload.

Change Tracking

Track Changes and correlate them with the workload.
Compare configuration and performance statistic.

Compare

Compare configuration and performance statistic.
Diagnose TempDB database usage and contention.

Tempdb

Diagnose TempDB database usage and contention.
View, analyze and compare execution plans for SQL statements.

Plan Analysis

View, analyze and compare execution plans for SQL statements.
View data on your virtual environment and storage to resolve issues.

VMware ESX metrics

View data on your virtual environment and storage to resolve issues.
In this video you can see how to manage multiple database platforms and consolidate information into a single console with Foglight for Databases. 02:04

Easily manage multiple databases

Watch this video to see how to manage multiple database platforms and consolidate information into a single console with Foglight for SQL Server.

Specification

Specifications

    Both on-premises and cloud deployments - including:

    • Amazon:
      • IaaS -EC2 - *Windows and Linux
      • SQL Server RDS
    • Azure
      • IaaS - *Windows and Linux
      • Azure SQL Managed Instance
      • Azure SQL DB (Single/elastic pools)
  • All Operating systems supported by Microsoft.

Resources

Video

Foglight for SQL Server Overview

Gain complete visibility into your SQL Server environment with Foglight for SQL Server.
Technical Brief

Accelerate Database Efficiency with SQL Performance Investigator

Solve performance issues faster with deep SQL workload visibility and lock analytics
E-book

A Zombie's Survival Guide in a Changing Database World

With the rise of autonomous databases – and all the other scary changes in database management systems – you, as a DBA may be wondering whether you’re in the midst of a DBApocolypse. You are. And this is your definitive survival guide.
White Paper

DBA vs. Memory Settings

SQL Server memory pressure: What is it and how does it affect SQL Server?
Technical Brief

The Importance of Continuous Monitoring in a DevOps Pipeline

A common challenge in many IT teams is the “blame game” where developers blame DBAs for stability and performance issues and vice versa. What if you had complete visibility and continuous monitoring to understand the root cause of database issues?
Technical Brief

Managing Cross-Platform Database Environments

This technical brief outlines the top five complications faced by DBAs amid the rush of new database technologies in recent years. For each challenge it provides background, context and the benefits Foglight for Databases brings in addressing them.
White Paper

DBAs Face New Challenges: Trends in Database Administration

To gain insight into the evolving challenges for DBAs, Quest commissioned DBTA to survey DBAs and those responsible for the management of the corporate data management infrastructure. The results are in and the thought-provoking findings are now available
Case Study

Global IT Company Makes Logistics System More Efficient with Foglight

Learn how a global IT company gained better visibility into performance issues and improved database responsiveness with Foglight for Databases.

Get Started

Gain deep visibility into the health of all your database environments.

Logos

Quest Clients Logos
Quest Clients Logos
Quest Clients Logos
Quest Clients Logos
Quest Clients Logos
Quest Clients Logos

Support and services

Product Support

Self-service tools will help you to install, configure and troubleshoot your product.

Support Offerings

Find the right level of support to accommodate the unique needs of your organization.

Professional Services

Search from a wide range of available service offerings delivered onsite or remote to best suit your needs.

Education Services

Training courses delivered through online web-based, on-site or virtual instructor-led.