问题描述
我们在Azure SQL数据库上有一些要监视的指标，但是不再显示.例如.我们正在查看DTU百分比以查看数据库的性能，但是无论我们发送什么查询，DTU百分比仍为0:
We have some metrics on our Azure SQL database that we want to monitor, but they do not appear anymore. E.g. we are looking at the DTU percentage to see how the database performs, but whatever queries we send, the DTU percentage remains 0:
我们知道我们过去曾看过指标，但不记得它们何时消失.
We know we have seen metrics in the past, but cannot remember when they disappeared.
我们已经在Twitter上与AzureSupport联系，他们提供了指向以下内容的链接 Azure文档，但是在我们的数据库上启用诊断"并不能解决我们的问题.
We already had contact with AzureSupport on Twitter and they provided a link toAzure docs, but turning on Diagnostics on our database doesn't fix our problem.
奇怪的是，当我查看另一个订阅时，我仍然有指标.
The strange thing is, that, when I look at another subscription, I do still have metrics.
任何人都知道可能是什么问题?
Anyone has an idea what can be the problem?
预先感谢您的帮助.
推荐答案
您在sys.resource_stats系统视图上是否看到相同的行为?
Do you see the same behavior on the sys.resource_stats system view?
选择数据库名称，AVG(avg_cpu_percent)AS平均_计算利用率
SELECT database_name, AVG(avg_cpu_percent) AS Average_Compute_Utilization
FROM sys.resource_stats
FROM sys.resource_stats
@ s和@e 之间的开始时间
WHERE start_time BETWEEN @s AND @e
按数据库名分组
我比DTU图更信任DMV有关资源消耗.
GROUP BY database_name
I prefer to trust the DMV about resource consumption than the DTU graph.
希望这会有所帮助.
Hope this helps.
问候
Regards,
阿尔贝托·莫里洛
Alberto Morillo
SQLCoffee.com
这篇关于指标不再显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！