This video from John Sterrett shows you how to create a deadlock and how you can proactively monitor deadlocks using the default system_health extended event.
Get the ultimate tool suite for cross-platform database management
Embarcadero DB PowerStudio, a suite of award-winning database tools for DBAs and data professionals, uniquely offers comprehensive administration, development and performance tuning capabilities across all major database platforms which dramatically increases productivity, boosts database performance and improves availability.
I thought the session is really good and helps in understanding dead locks but the big problem is that none of the Powerstudio tools were used but instead MS SQL Management studio was. Can someone explain to me why ?
Please login first in order for you to submit comments
Page :
1
Check out more tips and tricks in this development video:
I thought the session is really good and helps in understanding dead locks but the big problem is that none of the Powerstudio tools were used but instead MS SQL Management studio was. Can someone explain to me why ?