Which extensions to use to monitor server / database / queries in ADS

Susja 716 Reputation points
2023-08-14T00:01:27.4733333+00:00

Hello,

I am starting to use ADS. Most of the time I will run SQL queries but sometimes I will need also to monitor database and troubleshoot slow queries. In other words .. quite lightweight 'bad' query troubleshooting and basic monitoring.

Which ADS extensions would you recommend installing and use for that case?

Thanks

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,968 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
106 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 17,631 Reputation points Microsoft Employee
    2023-08-16T21:57:55.2333333+00:00

    @Susja Thank you for the ask again. I am glad that you are trying the ADS tool.

    If my understanding is correct, you are looking for an extension that will monitor your database and troubleshoot slow running queries.

    For lightweight query troubleshooting and basic monitoring in Azure Data Studio, I would recommend Azure SQL profiler.

    Please do check out our documentation.

    SQL Server Profiler extension (Preview)

    User's image

    Regards,

    Oury