Database Lab uses local thin clones to provide isolated, full-size copies of your multi-terabyte databases in seconds, instead of hours or even days
Verify complex database changes
With Database Lab, all database schema or data changes are automatically verified covering 100% of cases. Engineers can easily see the true behavior of any database migration before it is deployed and optimize it when needed. Management is confident that the risks of downtime and performance degradation are eliminated.
Instant provisioning of full-size independent clones of large databases.
Production is not affected nor does it need any special changes to make Database Lab work. Special technologies (such as ZFS) are used only on Database Lab servers.
Automated recycling of used clones.
Multiple parallel verification processes.
Useful artifacts highlighting potentially dangerous issues (including: risks of locking issues and contention, query analysis, DBA-level metrics such as checkpoint and autovacuum behavior analysis).
Optimize SQL queries
Development and testing using real-life data and SQL plans identical to production.
Two major bottlenecks are eliminated: no more long waiting for your more experienced colleague's attention and no more long waiting for a new database clone provision.
SQL optimization recommendations.
Searchable history of all SQL optimization sessions to collect and share the optimization experience.
SQL plan details are explained and visualized.
Hypothetical indexes to get a sneak peek of the forecasted SQL query plan before building large indexes.