steampipe plugin install azure

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
creation_datetimestamp with time zoneThe creation date of the elastic pool.
database_dtu_maxbigintThe maximum DTU any one database can consume.
database_dtu_minbigintThe minimum DTU all databases are guaranteed.
dtubigintThe total shared DTU for the database elastic pool.
editiontextThe edition of the elastic pool.
idtextContains ID to identify a elastic pool uniquely.
kindtextThe kind of elastic pool.
nametext=The friendly name that identifies the elastic pool.
regiontextThe Azure region/location in which the resource is located.
resource_grouptext=The resource group which holds this resource.
server_nametext=The name of the parent server of the elastic pool.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statetextThe state of the elastic pool.
storage_mbbigintStorage limit for the database elastic pool in MB.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextThe resource type of the elastic pool.
zone_redundantbooleanWhether 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