Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sp_BlitzFirst: more Azure SQL DB performance diagnostics #3364

Open
BrentOzar opened this issue Sep 27, 2023 · 0 comments
Open

sp_BlitzFirst: more Azure SQL DB performance diagnostics #3364

BrentOzar opened this issue Sep 27, 2023 · 0 comments

Comments

@BrentOzar
Copy link
Member

BrentOzar commented Sep 27, 2023

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.)

@BrentOzar BrentOzar self-assigned this Sep 27, 2023
@BrentOzar BrentOzar changed the title sp_BlitzFirst: more Azure SQL DB diagnostics sp_BlitzFirst: more Azure SQL DB performance diagnostics Sep 27, 2023
@BrentOzar BrentOzar added this to the 2024-05 Release milestone Apr 19, 2024
@BrentOzar BrentOzar removed this from the 2024-05 Release milestone May 22, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant