Maintenance tasks on Azure SQL Managed instance
I have 4 SQL managed instances and have some custom task defined on SQL Managment Studio. On azure I found that the managed instance have a Maintenance Window:
My question is.. What kind of tasks are performed in the Azure maintenance window?
I only found this about azure maintenance window https://learn.microsoft.com/en-us/azure/azure-sql/database/maintenance-window?view=azuresql, but i want to know list of operations that azure does during this maintenance...
Thanks!
The maintenance window feature provides you with the ability to onboard Azure SQL resource to prescheduled time blocks outside of business hours.
As per this Official Microsoft documentation
These are types of the updates performed during a maintenance window.
- Hardware
- Firmware
- Operating system
- Satellite software components
- SQL Engine
They're typically combined into a single batch to minimize the incidence of maintenance events.
These are some of the approaches and operations involved in the maintenance window:
- Hot patching or dynamic patching to apply updates without restarting the services.
- Maintaining a quorum of database replicas for the high-availability of Azure database infrastructure.
- Uses Automatic Scheduling to prevent updates during region’s peak business hours.
- Analysing database workload patterns to chose the best time for failover resources.
SOURCES:
https://www.sqlshack.com/azure-sql-database-maintenance-window/ by Rajendra Gupta.
- Azure PowerShell command to list all Azure VM SKU Sizes enabled for Confidential Computing Azure ACC
- Create Azure TimerTrigger Durable Function in python
- Azure File Share: Cannot map network drive
- RBAC with bicep
- ADF expression to convert array to comma separated string
- How to get status of Azure machine learning service pipeline run using Rest Api?
- How do I deploy a Nuxt 3 solution to an Azure Node Web App
- Azure Blob Upload not working in ASP .Net Core Application
- How to clear a Cosmos DB database or delete all items using Azure portal
- Using script commands, how to add multiple scale rules to an Azure Container App?
- User Assigned Managed Identity: No User Assigned or Delegated Managed Identity found for specified ClientId/ResourceId/PrincipalId
- Generate resources dynamically from another group of dynamically generated resources in Terraform
- Column reordering in ADF
- Logic App AuthorizationFailure - vnet integration needed
- Azure blob, controlling filename on download
- Azure VNet peering with Private Link
- Get Private FQDNs, IPs, Names of the Private Endpoints for the Azure resources deployed in an Virtual Network using PowerShell Script
- How to configure appsettings on a auto-generated preview environment
- Using Azure DevOps, how do I migrate a release pipeline to code, similar to build pipeline yml?
- Root login Ubuntu VM on Azure
- Filtering azure devops release build based upon build tag with "Continuous deployment trigger"
- Azure WebApp autoscale
- How to handle long startup times in Azure App Service deployment
- Frontend not available when front and back on same Web App Azure
- Use Salesforce Connectors from Hosted Azure Logic App in VSCode?
- What is considered an ingestion request in Azure Data Explorer?
- Provisioning (SCIM) by Entra/Azure: Why can I not select the "groups" attribute in my attribute mapping?
- Azure function verbose trace logging to Application Insights
- Azure function app GraphServiceClient create list
- Cypress tests fail to run in parallel mode due to mismatched specs between different runs