Azure SQL无服务器层永远不会关闭 [英] Azure SQL Serverless tier never shuts down

问题描述

我正在尝试使用Azure SQL的无服务器层，但是数据库从未休眠，因为Azure似乎在不断地在后台查询数据库。我通过和ARM模板创建了数据库。

I'm experimenting with the Serverless tier in Azure SQL, but the database never "sleeps" because it seems that Azure is continually querying the database behind the scenes. I created the database via and ARM template.

数据库概述上的计算利用率和应用CPU计费图表表明，该数据库经常被命中（甚至尽管我自己也没有进行任何查询）。 查询性能洞察中的热门查询为：

The "Compute utilisation" and "App CPU Billed" charts on the database overview show that the database is being hit regularly (even though I am not making any queries myself). The Top queries in "Query Performance Insight" are:

(@ip_address_value bigint,@start_ip varchar(45))SELECT top 1 @start_ip = start_ip_address_value FROM sys.database_firewall_rules_table WHERE @ip_address_value BETWEEN start_ip_address_value AND end_ip_address_value OPTION (MAXDOP 1)

并且

(@ip_address_value bigint,@start_ip varchar(45))SELECT top 1 @start_ip = start_ip_address_value FROM sys.database_firewall_rules_table WHERE @ip_address_value BETWEEN start_ip_address_value AND end_ip_address_value AND start_ip_address_value > 0 OPTION (MAXDOP 1)

似乎来自防火墙。我是否必须禁用防火墙或删除所有规则以允许数据库休眠？

Which seem to be from the firewall. Do I have to disable the firewall or delete all the rules to allow the database to "sleep"?

推荐答案

我想在这里发布我的案例，我的应用没有调用数据库，而且我仍然看到这些调用，我发现这是数据库备份。
我可以在以下位置查看查询：Azure >> YourDatabase >>左侧菜单，搜索Query Performance Insights >>您将看到对数据库进行的调用。

I would like to post my case here, my app was not calling the database and I still seeing those calls as well, I figured out that it was the database backup. I could see the queries in: Azure >> YourDatabase >> Left Menu, search for Query Performance Insights >> You will see the calls that was done to your database.

显示菜单和数据库查询的图像

这篇关于Azure SQL无服务器层永远不会关闭的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！