Table of Contents

Class AzureSQLDatabaseSchema.ServerResourceStat

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

sys.server_resource_stats (Azure SQL Managed Instance)

√ Azure SQL Managed Instance
Returns CPU usage, IO, and storage data for Azure SQL Managed Instance. The data is collected, aggregated and updated within 5 to 10 minutes intervals. There is one row for every 15 seconds reporting. The data returned includes CPU usage, storage size, IO utilization, and SKU. Historical data is retained for approximately 14 days.
The sys.server_resource_stats view has different definitions depending on the version of the Azure SQL Managed Instance that the database is associated with. Consider these differences and any modifications your application requires when upgrading to a new server version.
note


This dynamic management view applies to Azure SQL Managed Instance only. For an equivalent view for Azure SQL Database, use sys.resource_stats.


See sys.server_resource_stats.

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

Properties

AvgCpuPercent

Average compute utilization in percentage of the limit of the Managed Instance service tier utilized by the instance. It is calculated as sum of CPU time of all resource pools for all databases in the instance and divided by available CPU time for that tier in the given interval.

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

Property Value

object

EndTime

UTC time indicating the end of the fifteen-second reporting interval

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

Property Value

DateTime

HardwareGeneration

Hardware generation identifier: such as Gen 4 or Gen 5

[Column("hardware_generation")]
[NotNull]
public string HardwareGeneration { get; set; }

Property Value

string

IOBytesRead

Number of physical bytes read within the interval

[Column("io_bytes_read")]
[NotNull]
public long IOBytesRead { get; set; }

Property Value

long

IOBytesWritten

Number of physical bytes written within the interval

[Column("io_bytes_written")]
[NotNull]
public long IOBytesWritten { get; set; }

Property Value

long

IORequest

Total number of i/o physical operations within the interval

[Column("io_request")]
[NotNull]
public long IORequest { get; set; }

Property Value

long

ReservedStorageMB

Reserved storage per instance (amount of storage space that customer purchased for the managed instance)

[Column("reserved_storage_mb")]
[NotNull]
public long ReservedStorageMB { get; set; }

Property Value

long

ResourceName

Name of the resource.

[Column("resource_name")]
[NotNull]
public string ResourceName { get; set; }

Property Value

string

ResourceType

Type of the resource for which metrics are provided

[Column("resource_type")]
[NotNull]
public object ResourceType { get; set; }

Property Value

object

Sku

Managed Instance Service Tier of the Instance. The following are the possible values:

  • General Purpose
  • Business Critical
[Column("sku")]
[NotNull]
public string Sku { get; set; }

Property Value

string

StartTime

UTC time indicating the start of the fifteen-second reporting interval

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

Property Value

DateTime

StorageSpaceUsedMB

Storage used by all database files in a managed instance (including both user and system databases)

[Column("storage_space_used_mb")]
[NotNull]
public object StorageSpaceUsedMB { get; set; }

Property Value

object

VirtualCoreCount

Represents number of virtual cores per instance

[Column("virtual_core_count")]
[NotNull]
public int VirtualCoreCount { get; set; }

Property Value

int