Date: 26th Mar 2009
Topic: Performance 101 Part 2 of 5: Optimizing Transaction Concurrency
Synopsis:
This month, we will be continuing our series on optimizing SQL Server performance zooming into – transaction concurrency.
Ever wonder why sometimes without modifying something your database performance becomes very slow? Or you encounter errors during peak hours of usage and things seems to fix itself after a while? If you are experiencing these problems, then chances are, you are having concurrency issues in your database.
First we will be looking into tools that will help us confirm if we indeed have concurrency problems. Tools such as SQL Profiler, Activity Monitor and Performance Monitor usually gives us a holistic view on SQL Server performance. After we have learn how to monitor concurrency issues, then we’ll be looking into ways and means on how we can address these issues ensuring that transactions doesn’t block each other.
Slide Deck:
Direct Link to Video: Click Here
/Dennis
