Database Management

SQL Sentry Azure Synapse SQL Pool Overview

The purpose of this internal article is to explain the limitations of Azure Synapse target(s) and their Dedicated Pools that are supported and Serverless Pools that are not supported. It is important to clarify this when assisting a customer in adding this type of target. Support for this type of target was implemented in versions 2022.4 and above for SQL Sentry.

First published date

1/10/2023 10:57 PM

Last published date

12/10/2025 12:29 AM

Overview

Overview between Dedicated SQL pool vs. serverless SQL

Dedicated SQL pool
The SQL pool was known as Azure SQL Data Warehouse, before becoming a part of Synapse. When using Synapse SQL, a dedicated pool presents several provisioned analytical resources. A dedicated SQL is a big data solution that provides data storage in a relational table with columnar storage, and it improves query performance and limits the storage cost. A dedicated SQL server is measured in data warehousing units (DWU). After the data is stored in the dedicated SQL pool, users can utilize it for analytics on a large scale.

Serverless SQL pool
A serverless SQL pool stores and computes large-scale data in a distributing data processing system. The Azure serverless SQL pool doesn’t mandate users to set up infrastructure and maintain clusters. Instead, it uses a pay-per-use model, which means there is no cost incurred for resources not used, and the charge made is based on the data processed by each query run.

Here are some additional 3rd party articles along with some SWI help documentation assisting a customer in adding this type of target below:

SQL Sentry Azure Synapse SQL Pool Overview

Dedicated SQL Pool vs. Serverless SQL—Comparison and Uses

Product section

SQL Sentry (SQLS)

Cause

Only Dedicated Pools are Supported with SQL Sentry, not Serverless.

Resolution

If experiencing an issue with Azure Synapse Target, it is best to first verify if there is a Dedicated SQL pool or serverless SQL as only Dedicated Pool is supported with SQL Sentry.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.