Tips to resolve deadlock issues in SQL Server

preview_player
Показать описание
Deadlocks are sometimes difficult to fix, some of the activities are required as reactive action but some should be done off business hours.
Example:
Move big tables to separate file group to allow parallel write
Adding missing indexes
Removing unused indexes
#shorts
Рекомендации по теме
Комментарии
Автор

What do you define as a “super transactional table”? Tables with large amount of inserts (logging, large number of rows)?

anthonycartwright