如需獲得最佳網頁瀏覽體驗,請使用 IE 11 或更高版本、Chrome、Firefox 或 Safari。

Database Training Days 201: How to Out-Index a Deadly Blocking Scenario with Kenra Little and Jason Hall

 DBA vs Deadlock: How to Out-Index a Deadly Blocking Scenario
录播
  • 记录日期:Jun. 14, 2018
  • 活动:录播
 DBA vs Deadlock: How to Out-Index a Deadly Blocking Scenario

Deadlocks strike fear into the hearts of even seasoned DBAs—but they don't have to! In this session, you'll be provided with the code to create a sample deadlock in SQL Server. You'll learn how to interpret the deadlock graph to pinpoint where the conflict occurs, and how to design an index to eliminate the deadlock. By the end of the session, you'll have the confidence and knowledge to tackle future deadlocks effectively.

Topics that will be discussed include:

  • Creating and analyzing a sample deadlock in SQL Server
  • Interpreting the deadlock graph to identify conflict points
  • Designing indexes to resolve and prevent deadlocks
  • Practical steps for confidently addressing future deadlocks

Speakers:

  • Jason Hall, SQL Server Expert
  • Kendra Little, SQL Server Expert

学习内容纲要

观看免费网络直播

请稍候……

triangle-down check
进行下载即表示您注册以接收我们发送的营销电子邮件。要选择不再接收,请按照我们隐私政策中描述的步骤进行操作。

reCAPTCHA为此站点提供保护。请查看Google的隐私政策使用条款