WorkloadViewer shows queries twice, with inverted stats (baseline <--> benchmark)

[CrazySwimmer]

It is the exact same workload captured in two different ways.
Baseline was captured from ExtendedEventsWorkloadListener to AnalysisConsumer + WorkloadFileWriterConsumer
Benchmark was captured from FileWorkloadListener to AnalysisConsumer
The benchmark does not come from a replay.

The query marked in red appears only once because I stopped the benchmark analysis before it was finished.

[CrazySwimmer]

I can confirm that I get the same result even after full replays, no matter what two workloads I compare.

An interesting point I noticed is that I can select either of any two queries and the "Query Details" pane will always show only one result (i.e., not inverted).
I would guess this points to a problem in how the merge is done in the "Queries" pane.

[spaghettidba]

Thank you for reporting this problem.
Would it be possible for you to upload a copy of the analysis database? You can "anonymize" the queries but blanking the "normalized_text" and "example_text" columns in the NormalizedQueries table.

[CrazySwimmer]

Hi Gianluca,
Apologies for the late reply.
Where should I upload the analysis database?

[spaghettidba]

Wherever you prefer (google drive, onedrive...). If the database is small enough you can attach it to the issue by drag/drop on the comment.

[CrazySwimmer]

I took the liberty to anonymize databases, hosts and logins as well.
One precision: this isn't the database from the screenshot above, but the "feature" of interest is still present.

Here's a ZIP containing the backup file:
WorkloadAnalysis_CrazySwimmer.zip

[spaghettidba]

Awesome! Thank you very much for the file. I will have a look as soon as possible.