تفاصيل الكتاب
تنسيق
كيندل
صفحات
202
لغة
الإنجليزية
منشور
May 23, 2013
الناشر
Red Gate Books
الوصف
Multiple processes often access the same data at the same time, so SQL Server has to make one process wait, sacrificing concurrency and performance.This book explores how SQL Server uses locks to avoid concurrency problems, and advice on the to control locking with hints and bound connections. It also walks you through how row versioning works, and how to troubleshoot excessive blocking and deadlocking.