Table of Contents

Class AzureSQLDatabaseSchema.ElasticPoolResourceStat

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.elastic_pool_resource_stats (Azure SQL Database)

Applies to: √ Azure SQL Database √ Azure SQL Managed Instance

Returns resource usage statistics for all the elastic pools in a SQL Database server. For each elastic pool, there is one row for each 15 second reporting window (four rows per minute). This includes CPU, IO, Log, storage consumption and concurrent request/session utilization by all databases in the pool. This data is retained for 14 days.
||
|-|
|Applies to: SQL Database V12.|


See sys.elastic_pool_resource_stats.

[Table(Schema = "sys", Name = "elastic_pool_resource_stats", IsView = true)]
public class AzureSQLDatabaseSchema.ElasticPoolResourceStat
Inheritance
AzureSQLDatabaseSchema.ElasticPoolResourceStat
Extension Methods

Properties

AvgAllocatedStoragePercent

The percentage of data space allocated by all databases in the elastic pool. This is the ratio of data space allocated to data max size for the elastic pool. For more information see: File space management in SQL Database

[Column("avg_allocated_storage_percent")]
[NotNull]
public object AvgAllocatedStoragePercent { get; set; }

Property Value

object

AvgCpuPercent

Average compute utilization in percentage of the limit of the pool.

[Column("avg_cpu_percent")]
[NotNull]
public object AvgCpuPercent { get; set; }

Property Value

object

AvgDataIoPercent

Average I/O utilization in percentage based on the limit of the pool.

[Column("avg_data_io_percent")]
[NotNull]
public object AvgDataIoPercent { get; set; }

Property Value

object

AvgLogWritePercent

Average write resource utilization in percentage of the limit of the pool.

[Column("avg_log_write_percent")]
[NotNull]
public object AvgLogWritePercent { get; set; }

Property Value

object

AvgStoragePercent

Average storage utilization in percentage of the storage limit of the pool.

[Column("avg_storage_percent")]
[NotNull]
public object AvgStoragePercent { get; set; }

Property Value

object

ElasticPoolDTULimit

Current max elastic pool DTU setting for this elastic pool during this interval.

[Column("elastic_pool_dtu_limit")]
[NotNull]
public int ElasticPoolDTULimit { get; set; }

Property Value

int

ElasticPoolName

Name of the elastic database pool.

[Column("elastic_pool_name")]
[NotNull]
public string ElasticPoolName { get; set; }

Property Value

string

ElasticPoolStorageLimitMB

Current max elastic pool storage limit setting for this elastic pool in megabytes during this interval.

[Column("elastic_pool_storage_limit_mb")]
[NotNull]
public long ElasticPoolStorageLimitMB { get; set; }

Property Value

long

EndTime

UTC time indicating the end of the 15 second reporting interval.

[Column("end_time")]
[NotNull]
public DateTime EndTime { get; set; }

Property Value

DateTime

MaxSessionPercent

Maximum concurrent sessions in percentage based on the limit of the pool.

[Column("max_session_percent")]
[NotNull]
public object MaxSessionPercent { get; set; }

Property Value

object

MaxWorkerPercent

Maximum concurrent workers (requests) in percentage based on the limit of the pool.

[Column("max_worker_percent")]
[NotNull]
public object MaxWorkerPercent { get; set; }

Property Value

object

StartTime

UTC time indicating the start of the 15 second reporting interval.

[Column("start_time")]
[NotNull]
public DateTime StartTime { get; set; }

Property Value

DateTime