A simple set of projects that you can use to benchmark SQL Server Data Tools (SSDT) compilation times accross machines.
- Clone or download repository
- Run one of the batch files
- Check the elapsed time shown
There are three solutions, each testing a different project approach:
A single database project with 4000 tables, 2000 views and 2000 stored procedures.
A single database MSBuild.Sdk.SqlProj project which references the 4000 tables, 2000 views and 2000 stored procedures from BenchDb. This compares a MSBuild.Sdk.SqlProj project to the traditional SSDT project.
Three projects, one each for the 4000 tables (BenchDbTables), 2000 views (BenchDbViews) and 2000 stored procedures (BenchDbCode). They are combined as one database using Same database project references. This can be compared to BenchDb to asses the impact of spliting a database accross several projects.