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 hope you're doing well and we would like to announce next SMT changes,
We are about 75% done with a roll out of the recently released version SMT 1.0 to our clients but in the meantime, we have also worked on the new features and enhancements.
The new release SMT 1.1 just passed final testing on our stage environment and will be made available in upcoming days to all instances with preceding SMT version (1.0).
The changes in this release consists of the following;
This will be the first release that will be done automatically through SMT-CORE by the daily overnight process. It works in a pull mode, so nothing is pushed to instances, but the instance will get the changes with next regular synchronisation. This has been something that we have been working on for some time and is finally ready to be used.
Do not hesitate to contact us in case you have any questions, also any feedback on the changes is appreciated.
For the SMT team,
Jiri Dolezalek & 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 moreNew version of our SQL Monitoring and Performance Tuning tool ready right in the middle of the year
Read more