Interestingly, I could see below.Īutomatic seeding of availability database ‘PROD_HRMS_DB’ in availability group ‘PRODUCTION_AG’ failed with a transient error. Looking at those SPIDs we observed their start time in sysprocesses and then I looked further in ERRORLOG for the same timings. All I observed is that wait type was increasing for VDI_CLIENT_WORKER and then it changes to VDI_CLIENT_OTHER. When I was looking at the CPU and IO for this SPID, it was not increasing. As per them, they must restart the instance to get rid of them but after few hours, it appears again.

Recently one of my clients showed me many background threads having wait type VDI_CLIENT_WORKER. SQL SERVER – Introduction to Wait Stats and Wait Types – Wait Type – Day 1 of 28 In this blog, we would learn about VDI_CLIENT_WORKER / VDI_CLIENT_OTHER wait type. I have already written about most common wait types earlier.

There are so many wait types available in SQL Server and sometimes I feel that it’s an ocean of wait types.

Sql server vdi and compression tde