Skip to content

Instantly share code, notes, and snippets.

@revirth

revirth/database_connection_stats.sql

Created September 23, 2014 01:54
Show Gist options
  • Save revirth/51d27e651d54bf778d14 to your computer and use it in GitHub Desktop.
Save revirth/51d27e651d54bf778d14 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
database_connection_stats.sql
use master;
-- database_connection_stats
select database_name, cast(start_time as varchar(20)), cast(end_time as varchar(20)),
success_count, total_failure_count, connection_failure_count, terminated_connection_count, throttled_connection_count
from sys.database_connection_stats
where database_name = 'DB Name'
order by start_time desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment