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

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Extension Methods

Map.DeepCopy<T>(T)

Properties

ConnectionFailureCount

connection_failure_count NOT NULL int

Number of login failures.

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

Property Value

int

DatabaseName

database_name NOT NULL sysname

Name of the database.

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

Property Value

string

EndTime

end_time NOT NULL datetime2

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

start_time NOT NULL datetime2

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

'2022-03-30 16:00:00'
'2022-03-30 16:05:00'
'2022-03-30 16:10:00'

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

Property Value

DateTime

SuccessCount

success_count NOT NULL int

Number of successful connections.

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

Property Value

int

TerminatedConnectionCount

terminated_connection_count NOT NULL int

This column is unused and is preserved for backwards compatibility.

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

Property Value

int

ThrottledConnectionCount

throttled_connection_count NOT NULL int

This column is unused and is preserved for backwards compatibility.

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

Property Value

int

TotalFailureCount

total_failure_count NOT NULL int

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