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

Pass the timestamp along with the events from file #79

Closed spaghettidba closed 4 years ago

spaghettidba commented 4 years ago

Using the original timestamp (or its offset from the beginning of the capture) would be useful for the consumers: replay consumer could use it for timing queries and analysis consumer could use it to time events the upload to the analysis database. In particular, the analysis consumer could use it to receive events from a file listener without using the SynchronizationMode attribute is false (all events arrive at the same time). This way, the events could be grouped on the original timestamp instead of the time of the analysis, which would be much more effective.