问题描述
我们正在使用不同规模的Azure SQL数据库对我们的应用程序进行基准测试，并且很难使数据库饱和.除其他外，我们执行了以下查询:
We're benchmarking our app with different scales of an Azure SQL database, and we're having a hard time saturating the db. Among other things, we've executed this query:
SELECT *
FROM sys.dm_os_wait_stats
ORDER BY wait_time_ms DESC
结果的第一行类似于
wait_type waiting_tasks_count wait_time_ms max_wait_time_ms signal_wait_time_ms
VDI_CLIENT_OTHER 19560 409007428 60016 37281
这是什么等待时间?在这409000秒(近5天)内，我们到底在等待什么? Google似乎不知道VDI_CLIENT_OTHER是什么.
What is this wait time? What exactly have we been waiting for during those 409000 seconds (almost 5 days)? Google doesn't seem to know what VDI_CLIENT_OTHER is.
推荐答案
VDI_CLIENT_OTHER用于新副本播种或触发复制之类的任何其他用户启动的工作流(如更新服务层和设置地理关系链接)的情况.漫长的等待时间这很可能意味着我们做了播种，任务仍在运行，等待其他尚未到达的工作项目.
VDI_CLIENT_OTHER is used in case of new replica seeding or any other user initiated workflow that triggers copies like update service tier and setting up geo relationship link. High wait time It likely just means we did seeding and the task remained running waiting for additional work items which aren’t arriving.
这篇关于"VDI_CLIENT_OTHER"上的Azure SQL高等待时间；的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！