Drilldown on chart - no Queries returned
SQLGeordie opened this issue · 3 comments
I have been running some random workload tests on my local machine to get more comfortable with the tool before using it as part of a project. Whilst viewing the output in WorkloadViewer and drilling down on the chart (middle click mouse and highlight intervals) where the benchmark is still running after the baseline had finished, I got no results when I went into Queries.
My tests were running random workload against (baseline) WideWorldImporters on SQL 2019 (12vCPU and max mem set to 20GB ram) and replaying on the same instance but I changed SQL Server to (benchmark) have only 1 cpu in processor affinity and max mem set to 4GB.
NOTE: This was just a test to see differences on a local instance, not a server I am trying to migrate to
Screenshots and Analysis database backup files attached. Schemas used in the report are baseline and replaytargetbenchmark1cpu.
Thanks for reporting the issue. Unfortunately I'm joining the dat in memory using LINQ and there is no FULL JOIN readily available. I tried a couple of solutions but I'm not satisfied with the performance. I'm still working on it, I'll keep you posted.
Should be ok now. Can I close this one @SQLGeordie?
If you're happy, then I'm happy big man 👌