When were the last 3 Azure SQL database patches applied?

Question

I would like to find out when the last 3 Azure SQL database patches were applied since our connected application had issues for the last 3 weeks. Would you please let me know? Thanks!

Answer 1

Hi Junhui Ma,
Azure SQL Database is a fully managed PaaS service, and all OS and SQL engine patching is handled automatically by Microsoft. The service does not expose a patch history or the exact timestamps for the “last 3 patches applied” for an individual database.

To check whether platform maintenance may align with your application issues over the past 3 weeks, you can correlate the timeframe using the following supported options:

• Resource Health: Review health history for the SQL Database to identify any platform-impacting events.
  https://learn.microsoft.com/azure/service-health/resource-health-overview Service Health: Check Planned Maintenance and Health history for Azure SQL Database in your region.
  https://learn.microsoft.com/azure/service-health/service-health-overview Activity Log: Review the logical SQL server’s Activity Log for maintenance or failover-related operations during the impacted period.
  https://learn.microsoft.com/azure/azure-monitor/essentials/activity-log
  • Optional: You can query recent failover or connectivity-related events using:

        SELECT TOP 50 * FROM sys.event_log ORDER BY start_time DESC;
    

    This view does not provide patch details and has limited retention but may help identify recent disruptions.) There is no direct method to retrieve the last 3 Azure SQL Database patch dates. The supported approach is to correlate your issue timeframe with Resource Health, Service Health, and related logs to determine any maintenance impact.
    Hope this helps. If you have any follow-up questions, please let me know. I would be happy to help. Please do not forget to "Accept Answer" and "up-vote" wherever the information provided helps you, as this can be beneficial to other community members.

Answer 2

For Azure SQL Database, patching is managed by the platform and individual database patch dates are not exposed directly. The only supported way to see when maintenance (including upgrades/patches) occurred is via maintenance events, and that is only possible if advanced notifications were configured beforehand.

To check whether the database has been upgraded or undergone maintenance in the last weeks:

1. Ensure advanced notifications are configured in Azure Service Health for the subscription that hosts the Azure SQL Database.
2. Use one of the following:
   • Azure Resource Graph Explorer to retrieve a list of maintenance events for Azure SQL Database resources, as described in the maintenance window documentation.
   • The Service Health overview page in the Azure portal to review past maintenance events and their timestamps.

These maintenance events will show when platform maintenance (which includes patching/upgrade operations) was applied. Without previously configured notifications and corresponding logged events, the exact dates of the last three patches for a specific Azure SQL Database cannot be retrieved.

---

References:

• Maintenance window FAQ in Azure SQL Database