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).
| Statistic | Type | Description |
|---|---|---|
| database_name | sysname | Name of the database. |
| start_time | 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' |
| end_time | 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. |
| success_count | int | Number of successful connections. |
| total_failure_count | 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. |
| connection_failure_count | int | Number of login failures. |
| terminated_connection_count | int | This column is unused and is preserved for backwards compatibility. |
| throttled_connection_count | int | This column is unused and is preserved for backwards compatibility. |
Remarks
Event aggregation
Event information for this view is collected and aggregated within 5-minute intervals. The count columns represent the number of times a particular connectivity event occurred for a specific database within a given time interval.
For example, if a user fails to connect to database Database1 seven times between 11:00 and 11:05 on March 30, 2022 (UTC), this information is available in a single row in this view:
| database_name | start_time | end_time | success_count | total_failure_count | connection_failure_count | terminated_connection_count | throttled_connection_count |
|---|---|---|---|---|---|---|---|
Database1 |
2022-03-30 11:00:00 |
2022-03-30 11:05:00 |
0 |
7 |
7 |
0 |
0 |
Interval start_time and end_time
An event is included in an aggregation interval when the event occurs on or after start_time and before end_time for that interval. For example, an event occurring exactly at 2022-03-30 19:25:00.0000000 would be included only in the second interval shown below:
start_time end_time
2022-03-30 19:20:00.0000000 2022-03-30 19:25:00.0000000
2022-03-30 19:25:00.0000000 2022-03-30 19:30:00.0000000
Data updates
Data in this view is accumulated over time. Typically, the data is accumulated within an hour of the start of the aggregation interval, but it may take up to a maximum of 24 hours for all the data to appear in the view. During that time, the information within a single row may be updated periodically.
Data retention
The data in this view is retained for a maximum of 30 days, or possibly less depending on the number of databases and the number of unique events each database generates. To retain this information for a longer period, copy the data to a separate database. After you make an initial copy of the view, the rows in the view may be updated as data is accumulated. To keep your copy of the data up-to-date, periodically do a table scan of the rows to look for an increase in the event count of existing rows and to identify new rows (you can identify unique rows by using the start and end times), then update your copy of the data with these changes.
Errors not included
This view may not include all connection and error information:
- This view does not include all SQL Database database errors that could occur, only those specified in Event Types in sys.event_log (Azure SQL Database).
- If there is a machine failure within the SQL Database datacenter, a small amount of data may be missing from the event table.
- If an IP address has been blocked through DoSGuard, connection attempt events from that IP address cannot be collected and will not appear in this view.
Permissions
Requires permission to access the master database on the logical server in Azure SQL Database.
Examples
This example queries sys.database_connection_stats to return a summary of the database connections that occurred between noon on March 29, 2022 and noon on March 30, 2022 (UTC). Connect to the master database on the logical server in Azure SQL Database to run the query.
SELECT database_name, start_time, end_time, success_count, total_failure_count, connection_failure_count
FROM sys.database_connection_stats
WHERE start_time>='2022-03-29 12:00:00' and end_time<='2022-03-30 12:00:00'
ORDER BY start_time ASC;
Next steps
Learn more about Azure SQL Database in the following articles: