search

spaghettidba / WorkloadTools

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

Not all intended events are captured as required #63

Closed spaghettidba closed 4 years ago

spaghettidba commented 4 years ago

It seems like SqlWorkload does not capture all the events it should. Comparing a dump to a XEL file on the same events captured by workloadtools with the data saved in the sqlite database, around 15% of the events are missing. This also reflects in the analysis, but the source of the problem seems to be in the capture itself

spaghettidba commented 4 years ago

It seems like all events are captured, but the unit measure when capturing is MICROseconds, but cpu and duration are captured in memory and stored in the analysis database in MILLIseconds, hence losing precision. A full rewrite of this area is needed.