When Network Infrastructure Throttles SQL Server (Analyzing HADR_SYNC_COMMIT)
by Michal Kovaľ on 22/07/2021We recently resolved a critical performance issue where a client reported an unusual spike in HADR_SYNC_COMMIT wait types.
Read moreWoodler is only dedicated company in CZ/SK region specializing directly on performance tuning and root cause analysis for SQL Servers.
Contact: Office@woodler.eu
Michal Tinthofer is the face of the Woodler company which (as he does), is fully committed to complete support of Microsoft SQL Server products to its customers. He often acts as a database architect, performance tuner, administrator, SQL Server monitoring developer (Woodler SMT) and, last but not least, a trainer of people who are developing their skills in this area. His current "Quest" is to help admins and developers to quickly and accurately identify issues related to their work and SQL Server runtime.
We recently resolved a critical performance issue where a client reported an unusual spike in HADR_SYNC_COMMIT wait types.
Read moreAfter some time, we have finally released big set of changes and fixes for currently known issues. Most visible is new Waiting Task report for operational analysis, added timeline button for Index Usage & recommendation, new functionality to search for an
Read moreI think there is more simple and harmless way. First we need to understand the process of tempdb collation setting.
Read more