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 moreFor those who don't know ShowIT, it is the major technology presentation event in Slovak Republic organised by Gopas company. For registration and more info please visit their page.
I will have a two three sessions in Data Hall.
UPDATE:
We have been asked to present another session. So we decided to come with another session.
Tuesday 13:50 - 14:20
We will try share our vision how to correcty aproach RCA process for SQL Server issues.
Tuesday 17:20 - 18:30
If you ever wondering how to use resource governor effectively this presentation will help you understand not only concepts, but also real-life usage and configuration. This will help you how to effectively fragment SQL Server resources internally.
Thursday 14:40 - 15:50
On this session I will present how to effctivelly use resources and licenses of SQL Server to make centralised highly available solution for database engine, analysis services and reporting services all together.
Looking forward to see you there.
With Regards,
Michal.
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 moreWe would like to inform you in this form of an important event (about which you may already know yourself). It also applies to the security of your SQL Servers. We think we should have this initiative from our side.
Read more