使用维护计划管理服务更新和维护Use maintenance schedules to manage service updates and maintenance

此维护计划功能可集成服务运行状况计划内维护通知、资源运行状况检查监视器,以及针对 Azure Synapse Analytics 中的 Synapse SQL 池(数据仓库)的维护计划服务。The maintenance schedule feature integrates the Service Health Planned Maintenance Notifications, Resource Health Check Monitor, and maintenance scheduling service for Synapse SQL pool (data warehouse) within Azure Synapse Analytics.

应使用维护计划选择一个方便接收新功能、升级和修补程序的时间范围。You should use maintenance scheduling to choose a time window when it's convenient to receive new features, upgrades, and patches. 你将需要选择 7 天内的主要和辅助维护时段,每个时段必须在单独的日期范围内。You will need to choose a primary and a secondary maintenance window within a seven-day period, each window must be within separate day ranges.

例如,可以这样计划:主要时段为星期六 22:00 到星期日 01:00,辅助时段为星期三 19:00 到 22:00。For example, you can schedule a primary window of Saturday 22:00 to Sunday 01:00, and then schedule a secondary window of Wednesday 19:00 to 22:00. 如果在主要维护时段无法进行维护,它会尝试在辅助维护时段再次进行维护。If maintenance can't be performed during your primary maintenance window, it will try the maintenance again during your secondary maintenance window. 在主要时段和辅助时段期间都可能会进行服务维护。Service maintenance could on occasion occur during both the primary and secondary windows. 为了确保快速完成所有维护操作,DW400c 和更低的数据仓库层可以在指定的维护时段之外完成维护。To ensure rapid completion of all maintenance operations, DW400c and lower data warehouse tiers could complete maintenance outside of a designated maintenance window.

所有新创建的数据仓库实例会在部署期间应用系统定义的维护计划。All newly created data warehouse instances will have a system-defined maintenance schedule applied during deployment. 部署完成后即可编辑该计划。The schedule can be edited as soon as deployment is complete.

虽然维护时段可以是 3 到 8 小时,但这并不意味着数据仓库会在这段时间内脱机。Although a maintenance window can be between three and eight hours this does not mean the data warehouse will be offline for the duration. 我们可能会在该时段内的任何时间进行维护,你应该预料到在该时段内会出现一次断开连接的情况,持续时间大约为 5 到 6 分钟,因为服务需将新代码部署到数据仓库。Maintenance can occur at any time within that window and you should expect a single disconnect during that period lasting ~5 -6 mins as the service deploys new code to your data warehouse. 在维护时段,DW400c 及更低的数据仓库层可能会多次出现短暂的连接丢失情况。DW400c and lower may experience multiple brief losses in connectivity at various times during the maintenance window. 维护开始时,将取消所有活动会话,并回退未提交的事务。When maintenance starts, all active sessions will be canceled, and non-committed transactions will be rolled back. 若要尽量减少实例停机时间,请确保数据仓库在选定的维护时限之前没有任何长时间运行的事务。To minimize instance downtime, make sure that your data warehouse has no long-running transactions before your chosen maintenance period.

所有维护操作都会在指定的维护时段内完成,除非我们必须部署时间敏感型更新。All maintenance operations should finish within the specified maintenance windows unless we are required to deploy a time sensitive update. 如果在计划维护期间暂停数据仓库,则会在恢复操作期间进行更新。If your data warehouse is paused during a scheduled maintenance, it will be updated during the resume operation. 数据仓库维护完成后,你会立即收到通知。You'll be notified immediately after your data warehouse maintenance is completed.

警报和监视Alerts and monitoring

与服务运行状况通知和资源运行状况检查监视器的集成可让客户随时了解即将发生的维护活动。Integration with Service Health notifications and the Resource Health Check Monitor allows customers to stay informed of impending maintenance activity. 此自动化利用 Azure Monitor。This automation takes advantage of Azure Monitor. 你可以决定如何接收有关即将进行的维护事件的通知。You can decide how you want to be notified of impending maintenance events. 此外,可以选择自动化流来管理停机时间,尽量减少操作影响。Also, you can choose which automated flows will help you manage downtime and minimize operational impact.

我们会在所有维护事件之前提前 24 小时通知,DWC400c 和更低层例外。A 24-hour advance notification precedes all maintenance events that aren't for the DWC400c and lower tiers.

备注

在我们需要部署时间关键型更新的情况下,提前通知时间可能会显著减少。In the event we are required to deploy a time critical update, advanced notification times may be significantly reduced.

如果你提前收到了维护通知,但维护无法在通知中指定的时段进行,你会收到取消通知。If you received advance notification that maintenance will take place, but maintenance can't be performed during the time period in the notification, you'll receive a cancellation notification. 随即会在下一个计划的维护期间继续进行维护。Maintenance will then resume during the next scheduled maintenance period.

