sql-serverazuresql-server-profiler

How to use SQL Server Profiler with an Azure SQL Server with AAD integrated security where AAD user is different from logged in desktop account?

Scenario:

  1. User logged in to desktop using domain account
  2. User has an Azure account in AAD which is different from the domain account
  3. Azure SQL database with AAD authentication configured for the Azure account

How can user profile the SQL queries sent to the Azure SQL database using SQL Server Profiler?

Solution

  • Thanks for @AlwaysLearning's help:

    "You should consider SQL Profiler to be a deprecated tool and start using Extended Events instead. That being said Microsoft does provide an SQL Profiler-like extension for Azure Data Studio that itself consumes Extended Events"

    We're glad that that could be an answer for you.

    I just help him post it and this can be beneficial to other community members. Thank @AlwaysLearning again!