问题描述
我为Azure DW尝试了放大功能(提高DWU).我发现当前会话已断开连接.
I tried the scale up feature (raise the DWU) for my Azure DW. I find the current session is disconnected.
并且似乎需要花费超过一分钟的时间(看来，用于提高DWU的MSDN SLA应该小于< 1分钟)
and it's seems takes more than a minutes to rasise (seems the MSDN SLA for raising the DWU should be < 1 mins)
我收到以下错误，但是我确实没有暂停服务器.我正在使用DW Gen1
I got the below error, but I really didn't pause the server. I am using DW Gen1
推荐答案
请记住，扩展操作类似于SQL引擎重新启动. 如果存在未清事务，则需要在实例脱机之前对它们进行对帐.这会影响扩展过程所需的时间.
Keep in mind that a scaling operation is similar to a SQL engine restart. If there are open transactions, they need to be reconciled before the instance goes offline. That has an impact on the time the scaling process takes to complete.
希望这会有所帮助.
问候
Regards,
阿尔贝托·莫里洛
Alberto Morillo
SQLCoffee.com
这篇关于扩大规模时的停机时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！