Performance of High Availability and Optimisation Techniques
Whenenever we face any performance issue we can refer related books online article from Microsoft and follow the steps
Please share some related articles to improve the same on amitvaid81@gmail.com
Call/Message/App +91-9711004147
Best Regards
Amit Vaid
https://techcommunity.microsoft.com/t5/sql-server-blog/troubleshooting-high-hadr-sync-commit-wait-type-with-always-on/ba-p/385369
ReplyDeleteTopics & Waitypes
ReplyDeleteSum, int, Joins, HEADERONLY, FILELISTONLY,
AUDIT_GROUPCACHE_LOCK, AUDIT_ON_DEMAND_TARGET_LOCK then, WINDOW_AGGREGATES_MULTIPASS
Pad index, SOS_MEMORY_USAGE_ADJUSTMENT, Huge Tempdb,
raid, DEADLOCK_TASK_SEARCH
Partitioned Table
Common Language Runtime
BROKER_SHUTDOWN
CHECK_SCANNER_MUTEX
BROKER_TRANSMISSION_OBJECT
BROKER_TRANSMISSION_TABLE
FILESTREAM_CHUNKER_INIT
ASYNC_NETWORK_IO
DBCC TRACESTATUS
HKCS_PARALLEL_MIGRATION
Connection to SQL server in jsp
DIRTY_PAGE_TABLE_LOCK
PREEMPTIVE_COM_STRMSEEKANDREAD
PREEMPTIVE_DFSROOTSHARECHECK
SOS_VIRTUALMEMORY_LOW
HADR_BACKUP_BULK_LOCK
HTDELETE
HTMEMO
PREEMPTIVE_DFSLINKHEALTHCHECK
PRINT_ROLLBACK_PROGRESS
PWAIT_HADR_CLUSTER_INTEGRATION