Table: azure_mssql_elasticpool - Query Azure SQL Database Elastic Pools using SQL

Azure SQL Database Elastic Pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. They provide a resource model that allows databases to use resources as needed, within certain limits, while also providing a level of isolation from other databases. Azure SQL Database Elastic Pools are particularly useful for SaaS providers who need to manage and scale multiple databases with varying and unpredictable usage.

Table Usage Guide

The azure_mssql_elasticpool table provides insights into Azure SQL Database Elastic Pools within Azure. As a database administrator or DevOps engineer, explore details about each elastic pool, including its configuration, performance metrics, and usage statistics. Utilize it to understand the resource usage and performance of your elastic pools, and to identify potential areas for optimization or scaling.

Examples

Basic info

Explore which Microsoft SQL Server elastic pools in your Azure environment are zone redundant and their current state to manage resource allocation effectively. This query is useful for assessing the distribution of Database Transaction Units (DTUs) across your environment.

select
  name,
  id,
  state,
  dtu,
  zone_redundant
from
  azure_mssql_elasticpool;

select
  name,
  id,
  state,
  dtu,
  zone_redundant
from
  azure_mssql_elasticpool;

List zone redundant elastic pools

Explore which elastic pools in Azure SQL are zone redundant. This query is useful for understanding the distribution and resilience of your database resources across different zones.

select
  name,
  id,
  state,
  dtu,
  zone_redundant
from
  azure_mssql_elasticpool
where
  zone_redundant;

select
  name,
  id,
  state,
  dtu,
  zone_redundant
from
  azure_mssql_elasticpool
where
  zone_redundant = 1;

Schema for azure_mssql_elasticpool

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
cloud_environment	text		The Azure Cloud Environment.
creation_date	timestamp with time zone		The creation date of the elastic pool.
database_dtu_max	bigint		The maximum DTU any one database can consume.
database_dtu_min	bigint		The minimum DTU all databases are guaranteed.
dtu	bigint		The total shared DTU for the database elastic pool.
edition	text		The edition of the elastic pool.
id	text		Contains ID to identify a elastic pool uniquely.
kind	text		The kind of elastic pool.
name	text	=	The friendly name that identifies the elastic pool.
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
server_name	text	=	The name of the parent server of the elastic pool.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
state	text		The state of the elastic pool.
storage_mb	bigint		Storage limit for the database elastic pool in MB.
subscription_id	text	=, !=, ~~, ~~, !~~, !~~	The Azure Subscription ID in which the resource is located.
tags	jsonb		A map of tags for the resource.
title	text		Title of the resource.
type	text		The resource type of the elastic pool.
zone_redundant	boolean		Whether or not this database elastic pool is zone redundant, which means the replicas of this database will be spread across multiple availability zones.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- azure

You can pass the configuration to the command with the --config argument:

steampipe_export_azure --config '<your_config>' azure_mssql_elasticpool