Workload analysis does not work with case-sensitive collations

spaghettidba / WorkloadTools

A collection of tools to collect, analyze and replay SQL Server workloads, on premises and in the cloud

MIT License

230 stars 51 forks source link

Workload analysis does not work with case-sensitive collations #129

Open spaghettidba opened 1 year ago

spaghettidba commented 1 year ago

When the default database collation is case-sensitive, workload analysis creates a case-sensitive database and some of the queries do not work as intended