7

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?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
mark
  • 59,016
  • 79
  • 296
  • 580
  • 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](https://learn.microsoft.com/en-us/sql/azure-data-studio/sql-server-profiler-extension) that itself consumes Extended Events. – AlwaysLearning Sep 23 '20 at 02:59
  • Sounds like an answer to me. Why not arrange your comment as an answer so I could credit you? – mark Sep 23 '20 at 19:04

1 Answers1

11

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!

Leon Yue
  • 15,693
  • 1
  • 11
  • 23