SQL数据库运行非常非常慢 [英] SQL Database is running very, very slowly
问题描述
我的客户端有一个在Azure上运行的网站,其背后是一个Azure SQL数据库.我们被要求提供帮助,因为我的客户没有Azure技能.今天的数据库非常.非常慢.没有明显的活动.但是查询性能洞察"页面只是 说正在加载"如果这是本地SQL服务器,我们将停止并重新启动SQL服务.我们如何在Azure中停止/启动SQL服务.
My client has a web site running on Azure with an Azure SQL Database behind it. We have been asked to help as my clietn has no Azure skills. Today the database is very. very slow. There is no obvious activity. But the Query Performance Insight page just says "Loading" If this was an on-premises SQL server we would stop and restart the SQL service. How can we stop/start the SQL service in Azure.
谢谢
Gavin Dixon
Gavin Dixon
推荐答案
Hello,
等待24小时启用该功能,如果一天后仍然显示正在加载,请创建支持票证.我的建议来自
我们在以下论坛主题上与另一位客户的经验:
Wait 24 hours after enabling the feature, if after a day it still says loading please create a support ticket. My suggestion comes from
the experience we had with another customer on the following forum thread:
https://social.msdn.microsoft.com/Forums/azure/en-US/56a838cf-95e0-4f54-8a16-f3b06c743b59/query-performance-insight-never-loads?forum=ssdsgetstarted
另外,您可以利用查询存储来识别性能不佳的查询.
Alternatively, you can make use of Query store to identify queries with bad performance.
http://www.sqlcoffee.com/Azure_0010.htm
您还可以使用以下查询来监视资源消耗,以确定是否需要扩展数据库.当数据库达到DTU限制时
可能会出现节流.
http://www.sqlcoffee.com/Azure_0010.htm
You can also monitor resource consumption with the following query to determine if you need to scale up the database. When the database is reaching the DTU limit
throttling may occur.
SELECT
SELECT
(COUNT(end_time )-SUM(在avg_cpu_percent> 80 THEN 1 ELSE 0 END的情况下)* 1.0)/COUNT(end_time)AS'CPU Fit Percent',
(COUNT(end_time )-SUM(当avg_log_write_percent> 80 THEN 1 ELSE 0 END时的情况)* 1.0)/COUNT(end_time)AS'Log Write Fit Percent',
(COUNT(end_time )-SUM(当avg_data_io_percent> 80 THEN 1 ELSE 0 END时的情况)* 1.0)/COUNT(end_time)AS'物理数据读取适合百分比'
FROM sys.dm_db_resource_stats
希望这会有所帮助.
Hope this helps.
问候
Regards,
Alberto Morillo
SQLCoffee.com
Alberto Morillo
SQLCoffee.com
这篇关于SQL数据库运行非常非常慢的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!