且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

阈值Azure SQL数据库。

更新时间:2023-02-02 20:01:36

嗨  Raghavendra,


不幸的是,这没有真正的答案,因为它取决于您的数据库工作负载。 你需要看看基线数据是什么,看看有什么不寻常的。 


就个人而言,在大多数情况下,我想知道DTU或CPU是否超过80%。  但是如果你的工作量经常超过这个时间段然后再次下降,那么我不希望一直得到关于此的通知。 


因此,您需要了解平台上的常用用法,并将其作为基础。


谢谢,


马特


Hi Experts,

I wanted to know what is the Threshold values for DTU , CPU and database size percentage and disk IO percentage for Azure SQL Database for monitoring.

Please suggest any blogs or threshold values recommended by MS.

Thanks 

Raghavendra


Thanks & Regards Raghavendra Petla

Hi Raghavendra,

Unfortunately, there is no real answer to this as it depends on your database workload.  You need to see what the baseline figures are to see what would be unusual to have. 

Personally, under most circumstances I would want to know if DTUs or CPU went over 80%.  But if your workload often goes above this for a period and then drops down again then I wouldn't want to be notified about this all the time. 

So you need to see what usual usage looks like on your platform and base it off that.

Thanks,

Matt