SQL Server Database Experimentation Assistant Analysis Reports
1
vote
1
answer
243
views
I am using the Database Experimentation Assistant v2.6 to capture a workload using extended events (
I've looked through multiple articles but the only ones I've found, including this one from Microsoft , refer to selecting only one file and normally a
.xel
) on SQL Server 2017 that is installed on an Azure VM. I'm then replaying it on a Azure SQL Database Managed Instance. The capture and the replay work great. I'm getting multiple .xel
files from the replay, 15 from the VM and 7 from the Managed Instance.
My issue is when I create the analysis report it only allows me to select 1 .xel
file in each of the the "Trace for Target 1 SQL Server" and "Trace for Target 2 SQL Server" fields to compare. My expectation is that I can run one report for the entire replay by selecting the directories the files are in but this does not appear to be an option? When I try to select just the directory it will not allow me to exit the directory window. Below is the screen I'm referring to : 
.trc
file not a .xel
file.
How can I compare multiple .xel
files at once?
Asked by Trevor Brent
(31 rep)
May 5, 2020, 02:57 AM
Last activity: May 8, 2020, 08:56 PM
Last activity: May 8, 2020, 08:56 PM