MS-SQL Server - Sync & ASYNC_NETWORK_IO Waittype

Sync & ASYNC_NETWORK_IO Waittype.

Sync

https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-sql-server-configure?view=azuresql

ASYNC_NETWORK_IO

Occurs on network writes when the task is blocked waiting for the client application to acknowledge 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 may 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.

ASYNC_DISKPOOL_LOCK

Occurs when there is an attempt to synchronize parallel threads that are performing tasks such as creating or initializing a file.

DUMP_LOG_COORDINATOR

Occurs when a main task is waiting for a subtask to generate data. Ordinarily, this state doesn't occur. A long wait indicates an unexpected blockage. The subtask should be investigated.

AUDIT_ON_DEMAND_TARGET_LOCK

Occurs when there is a wait on a lock that is used to ensure single initialization of audit related Extended Event targets.

IAM and Related Corruptions

https://techcommunity.microsoft.com/t5/sql-server-support-blog/sql-server-extents-pfs-gam-sgam-and-iam-and-related-corruptions/ba-p/1606011

SQL Server - 2016

https://www.microsoft.com/en-in/sql-server/sql-server-2016

https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2016

Unique Clustered Index & Primary Keys

https://learn.microsoft.com/en-us/sql/relational-databases/indexes/create-clustered-indexes?view=sql-server-ver16

Primary Keys

https://learn.microsoft.com/en-us/sql/relational-databases/tables/create-primary-keys?view=sql-server-ver16

View

https://learn.microsoft.com/en-us/sql/relational-databases/views/views?view=sql-server-ver16

Antivirus exclusions

https://learn.microsoft.com/en-us/troubleshoot/system-center/scom/antivirus-exclusions-recommendations

Partition Over

https://learn.microsoft.com/en-us/sql/t-sql/queries/select-over-clause-transact-sql?view=sql-server-ver16

Group By Clause

https://learn.microsoft.com/en-us/sql/t-sql/queries/select-group-by-transact-sql?view=sql-server-ver16

Logical and Physical Architecture

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/92341a0f-11f4-4c5b-8a3f-72ff0262ca49/what-is-the-logical-and-physical-architecture-of-sql-server-2008?forum=sqldocumentation

Publish Data over the Internet Using Virtual Private Network

https://learn.microsoft.com/en-us/sql/relational-databases/replication/publish-data-over-the-internet-using-vpn?view=sql-server-ver16

How Extended Stored Procedures Work

https://learn.microsoft.com/en-us/sql/relational-databases/extended-stored-procedures-programming/how-extended-stored-procedures-work?view=sql-server-ver16

Answer in Brief for Bandwidth

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-user-connections-server-configuration-option?view=sql-server-ver16

Best Regards

T. Amit Vaid S.