Company News
DBGorilla now supports SQL Server
DBGorilla now supports SQL Server 2022 and 2025 and Azure SQL Database, testing changes on clones that carry your production statistics.
Cornelius·
DBGorilla now supports Microsoft SQL Server 2022 and 2025, and Azure SQL Database. Agents test changes on database clones that carry your production statistics, so the optimizer uses the same numbers it uses in production.
You can connect SQL Server that you run yourself, on premises or on virtual machines, as well as Amazon RDS for SQL Server and Azure SQL Database.
What the collector reads
The collector reads your workload from Query Store, along with wait statistics, index usage and estimated execution plans. It runs inside your network and connects out to DBGorilla, so you do not need to open inbound firewall rules. The collector login needs view permissions and SHOWPLAN. It does not need write access.
How the clones keep your statistics
When an agent wants to test a change, DBGorilla runs the experiment on a clone of your database. DBGorilla uses SQL Server’s native stats streams to copy each statistics object to the clone, together with each table’s row and page counts, and turns off automatic statistics updates so SQL Server does not recompute them.
Stephen Nolan, our co-founder, explains how these clones work at PASS Data Community Summit West in Seattle on Tuesday 10 November, at 3:15pm Pacific in Room 304 Calawah.
Connect your database
Start with Prepare SQL Server.