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

Foglight for Azure SQL

For better Azure SQL performance, proactively tune your Azure SQL databases (Single DB and Elastic Pool databases). With Foglight Performance Investigator for Azure SQL Databases, you can quickly diagnose and resolve Azure SQL performance problems and optimize your workloads. When you are moving to cloud databases, there are enough challenges without needing to deal with repeating performance problems. Find the root cause of Azure SQL Database issues so you can take the necessary action to eliminate the problem.
Foglight for Azure SQL
Foglight for SQL Server ensures the health of your SQL Server infrastructure 01:53

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

Your Azure SQL environment continues to grow and you’re working harder than ever to improve Azure SQL performance. But you can’t fix what you can’t see. Once an Azure SQL 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 Azure SQL performance management tool with built-in tools to help you be more proactive and find causes of problems faster?

Foglight supports monitoring Azure SQL Managed Instances, Single Databases, and Elastic Pools, and the databases in each pool, so that performance or availability issues due to resource consumption or workload volumes anywhere in your Azure SQL do not go undetected. If problems do arise, the information available in Foglight will help lead your team to a resolution as quickly as possible so repeating problems can be mitigated.

Azure SQL Managed Instances are monitored by Foglight for SQL Server, and the optional Performance Investigator for SQL Server provides deep workload analytic tools that further assist database managers and application teams in locating root causes of issues and suggest recommended remediation.

Azure SQL Elastic Pools and Elastic Pool Databases, as well as Single Databases, are monitored by Foglight for Azure SQL.  Again, the optional Performance Investigator can assist in analyzing the workloads running on each of those environments where it is deemed helpful.

User Level Access provides a layer of security and convenience by indicating for specific users or groups which Azure SQL connections, database and Elastic Pools they should be able to view within Foglight.

So, wherever performance or availability issues arise in your Azure SQL environments, Foglight can help you detect those problems quickly, and diagnose the cause so the appropriate action can be taken.

Key benefits

Global view

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

Built-in intelligence

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

Adaptive baselines

Receive alerts when activity deviates from normal metrics.

Rich historical data

Resolve Azure SQL 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.

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

Wait-event analysis

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

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 information about locking and offensive SQL.

Customer Stories

View All

CommitDBA

Without Foglight, we wouldn’t be able to meet our SLAs at all. With Foglight, we meet well over 99.5% of our SLAs.

Bailey Glenn Foglight Administrator, CommitDBA Read Case Study

Envision Healthcare

Foglight both monitors our databases and offers us a deep dive into them for real business intelligence

Darrick Webster Database Administrator, Envision Healthcare Read Case Study

Tour

Overview
Top SQL
Easily manage multiple databases
IO Analysis
Blocking Analysis
Overview

Overview

View the complete instance health status in a single view.

Specification

    Both on-premises and cloud deployments - including:

    • Azure
      • Azure SQL DB (Single/elastic pools)
  • All Operating systems supported by Microsoft.

Get Started

Gain deep visibility into the health of all your database environments.
American Express
Bank of America
Chevron
Farmers Insurance
Intel
Toyota

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.