MS-SQL Server - Ambiguous, ASYNC_NETWORK_IO, XIO_EDS_RWLOCK, HADR_AR_UNLOAD_COMPLETED

Ambiguous, ASYNC_NETWORK_IO, XIO_EDS_RWLOCK, HADR_AR_UNLOAD_COMPLETED

Ambiguous Column Name

https://community.fabric.microsoft.com/t5/Issues/SQL-compilation-error-ambiguous-column-name/idi-p/865636

Occurs on network writes when the task is blocked waiting for the client application to acknowledge that it has processed all the data sent to it. Verify that the client application is processing data from the server as fast as possible or that no network delays exist. Reasons the client application can't consume data fast enough include: application design issues like writing results to a file while the results arrive, waiting for user input, client-side filtering on a large dataset instead of server-side filtering, or an intentional wait introduced. Also the client computer might be experiencing slow response due to issues like low virtual/physical memory, 100% CPU consumption, etc. Network delays can also lead to this wait - typically caused by network adapter driver issues, filter drivers, firewalls, or misconfigured routers.

I wish I could utilise the time for SQL, the time I spent in typing institute.

Additionally,

{,Having PWAIT_HADRSIM COLUMNSTORE_BUILD_THROTTLE

DTC_STATE HADR_TIMER_TASK

FS_LOGTRUNC_RWLOCK,}

Any query will be considered.

T. Amit Vaid S.