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

Empty replay schema #19

Closed rducic closed 6 years ago

rducic commented 6 years ago

The code refers to replay schema and objects, however, those objects are not created automatically as the baseline tables are. My understanding of the intended implementation is to have 2 instances (source and replay) to capture the traffic on the source and replay it on secondary. The to use the baseline schema and tables to capture run times on origin server. And to use Replay schema to capture Replay durations.

I created The replay schema and tables using individual scripts but there is nothing that populates this schema. However, the analyses view is querying this schema, but since the replay tables are not created it is failing to execute.