SolarWinds Database Performance Analyzer can collect a count of the number of deadlocks to be displayed as a resource graph. For Ignite versions prior to 8.2, you can update two files in order to start collecting the number of deadlocks. Enabling DPA to Collect Deadlock Information The code below takes advantage of the system_health extended […]
Read More
In Part 1 of this article series on optimizing transactional performance of MySQL databases, we explored the importance of keeping transactions small, and in part 2, we discussed selecting appropriate isolation levels. No discussion of transactional performance is complete without a brief look at deadlocks. If you’re familiar with OS programming, you might already know […]
Read More
A SQL Server deadlock is a special concurrency problem in which two transactions block the progress of each other. Learn more.
Read More
If SQL Server locking isn’t used, and no isolation exists between transactions, you may have concurrency problems such as lost updates, dirty reads, nonrepeatable reads and phantoms. Learn more.
Read More
The SQL Server DMV sys.dm_tran_locks returns information about currently active lock manager resources. Learn more.
Read More
SQL Server lock granularity specifies which resource is locked by a single lock attempt. Lock granularity affects concurrency. In general, the more granular the lock, the more concurrency is reduced. Learn more.
Read More
Lock modes specify different kinds of locks. The choice of which lock mode to apply depends on the resource that needs to be locked. Learn more.
Read More
Every DBMS has mechanisms that control the access of data by all users at the same time. The SQL Server Database Engine uses locks to guarantee the consistency of the database. Learn more.
Read More
Higher than normal wait stats does not in and of itself indicate a contention problem. You should look for the proportion of wait stats compared to others, and compare this to the throughput being achieved.
Read More
It’s important to recognize SQL Server latch and spinlock contention, and to be able to measure contention to determine the best possible tuning.
Read More
When more than 5,000 locks are taken out on the rows or pages of a particular table within a single T-SQL statement, lock escalation is triggered. Understanding lock escalation can help you in performance tuning.
Read More
The performance impact of database locks can be substantial. Learn best practices for detecting and resolving these blocking scenarios quickly.
Read More