LATCH_EX Waits
by Michal Kovaľ on 27/04/2022Recently we had a request to optimize LATCH_EX waits on one of the production servers for our customer. Today I would like to share with you our apporach and how we handled the situation.
Read moreWe would like to wish you a pleasant time and oportunity to slow down and enjoy the simple things. May this wonderful time of the year touch your heart in a special way. Wishing you much happiness not just today, but throughout the New Year.
This time we are bringing a special patch with new features such a tuning tnotes where you can record all your tunning efforts and explore it's benefits through new tuning dashboard. Also we introduce new reports for tempdb contention issues and updated resource governor and memory reports for better visibility and performance.
We hope you will continue to enjoy our tool!
With regards,
Michal Tinthofer.
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.
Recently we had a request to optimize LATCH_EX waits on one of the production servers for our customer. Today I would like to share with you our apporach and how we handled the situation.
Read moreLast week we attended SQLBits in London - not as sponsors this time, but as curious and enthusiastic attendees.
Read moreSMT Waits reports – handy overview of what is going on at the server
Read more