Monitoring MS Dynamics 365 with Extended Events
0
votes
0
answers
42
views
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 DB...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.
Asked by Brent Arias
(191 rep)
Oct 28, 2022, 04:47 PM
Last activity: Oct 28, 2022, 05:03 PM
Last activity: Oct 28, 2022, 05:03 PM