This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 39%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Hello,
We need to create a new copy of a database on a different server using the PowerShell command "New-AzSqlDatabaseCopy".
Will running this command impact the performance of the live database, especially if other jobs or queries are running simultaneously?
If there are potential performance issues, is there a way to set a timeout for the copy process? Specifically, can we cancel the copy job if it exceeds a certain time limit?
Thanks for your help in advance !
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Hi Rohit •,
We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
Thanks
Hi，@Rohit
how is your issue going? If you are satisfied with the answer, please don't forget to "Accept it." This will greatly help our work and also assist others who have similar questions. You will also receive appreciation from the community.
Lastly, I wish you all the best!
Hi，@Rohit
I am not sure if you are receiving my messages. I am currently rechecking this issue. Has your problem been resolved? To better maintain the thread and make our best efforts to address this issue, we are looking forward to your response. If the problem has been resolved, please select "Answer" and "Accept it," as this will effectively help others who have similar issues.
I am not at all familiar with this command, but nothing comes for free, so, yes, it will interfere with the other activity on the source database. Whether it will be actually noticeable - I don't know.
But to play it safe, restore a backup of the database on the same server and run the PowerShell command against the copy.
In which business tier is your source database?
Hi，Rohit
New-AzSqlDatabaseCopy uses snapshot technology to create data copies during replication. The snapshot creation itself is a quick process and does not significantly affect the database’s performance.
Additionally, the data replication process is asynchronous, meaning it does not block the normal operations of the source database. However, during data transfer, there will be competition for I/O, memory, and CPU resources on the server, which can impact database performance from a server resource perspective.
Therefore, you need to monitor server performance through Azure Monitor to determine if replication needs to be stopped.
Best regards,
Mikey Qiao
Hi，@Rohit
Could you please let us know how your issue regarding Copy Database is going? If you have any questions, please feel free to ask. If the answer has successfully resolved your problem, to smoothly close this thread, please don't forget to 'Accept it'. This will greatly encourage our work and help others who have similar issues.