You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
| Business Critical (vCore) | Local storage | Yes | Yes |
@@ -55,11 +55,11 @@ The following table shows the availability options based on service tiers:
55
55
56
56
57
57
58
-
## Locally-redundant availability
58
+
## Locallyredundant availability
59
59
60
-
Locally-redundant availability is based on storing your database to [locally-redundant storage (LRS)](/azure/storage/common/storage-redundancy#locally-redundant-storage) which copies your data three times within a single datacenter in the primary region and protects your data in the event of local failure, such as a small-scale network or power failure. LRS is the lowest-cost redundancy option and offers the least durability compared to other options. If a large-scale disaster such as fire or flooding occurs within a region, all replicas of a storage account using LRS may be lost or unrecoverable. As such, to further protect your data when using the locally-redundant availability option, consider using a more resilient storage option for your [database backups](automated-backups-overview.md#backup-storage-redundancy). This does not apply to Hyperscale databases, where the same storage is used for both data files and backups.
60
+
Locallyredundant availability is based on storing your database to [locallyredundant storage (LRS)](/azure/storage/common/storage-redundancy#locally-redundant-storage) which copies your data three times within a single datacenter in the primary region and protects your data in the event of local failure, such as a small-scale network or power failure. LRS is the lowest-cost redundancy option and offers the least durability compared to other options. If a large-scale disaster such as fire or flooding occurs within a region, all replicas of a storage account using LRS may be lost or unrecoverable. As such, to further protect your data when using the locallyredundant availability option, consider using a more resilient storage option for your [database backups](automated-backups-overview.md#backup-storage-redundancy). This does not apply to Hyperscale databases, where the same storage is used for both data files and backups.
61
61
62
-
Locally-redundant availability is available to all databases in all service tiers.
62
+
Locallyredundant availability is available to all databases in all service tiers.
63
63
64
64
### <aid="general-purpose-service-tier-zone-redundant-availability"></a> Basic, Standard and General Purpose service tiers
65
65
@@ -138,7 +138,7 @@ Consider the following when configuring your General Purpose databases with zone
138
138
- (North America) South Central US
139
139
- (North America) West US 2
140
140
- (South America) Brazil South
141
-
- For zone redundant availability, choosing a [maintenance window](maintenance-window.md) other than the default is currently available in [select regions](maintenance-window.md#azure-region-support).
141
+
- For zone redundant availability, choosing a [maintenance window](maintenance-window.md) other than the default is currently available in [select regions](maintenance-window.md#azure-sql-database-region-support-for-maintenance-windows).
142
142
- Zone-redundant configuration is only available in SQL Database when standard-series (Gen5) hardware is selected.
143
143
- Zone-redundancy is not available for Basic and Standard service tiers in the DTU purchasing model.
144
144
@@ -156,7 +156,7 @@ Consider the following when configuring your Premium or Business Critical databa
156
156
157
157
- When using the Business Critical tier, zone-redundant configuration is only available when the Gen5 hardware is selected.
158
158
- For up to date information about the regions that support zone-redundant databases, see [Services support by region](/azure/availability-zones/az-region).
159
-
- For zone redundant availability, choosing a [maintenance window](./maintenance-window.md) other than the default is currently available in [select regions](maintenance-window.md#azure-region-support).
159
+
- For zone redundant availability, choosing a [maintenance window](./maintenance-window.md) other than the default is currently available in [select regions](maintenance-window.md#azure-sql-database-region-support-for-maintenance-windows).
160
160
161
161
### <aid="hyperscale-service-tier-zone-redundant-availability"></a> Hyperscale service tier
162
162
@@ -167,7 +167,7 @@ Enabling this configuration ensures zone-level resiliency through replication ac
167
167
Consider the following limitations:
168
168
169
169
- Zone redundant configuration can only be specified during database creation. This setting can't be modified once the resource is provisioned. Use [Database copy](database-copy.md), [point-in-time restore](recovery-using-backups.md#point-in-time-restore), or create a [geo-replica](active-geo-replication-overview.md) to update the zone redundant configuration for an existing Hyperscale database. When using one of these update options, if the target database is in a different region than the source or if the database backup storage redundancy from the target differs from the source database, the [copy operation](database-copy.md#database-copy-for-azure-sql-hyperscale) will be a size of data operation.
170
-
- For zone redundant availability, choosing a [maintenance window](maintenance-window.md) other than the default is currently available in [select regions](maintenance-window.md#azure-region-support).
170
+
- For zone redundant availability, choosing a [maintenance window](maintenance-window.md) other than the default is currently available in [select regions](maintenance-window.md#azure-sql-database-region-support-for-maintenance-windows).
171
171
- Only standard-series (Gen5) hardware is supported.
172
172
- Named replicas aren't currently supported.
173
173
- There's currently no option to specify zone redundancy when migrating a database to Hyperscale using the Azure portal. However, zone redundancy can be specified using Azure PowerShell, Azure CLI, or the REST API when migrating an existing database from another Azure SQL Database service tier to Hyperscale. Here's an example with Azure CLI: `az sql db update --resource-group "myResourceGroup" --server "myServer" --name "myDB" --edition Hyperscale --zone-redundant true`
- question: What is the default maintenance policy if I don't choose any specific window?
26
26
answer: |
27
-
Maintenance events will occur during the default window 5PM to 8AM local time, Monday - Sunday.
27
+
Maintenance events occur during the default window 5PM to 8AM local time, Monday - Sunday.
28
28
29
29
- question: Users work in a different time zone than the Azure data center. Which time zone is local?
30
30
answer: |
31
31
Local time is determined by the location of Azure region that hosts the resource and may observe daylight saving time in accordance with local time zone definition. It isn't determined by the time zone configured on SQL database (always UTC) or managed instance.
32
32
33
33
- question: Can I choose a specific time/day for the maintenance window?
34
34
answer: |
35
-
No, you can choose between pre-scheduled weekday or weekend windows. The maintenance can happen anytime or day within the window.
35
+
No, you can choose between prescheduled weekday or weekend windows. The maintenance can happen anytime or day within the window.
36
36
37
37
- question: What happens once I choose a maintenance window?
38
38
answer: |
39
-
Configuring maintenance window is a long running asynchronous operation, similar to changing the service tier of your Azure SQL resource. The resource is available during the process, except a short reconfiguration that happens at the end of the operation and typically lasts up to 8 seconds even in case of interrupted long-running transactions. To minimize the impact of the reconfiguration, you should perform the operation outside of the peak hours. For Azure SQL Managed Instance, the IP address of the managed instance will change.
39
+
Configuring maintenance window is a long running asynchronous operation, similar to changing the service tier of your Azure SQL resource. The resource is available during the process, except a short reconfiguration that happens at the end of the operation and typically lasts up to 8 seconds even in case of interrupted long-running transactions. To minimize the impact of the reconfiguration, you should perform the operation outside of the peak hours.
40
40
41
41
- question: What types of updates are typically performed during a maintenance window?
42
42
answer: |
43
-
The maintenance event may contain updates for hardware, firmware, operating system, satellite software components, or the SQL database engine. They're typically combined into a single batch to minimize the incidence of maintenance events. In case of SQL Managed Instance, updates are combined in two batches, one focused on physical infrastructure, and another one focused on SQL engine and logical infrastructure.
43
+
The maintenance event may contain updates for hardware, firmware, operating system, satellite software components, or the SQL database engine. They're typically combined into a single batch to minimize the incidence of maintenance events. In case of SQL Managed Instance, updates are combined in two batches, one focused on physical infrastructure, and another one focused on SQL engine and logical infrastructure. For Azure SQL Managed Instance, the IP address of the SQL managed instance changes.
44
44
45
45
- question: How frequent the updates are?
46
46
answer: |
@@ -104,7 +104,7 @@ sections:
104
104
105
105
- question: Can I configure a different maintenance window for each Azure SQL database in an elastic pool?
106
106
answer: |
107
-
If the database is part of an elastic pool, the maintenance window configuration of the elastic pool will be applied. Single databases outside of an elastic pool can have their own maintenance window configuration.
107
+
If the database is part of an elastic pool, the maintenance window configuration of the elastic pool is applied. Single databases outside of an elastic pool can have their own maintenance window configuration.
108
108
109
109
- question: What are supported options to configure a maintenance window for an existing Azure SQL Database or SQL managed instance?
110
110
answer: |
@@ -120,7 +120,7 @@ sections:
120
120
121
121
- question: I'm not able to set up advance notifications for planned maintenance, will I still see planned maintenance event in Service Health dashboard?
122
122
answer: |
123
-
In case of [Azure SQL Database](sql-database-paas-overview.md), if advance notifications aren't configured, Service Health won't show the planned maintenance events. In case of [Azure SQL Managed Instance](../managed-instance/sql-managed-instance-paas-overview.md), you are able to see planned maintenance event in Service Health dashboard even if advance notifications aren't configured.
123
+
For [Azure SQL Database](sql-database-paas-overview.md), if advance notifications aren't configured, Service Health won't show the planned maintenance events. For [Azure SQL Managed Instance](../managed-instance/sql-managed-instance-paas-overview.md), planned maintenance events are visible in the Service Health dashboard, even if advance notifications aren't configured.
124
124
125
125
- question: Does advance notification cover all maintenance events?
126
126
answer: |
@@ -138,17 +138,17 @@ sections:
138
138
answer: |
139
139
Yes, you can [retrieve the list of impacted resources](advance-notifications.md#retrieve-the-list-of-impacted-resources) by using [Azure Resource Graph Explorer](/azure/governance/resource-graph/overview). You will receive an advance notification email that contains the notification ID and a link to the Azure Resource Graph Explorer.
140
140
141
-
- question: The notification says "In Progress", but window has not started yet?
141
+
- question: The notification says "In Progress", but window hasn't started yet?
142
142
answer: |
143
-
There is a period of 1 hour in which notifications are sent. This means that you can receive notification 25 to 24 hours before the event, 1 hour to 1 minute before the window opens, and 1 minute to 1 hour after the window is closed. Even though the notification title is "In Progress", the content of the notification contains the maintenance window start and end time and that is the moment when maintenance will begin and end.
143
+
There's a period of 1 hour in which notifications are sent. This means that you can receive notification 25 to 24 hours before the event, 1 hour to 1 minute before the window opens, and 1 minute to 1 hour after the window is closed. Even though the notification title is "In Progress", the content of the notification contains the maintenance window start and end time and that is the moment when maintenance will begin and end.
144
144
145
-
- question: Is there a scenario where I do not get notification about planned event?
145
+
- question: Is there a scenario where I don't get notification about planned event?
146
146
answer: |
147
-
Yes, in case that you have created a new resource, executed scaling operation, or changed maintenance window, your database or instance can end up on the machine that is already scheduled for upgrade. In this case, you will be notified only when deployment window starts and ends. For all future deployments, you will get advance notification about planned events.
147
+
Yes, in case that you have created a new resource, executed scaling operation, or changed maintenance window, your database or instance can end up on the machine that is already scheduled for upgrade. In this case, you are notified only when deployment window starts and ends. For all future deployments, you will get advance notification about planned events.
148
148
149
149
- question: Can I check if my instance has been upgraded in the last X days?
150
150
answer: |
151
-
You can check this only if you have configured advanced notifications in the service health. You can use the [Azure Resource Graph Explorer](/azure/governance/resource-graph/overview) to [retrieve a list of maintenance events](maintenance-window.md#retrieving-list-of-maintenance-events), or use the [Service Health overview page](/azure/service-health/service-health-overview).
151
+
You can check this only if you have configured advanced notifications in the service health. You can use the [Azure Resource Graph Explorer](/azure/governance/resource-graph/overview) to [retrieve a list of maintenance events](maintenance-window.md#retrieve-list-of-maintenance-events), or use the [Service Health overview page](/azure/service-health/service-health-overview).
0 commit comments