
I know that SQL Server and Azure SQL support "Extended Events" as a means of profiling execution. I also know that MS Dynamics 365 is built with Azure SQL. What I'd like to accomplish is creating and managing XEvents for MS Dynamics 365 (i.e on its underlying Azure SQL DB). Presumably this means I'd be storing the telemetry data into Azure BLOB storage.
Is it possible to profile the MS Dynamics 365 CRM, or is it so deeply "managed"...that such instrumentation isn't possible? And if it isn't possible, are there any particular alternatives? My intent is to capture a cross-section of what kinds of queries/updates are being performed against the DJ...and in what quantities for a typical daily client work-load.
A key motivation for this is to serve as an input for capacity planning for the creation of a custom "operational data store", into which a breadth of applications will subsequently depend on for similar data.