所有活动维护事件显示在“服务运行状况 - 计划内维护”部分中。 All active maintenance events appear in the Service Health - Planned Maintenance section. 服务运行状况历史记录包括以往事件的完整记录。The Service Health history includes a full record of past events. 可以在活动事件期间通过 Azure 服务运行状况检查门户仪表板监视维护。You can monitor maintenance via the Azure Service Health check portal dashboard during an active event.

维护计划可用性Maintenance schedule availability

即使维护计划在所选的区域中不可用,也随时可以查看和编辑维护计划。Even if maintenance scheduling isn't available in your selected region, you can view and edit your maintenance schedule at any time. 维护计划在你的区域中可用后,指定的计划会立即对你的 Synapse SQL 池生效。When maintenance scheduling becomes available in your region, the identified schedule will immediately become active on your Synapse SQL pool.

查看维护计划View a maintenance schedule

默认情况下,所有新创建的数据仓库实例在部署期间会有八小时的主维护时段和辅助维护时段。By default, all newly created data warehouse instances have an eight-hour primary and secondary maintenance window applied during deployment. 如上所述,部署完成后,你可以更改此时段。As indicated above, you can change the windows as soon deployment is complete. 在未事先通知的情况下,不会在指定的维护时段外进行维护。No maintenance will take place outside the specified maintenance windows without prior notification.

若要查看已应用于 Synapse SQL 池的维护计划,请完成以下步骤:To view the maintenance schedule that has been applied to your Synapse SQL pool, complete the following steps:

  1. 登录到 Azure 门户Sign in to the Azure portal.
  2. 选择要查看的 Synapse SQL 池。Select the Synapse SQL pool that you want to view.
  3. 所选的 Synapse SQL 池随即在“概览”边栏选项卡上打开。The selected Synapse SQL pool opens on the overview blade. 应用于该数据仓库的维护计划将显示在“维护计划”下方。 The maintenance schedule that's applied to the data warehouse appears below Maintenance schedule.

概述边栏选项卡

更改维护计划Change a maintenance schedule

可以在任何时间更新或更改维护计划。A maintenance schedule can be updated or changed at any time. 如果所选的实例正在经历活动维护周期,将保存设置。If the selected instance is going through an active maintenance cycle, the settings will be saved. 在下一个确定的维护周期,它们将处于活动状态。They'll become active during the next identified maintenance period. 详细了解在活动维护事件期间监视数据仓库。Learn more about monitoring your data warehouse during an active maintenance event.

确定主要和辅助时段Identifying the primary and secondary windows

主要和辅助时段必须包含不同的日期范围。The primary and secondary windows must have separate day ranges. 例如,主要时段为星期二到星期四,辅助时段为星期六到星期日。An example is a primary window of Tuesday-Thursday and a secondary of window of Saturday-Sunday.

若要更改 Synapse SQL 池的维护计划,请完成以下步骤:To change the maintenance schedule for your Synapse SQL pool, complete the following steps:

  1. 登录到 Azure 门户Sign in to the Azure portal.

  2. 选择要更新的 Synapse SQL 池。Select the Synapse SQL pool that you want to update. 页面将在概述边栏选项卡上打开。The page opens on the overview blade. 在“概览”边栏选项卡上选择“维护计划摘要”链接,打开维护计划设置的页面。 Open the page for maintenance schedule settings by selecting the Maintenance Schedule summary link on the overview blade. 或者,选择左侧资源菜单中的“维护计划”选项。 Or, select the Maintenance Schedule option on the left-side resource menu.

    概述边栏选项卡选项

  3. 使用页面顶部的选项确定主要维护时段的首选日期范围。Identify the preferred day range for your primary maintenance window by using the options at the top of the page. 此选择确定主要时段会出现在工作日还是周末。This selection determines if your primary window will occur on a weekday or over the weekend. 所做的选择会更新下拉列表值。Your selection will update the drop-down values. 在预览期,某些区域可能尚不支持完整的可用“日期”选项集。 During preview, some regions might not yet support the full set of available Day options.

    维护设置边栏选项卡

  4. 使用下拉列表框选择首选的主要和辅助维护时段:Choose your preferred primary and secondary maintenance windows by using the drop-down list boxes:

    • :在所选时段内执行维护的首选日期。Day: Preferred day to perform maintenance during the selected window.
    • 开始时间:维护时段的首选开始时间。Start time: Preferred start time for the maintenance window.
    • 时间范围:时间范围的首选持续时间。Time window: Preferred duration of your time window.

    边栏选项卡底部的“计划摘要”区域将根据所选的值更新。 The Schedule summary area at the bottom of the blade is updated based on the values that you selected.

  5. 选择“保存” 。Select Save. 此时会显示一条消息,确认新计划现已处于活动状态。A message appears, confirming that your new schedule is now active.

    如果要在不支持维护计划的区域中保存计划,则会显示以下消息。If you're saving a schedule in a region that doesn't support maintenance scheduling, the following message appears. 当此功能在所选区域中可用时,设置将会保存并且变为活动状态。Your settings are saved and become active when the feature becomes available in your selected region.

    有关区域可用性的消息

后续步骤Next steps