You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Is your feature request related to a problem? Please describe.
I've had a couple of underpowered Azure SQL DB clients recently, and I wanna make it easier to see at a glance if they're having failovers or if they're hitting resource limit throttling at the database layer or the elastic pool layer.
Describe the solution you'd like
Pull some diagnostics from these DMVs - just doing a brain dump while I have the data handy:
To be added:
SELECT TOP 100 * FROM sys.dm_database_engine_configurations
SELECT TOP 100 * FROM sys.dm_db_resource_stats
SELECT TOP 100 * FROM sys.dm_database_replica_states
SELECT TOP 100 * FROM sys.dm_elastic_pool_resource_stats
SELECT TOP 100 * FROM sys.dm_os_memory_health_history
SELECT TOP 100 * FROM sys.dm_resource_governor_resource_pools_history_ex
SELECT TOP 100 * FROM sys.dm_resource_governor_workload_groups_history_ex
SELECT TOP 100 * FROM sys.dm_user_db_resource_governance
SELECT TOP 100 * FROM sys.elastic_pool_resource_stats_ex
SELECT TOP 100 * FROM sys.event_log_ex
SELECT TOP 100 * FROM sys.resource_stats_raw
SELECT TOP 100 * FROM sys.resource_usage
Done in other issues:
SELECT TOP 100 * FROM sys.dm_cloud_database_epoch - useful for determining metrics start time
SELECT TOP 100 * FROM sys.dm_db_wait_stats - already in use
Are you ready to build the code for the feature?
Yep! I won't do this right away, but will gradually build it in over the next few weeks. After that, I'll also add sp_BlitzFirst to the Consultant Toolkit (to replace the wait stats sampling that we're currently doing in there.)
The text was updated successfully, but these errors were encountered:
Is your feature request related to a problem? Please describe.
I've had a couple of underpowered Azure SQL DB clients recently, and I wanna make it easier to see at a glance if they're having failovers or if they're hitting resource limit throttling at the database layer or the elastic pool layer.
Describe the solution you'd like
Pull some diagnostics from these DMVs - just doing a brain dump while I have the data handy:
To be added:
Done in other issues:
Are you ready to build the code for the feature?
Yep! I won't do this right away, but will gradually build it in over the next few weeks. After that, I'll also add sp_BlitzFirst to the Consultant Toolkit (to replace the wait stats sampling that we're currently doing in there.)
The text was updated successfully, but these errors were encountered: