Monday , December 4 2023

DBCC clondatabase in SQL Server

What is dbcc clondatabase in SQL Server

DBCC ClonDatabase announced with SQL Server 2014 SP2. We are able to create a copy of the database without data to analyze query performance issues with the DBCC Clondatabase command.

Although there is no data in the clone database, it produces the same execution plan as the production database. This helps us to analyze the problem in the production database without data.

To run this command, you must use the most current version of the version you are using. Because there are bugs related to this command in SQL Server 2014 SP2, and early versions of SQL Server 2016.

How To Use DBCC Clondatabase

You can use it as follows:


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *