search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.57k stars 901 forks source link

SQL Profiler doesn't work on Azure connections that don't specify a user database #11732

Open kburtram opened 4 years ago

kburtram commented 4 years ago

Steps to Reproduce:

  1. Create a connection to Azure SQL DB server using default database
  2. Launch Profiler on this node

Expected: Profiler uses one of the user dbs for profiling, or the Launch Profiler option isn't available on the server, but is only on the actual child DB nodes.

Actual: Profiler gives error saying "Can't profile system databases"

saasaTom commented 1 year ago

This would be great to have fixed - bugs me all the time.

Plus it isn't obvious when you first encounter the error how to get around it.

JCarlosR commented 4 months ago

Good to know! It was also preventing me to start any new session.