How to Start an XEvents Trace on a Read Scale-Out Azure SQL Managed Instance
Category:
azure-sql
, sql-server
It took me more than half hour to figure out how to start an XEvents trace on a read-scale out instance of Azure SQL Managed Instance. It’s hard to monitor read scale-out instances, so tracing is desirable! I started with a simple trace of sql_statement_completed. Hopefully this saves other folks some time.