Sample Header Ad - 728x90

Help using SQL Server Database Experimentation Assistant for performance testing

1 vote
1 answer
452 views
I am following the guide for capturing a trace in SQL Server Database Experimentation Assistant here: https://learn.microsoft.com/en-us/sql/dea/database-experimentation-assistant-capture-trace?view=sql-server-2017 I am using DEA version 2.6. The article above states that I should be able to choose the capture trace file size for rolling over files. However, in version 2.6 I do not have the option to set trace file size. As a result, I end up with dozens of 500 MB files at the end of the capture. Then I am expected to sit there and replay each trace file, one by one. Is there any easier way of doing this, or of forcing the trace file to grow larger so I end up with less rollover files? My new capture screen: enter image description here MS doc capture screen: enter image description here
Asked by blizz (157 rep)
Jun 20, 2019, 06:40 PM
Last activity: May 26, 2021, 07:10 PM