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

Workload Analysis records event data in milliseconds and loses precision #65

Closed spaghettidba closed 4 years ago

spaghettidba commented 4 years ago

CPU and duration are captured as microseconds, but saved to the analysis database as milliseconds, hence losing precision. Especially for events wit sub-milliseconds times but a high execution frequency, this can introduce a significant error in the analysis.