Class AzureSQLDatabaseSchema.BandwidthUsage
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
sys.bandwidth_usage (Azure SQL Database)
Applies to: √ Azure SQL Database √ Azure SQL Managed Instance
note
This applies only to Azure SQL DatabaseV11.
Returns information about the network bandwidth used by each database in a Azure SQL Database V11 database server, . Each row returned for a given database summarizes a single direction and class of usage over a one-hour period.
This has been deprecated in a Azure SQL Database.
The sys.bandwidth_usage view contains the following columns.
See sys.bandwidth_usage.
[Table(Schema = "sys", Name = "bandwidth_usage", IsView = true)]
public class AzureSQLDatabaseSchema.BandwidthUsage- Inheritance
-
AzureSQLDatabaseSchema.BandwidthUsage
- Extension Methods
Properties
Class
The class of bandwidth that was used, one of:
Internal: Data that is moving within the Azure platform.
External: Data that is moving out of the Azure platform.
This class is returned only if the database is engaged in a continuous copy relationship between regions (Active Geo-Replication). If a given database does not participate in any continuous copy relationship, then 'Interlink' rows are not returned. For more information, see the 'Remarks' section later in this topic.
[Column("class")]
[NotNull]
public object Class { get; set; }Property Value
DatabaseName
The name of the database that used bandwidth.
[Column("database_name")]
[NotNull]
public object DatabaseName { get; set; }Property Value
Direction
The type of bandwidth that was used, one of:
Ingress: Data that is moving into the Azure SQL Database.
Egress: Data that is moving out of the Azure SQL Database.
[Column("direction")]
[NotNull]
public object Direction { get; set; }Property Value
Quantity
The amount of bandwidth, in kilobytes (KBs), that was used.
[Column("quantity")]
[NotNull]
public object Quantity { get; set; }Property Value
Time
The hour when the bandwidth was consumed. The rows in this view are on a per-hour basis. For example, 2009-09-19 02:00:00.000 means that the bandwidth was consumed on September 19, 2009 between 2:00 A.M. and 3:00 A.M.
[Column("time")]
[NotNull]
public object Time { get; set; }Property Value
TimePeriod
The time period when the usage occurred is either Peak or OffPeak. The Peak time is based on the region in which the server was created. For example, if a server was created in the 'US_Northwest' region, the Peak time is defined as being between 10:00 A.M. and 6:00 P.M. PST.
[Column("time_period")]
[NotNull]
public object TimePeriod { get; set; }