SQL Server Concurrency

If you've designed your SQL code intelligently, and implemented a sensible indexing strategy, there's a good chance your queries will "fly", when tested in isolation. In the real world, however, where multiple processes can access the same data at the same time, SQL Server often has to make one process wait, sacrificing concurrency and performance, in order that in order that all can succeed, without destroying data integrity. Transactions are at the heart of concurrency. I explain their ACID properties, the transaction isolation levels that dictate the acceptable behaviors when multiple transactions access the same data simultaneously, and SQL Server's optimistic and pessimistic models for mediating concurrent access. Pessimistic concurrency, SQL Server's default, uses locks to avoid concurrency problems. I explain all the different locks and their compatibility. I show how to control locking with hints and bound connections, and how to troubleshoot excessive blocking and deadlocking. Optimistic concurrency uses row versions to support concurrency.
I explain how row versioning works, cover SQL Server's two Snapshot-based isolation levels and offer troubleshooting tips for issues such as update conflicts. Your application can have world-class indexes and queries, but they won't help you if you can't get your data, because another application has it locked. That's why every DBA and developer must understand SQL Server concurrency, and how to troubleshoot any issues. I hope my book helps!

Portrait
Kalen Delaney ist Mitherausgeberin und Kolumnistin für das SQL Server Magazine und hat erfolgreiche Bücher zu SQL Server verfasst.
… weiterlesen
In den Warenkorb
Filialabholung

Versandkostenfrei

Beschreibung

Produktdetails


Einband Taschenbuch
Seitenzahl 202
Erscheinungsdatum 01.09.2012
Sprache Englisch
ISBN 978-1-906434-91-5
Verlag Red Gate Books
Maße (L/B/H) 23,3/18,7/1,7 cm
Gewicht 361 g
Buch (Taschenbuch, Englisch)
23,99
inkl. gesetzl. MwSt.
Versandfertig in 1 - 2 Wochen
Versandkostenfrei
In den Warenkorb
Filialabholung

Versandkostenfrei

Ihr Feedback zur Seite
Haben Sie alle relevanten Informationen erhalten?
Vielen Dank für Ihr Feedback!
Entschuldigung, beim Absenden Ihres Feedbacks ist ein Fehler passiert. Bitte versuchen Sie es erneut.

Andere Kunden interessierten sich auch für

Wird oft zusammen gekauft

SQL Server Concurrency

SQL Server Concurrency

von Kalen Delaney
Buch (Taschenbuch)
23,99
+
=
SQL Server Transaction Log Management

SQL Server Transaction Log Management

von Gail Shaw, Tony Davis
Buch (Taschenbuch)
26,99
+
=

für

50,98

inkl. gesetzl. MwSt.

Alle kaufen

Kundenbewertungen

Es wurden noch keine Bewertungen geschrieben.