search

spaghettidba / WorkloadTools

A collection of tools to collect, analyze and replay SQL Server workloads, on premises and in the cloud
MIT License
234 stars 53 forks source link

Fix #115 WorkloadViewer shows queries twice #147

Closed Silent1984 closed 10 months ago

Silent1984 commented 10 months ago

Hi,

i am not sure why you perform the rightouter join there and merge it with the leftouterjoin because that causes the dublicates. Is it because you can have queries in the benchmark which are not in the baseline?

spaghettidba commented 10 months ago

Hi! Well, I'm not really sure, many years have passed and I really can't tell. Probably I was thinking of queries in the benchmark not in the baseline, but that doesn't really make too much sense. When I'm comparing two workloads it's always the baseline that matters, so it is fair to change it the way you did. Thank you very much for your contributions!