How to monitor Azure Synapse Analytics concurrency slots in your Azure Synapse Analytics SQL Pools. Azure Synapse Analytics Queries #8
Azure Synapse Analytics Queries #7 Monitor Table Size
In this post, you’ll learn the queries you need to monitor table size. This information will help you understand if the table type and distribution are still suitable for your table (example: Replicated, Round-robin, Hash-distributed).
Azure Synapse Analytics Queries #6 Monitor Data Skew
In this post, you’ll learn how to monitor data skew in your Azure Synapse Analytics SQL Pool. Data skew is the uneven distribution of data.
Azure Synapse Analytics Queries #5 Product Version
Azure Synapse Analytics queries: How you can find the product version of your Azure Synapse Analytics Dedicated SQL Pool.
Azure Synapse Analytics Queries #4 Roles and Users
A quick guide to Azure Synapse Analytics roles and users. This query will help you list all the database roles and users in your ASA SQL Pool.
Azure Synapse Analytics Queries #3 Last Operations in Server
A quick guide to Azure Synapse Analytics queries about last operations in server. Learn how to get the latest transactions and progress.
Azure Synapse Analytics Queries #2 Replicated Tables
A quick start guide to Azure Synapse Analytics queries about replicated tables. They play a role in Azure Synapse Analytics SQL Pools
Azure Synapse Analytics Queries #1 Current Data Warehouse Units
If you are looking to query the current allocation of data warehouse units (DWU) for your Azure Synapse Analytics SQL Pools,