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 moreDear friends,
I would like to say thank you for attending my presentations on this year ShowIT. It was a pleasure to meet you again in this wonderful conference. I hope my sessions was informative and helpful at least as in past years.
My sessions:
Resolving usual issues with database model and configuration.
In this presentation we will discuss what to check in your existing database configuration and its model to prevent data loss and keep meaningful performance. I will also propose solutions for them. Usual audience are beginner DBAs and advanced db developers.
SQL Server memory configuration monitoring, management and troubleshooting overview.
In this session I will explain basics of memory configuration, monitoring and management tasks which should be (in my opinion) taken by admin.
Also, we will have a look on troubleshooting suboptimal situations found in monitoring. All DBAs will find something new in this presentation.
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 moreRecently I had some issues with SQL server 2008 R2 service pack 1 installation. From first perspective it looks like an issue with corrupted installation package, but true issue was somewhere else. It was a windows installer.
Read more