search

microsoft / DiagManager

Pssdiag/Sqldiag Manager is a graphic interface that provides customization capabilities to collect data for SQL Server using sqldiag collector engine. The data collected can be used by SQL Nexus tool which help you troubleshoot SQL Server performance problems. This is the same tool Microsoft SQL Server support engineers use to for data collection to troubleshoot customer's performance problems.
Other
251 stars 96 forks source link

Modifications required for Managed Instance #90

Open suresh-kandoth opened 3 years ago

suresh-kandoth commented 3 years ago

feedback from Denzil:

Managed instance doesn’t take instance name ( Just server name). Even if you give \MSSQLServer as instance name it fails assuming is due to gateway/proxy so effectively would be great if o Have a ServerName parameters o If InstanceName is default instance, then leave it off totally from SQL connect string o Also give some provision for Other auth methods than just -E ( given MI)  For AAD can use SQLCMD - G -- [-G use Azure Active Directory for authentication]  For SQl Auth as well

PiJoCoder commented 2 years ago

@gambit9009 should we look at this one given SQL MI is gaining some prominence. @suresh-kandoth do the Azure SQL MI engineers t-shoot with PSSDIAG? Can they if this change was there?