指标不再显示 [英] Metrics are not showing up anymore

问题描述

我们在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 to Azure 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?

预先感谢您的帮助.

推荐答案

Hello,

Do you see the same behavior on the sys.resource_stats system view?

SELECT database_name, AVG(avg_cpu_percent) AS Average_Compute_Utilization  

FROM sys.resource_stats  

WHERE start_time BETWEEN @s AND @e 

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

这篇关于指标不再显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！