Azure SQL监视资源 [英] Azure SQL Monitoring resource

问题描述

因为命运会有它，我们的DBA今天病了，我们的Azure SQL数据库出现了问题。

是否有任何免费的应用程序可用于监控Azure SQL数据库？我是否可以针对我们的Azure SQL数据库运行查询，看看可能会出现什么问题？

基本上我需要在Azure SQL数据库监控中快速完成速成课程。

感谢您的评论，希望能快速回复。

解决方案

我要寻找的第一个地方是通过Azure SQL数据库的Azure仪表板 - 那里有图表显示资源使用情况与您在定价层上可用的内容。 无论是DTU还是vcore，如果这些资源都是
最大值，那么图表就会显示出来。 这很容易看到。

在Azure中使用的一个很好的工具也是Microsoft Intelligent Insights工具：

https://docs.microsoft.com/en-us/azure/sql-database/sql -database-intelligent-insight

Azure SQL实例还应启用Query Store。 这是一个很好的工具，可以查看任何查询是否比以前更糟糕，并且更改了查询计划。 值得观看视频，但MS文档页面在这里：

https://docs.microsoft.com/en-us/sql/relational-databases/performance/ monitor-by-using-the-store-store？view = sql-server-2017

这种类型的问题确实非常广泛，并且特定于使用它的应用程序，但上面是我如何开始研究SQL性能问题。

所以我希望有所帮助！

谢谢，

马特

So as fate would have it, our DBA is out sick today and we are having issues with our Azure SQL Database.

Are there any free applications that exist to monitor Azure SQL Databases? Are there any queries I can run against our Azure SQL Database to maybe see what might be hosing it up?

Basically I need a crash course quickly in Azure SQL Database monitoring.

Thanks for your review and am hopeful for a quick reply.

解决方案

Hi,

The first place I would look for this is via the Azure dashboard for the Azure SQL database - there are graphs there to show resource usage against what you have available on the pricing tier.  Whether its DTUs or vcore, if those resources are being maxed out then the graphs there will show.  This is quick and easy to see.

A good tool to use in Azure also is the Microsoft Intelligent Insights tool:

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-intelligent-insights

The Azure SQL instance should also have Query Store enabled.  That is a great tool for seeing if any queries are performing worse than they used to and changing query plans.  It would be worth watching a video on this but the MS docs page is here:

https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-2017

This type of question is really very wide ranging and is specific to the application using it, but the above is how I start to look at SQL performance issues.

So I hope that helps!

Thanks,

Matt

这篇关于Azure SQL监视资源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！