使用数据库备份应用程序服务会导致性能问题吗? [英] Backing up app service with database can cause performance problems?

问题描述

使用数据库备份应用程序服务是否有可能导致诸如cpu值过高或网站关闭等问题?

Is there possibility that backing up app service with database can cause problems like too high cpu or website down?

备份运行时，它是否正在使用应用服务计划中的性能?

When backup is running it is using performance from app service plan or not?

How does the backend process back up the application service? Something like snapshots on app service and .bacpac on database?

推荐答案

您是否正在使用标准或高级应用程序服务计划?
您要利用什么数据库?
这是您第一次尝试执行备份，还是此设置之前效果良好?

备份的存储方式:
为应用程序制作一个或多个备份后，备份将在存储帐户和应用程序的容器"页面上可见.在存储帐户中，每个备份都包含一个包含备份数据的.zip文件和一个包含以下数据的.xml文件: .zip文件内容的清单.如果要访问备份而不实际执行应用程序还原，则可以解压缩和浏览这些文件.
该应用程序的数据库备份存储在.zip文件的根目录中.对于SQL数据库，这是BACPAC文件(无文件扩展名)，可以导入.
在计划或手动执行备份的过程中/之后，数据库的备份可能具有以下任何状态，请检查一下并告知我们.
• 正在进行中；失败的;成功；时间到;已创建；跳过；部分成功

Are you using a Standard or Premium App Service Plan?
What Database are you leveraging? 
Is this the first time you are attempting to perform a backup or has this setup worked fine before? 

How backups are stored: 
After you have made one or more backups for your app, the backups are visible on the Containers page of your storage account, and your app. In the storage account, each backup consists of a.zip file that contains the backup data and an .xml file that contains a manifest of the .zip file contents. You can unzip and browse these files if you want to access your backups without actually performing an app restore.
The database backup for the app is stored in the root of the .zip file. For a SQL database, this is a BACPAC file (no file extension) and can be imported. 

The backup of your database could have any of these status during/after the scheduled or manual execution of a backup, could you please check on this and let us know.
• InProgress; Failed; Succeeded; TimedOut; Created; Skipped; PartiallySucceeded

通常，备份不会引起任何性能问题，请确保满足所有要求，如本文档部分所述 要求和限制，备份最多可存储10 GB的应用程序和数据库内容.如果备份大小超出此限制，则会出现错误.您可以找到此博客中提到的备份日志，以获取有关该问题的更多详细信息.

Typically, backup would not cause any performance issues, kindly ensure that all the requirements are met, as mentioned in this document section Requirements and restrictions, backups can be up to 10 GB of app and database content. If the backup size exceeds this limit, you get an error. You could find the backup logs as mentioned in this blog to fetch more details on the issue.

这篇关于使用数据库备份应用程序服务会导致性能问题吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！