Class AzureSQLDatabaseSchema.EventLog
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
sys.event_log (Azure SQL Database)
Applies to: √ Azure SQL Database
Returns successful Azure SQL Database database connections, connection failures, and deadlocks. You can use this information to track or troubleshoot your database activity with SQL Database.
> [!CAUTION]
> For installations having a large number of databases or high numbers of logins, activity in sys.event_log can cause limitations in performance, high CPU usage, and possibly result in login failures. Queries of sys.event_log can contribute to the problem. Microsoft is working to resolve this issue. In the meantime, to reduce the impact of this issue, limit queries of sys.event_log. Users of the NewRelic SQL Server plugin should visit Microsoft Azure SQL Database plugin tuning & performance tweaks for additional configuration information.
The sys.event_log view contains the following columns.
See sys.event_log.
[Table(Schema = "sys", Name = "event_log", IsView = true)]
public class AzureSQLDatabaseSchema.EventLog- Inheritance
-
AzureSQLDatabaseSchema.EventLog
- Extension Methods
Properties
AdditionalData
*Note: This value is always NULL for Azure SQL Database V12.
For Deadlock events, this column contains the deadlock graph. This column is NULL for other event types.
[Column("additional_data")]
[NotNull]
public object AdditionalData { get; set; }Property Value
DatabaseName
Name of the database. If the connection fails and the user did not specify a database name, then this column is blank.
[Column("database_name")]
[NotNull]
public string DatabaseName { get; set; }Property Value
Description
A detailed description of the event.
See Event Types for a list of possible values.
[Column("description")]
[NotNull]
public string Description { get; set; }Property Value
EndTime
UTC date and time of the end of the aggregation interval. For aggregated events, End_time is always exactly 5 minutes later than the corresponding start_time in the same row. For events that are not aggregated, start_time and end_time equal the actual UTC date and time of the event.
[Column("end_time")]
[NotNull]
public DateTime EndTime { get; set; }Property Value
EventCategory
The high-level component that generated this event.
See Event Types for a list of possible values.
[Column("event_category")]
[NotNull]
public string EventCategory { get; set; }Property Value
EventCount
The number of times that this event occurred for the specified database within the time interval specified (start_time and end_time).
[Column("event_count")]
[NotNull]
public int EventCount { get; set; }Property Value
EventSubtype
The subtype of the occurring event.
See Event Types for a list of possible values.
[Column("event_subtype")]
[NotNull]
public int EventSubtype { get; set; }Property Value
EventSubtypeDesc
The description of the event subtype.
See Event Types for a list of possible values.
[Column("event_subtype_desc")]
[NotNull]
public string EventSubtypeDesc { get; set; }Property Value
EventType
The type of event.
See Event Types for a list of possible values.
[Column("event_type")]
[NotNull]
public string EventType { get; set; }Property Value
Severity
The severity of the error. Possible values are:
0 = Information
1 = Warning
2 = Error
[Column("severity")]
[NotNull]
public int Severity { get; set; }Property Value
StartTime
UTC date and time of the start of the aggregation interval. For aggregated events, 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; }