Class AzureSQLDatabaseSchema.DatabaseConnectionStat

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.database_connection_stats (Azure SQL Database)

Applies to: √ Azure SQL Database

Contains statistics for SQL Database database connectivity events, providing an overview of database connection successes and failures. For more information about connectivity events, see Event Types in sys.event_log (Azure SQL Database).

See sys.database_connection_stats.

[Table(Schema = "sys", Name = "database_connection_stats", IsView = true)]
public class AzureSQLDatabaseSchema.DatabaseConnectionStat

Inheritance

object

AzureSQLDatabaseSchema.DatabaseConnectionStat

Extension Methods

Map.DeepCopy<T>(T)

Properties

ConnectionFailureCount

Number of login failures.

[Column("connection_failure_count")]
[NotNull]
public int ConnectionFailureCount { get; set; }

Property Value

int

DatabaseName

Name of the database.

[Column("database_name")]
[NotNull]
public string DatabaseName { get; set; }

Property Value

string

EndTime

UTC date and time of the end of the aggregation interval. End_time is always exactly 5 minutes later than the corresponding start_time in the same row.

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

Property Value

DateTime

StartTime

UTC date and time of the start of the aggregation interval. The time is always a multiple of 5 minutes. For example:

'2011-09-28 16:00:00'
'2011-09-28 16:05:00'
'2011-09-28 16:10:00'

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

Property Value

DateTime

SuccessCount

Number of successful connections.

[Column("success_count")]
[NotNull]
public int SuccessCount { get; set; }

Property Value

int

TerminatedConnectionCount

Only applicable for Azure SQL Database v11.

Number of terminated connections.

[Column("terminated_connection_count")]
[NotNull]
public int TerminatedConnectionCount { get; set; }

Property Value

int

ThrottledConnectionCount

Only applicable for Azure SQL Database v11.

Number of throttled connections.

[Column("throttled_connection_count")]
[NotNull]
public int ThrottledConnectionCount { get; set; }

Property Value

int

TotalFailureCount

Total number of failed connections. This is the sum of connection_failure_count, terminated_connection_count, and throttled_connection_count, and does not include deadlock events.

[Column("total_failure_count")]
[NotNull]
public int TotalFailureCount { get; set; }

Property Value

int