Pozor, nahajate se na testni strani. Informacije, ki so na voljo na spetnem mestu, niso uradne in niso uporabne, vprašljiva pa je tudi njihova verodostojnost.

Ta spletna stran hrani piškotke, da bi vam zagotovili boljšo uporabniško izkušnjo in popolno funkcionalnost te strani.

Analitične piškotke uporabljamo s storitvijo Google Analytics, samo z vašo privolitvijo. Sprejemam Zavrnitev Več informacij

SQL Server 2025 Optimized Locking

Predavanje je v angleškem jeziku.

Introduced in SQL Server 2025, optimized locking improves transaction locking mechanism to reduce lock blocking and lock memory consumption for concurrent transactions. It's composed of two primary components: transaction ID (TID) locking and lock after qualification (LAQ). In this session, we'll look into how this works and how we can use it to improve our server's locking concurrency.

Mladen Prajdić

Mladen Prajdic s.p.

Mladen Prajdić is a Data Platform MVP from Slovenia. He's been programming for 20 years, developing different types of applications in .Net (C#), SQL Server, and Swift, ranging from standard line-of-business image-processing applications to high-performance and IoT applications. He's a regular speaker at various conferences and user group meetings and really likes optimizing slow SQL statements, analyzing performance, and finding unconventional solutions to complex SQL Server problems. In his free time, he also develops a very popular add-in for SSMS, called the SSMS Tools Pack (www.ssmstoolspack.com).

Komentiranje v NTK aplikaciji je mogoče za potrjene udeležence NT konference.

iPhone Android