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

Database Training Days 101: SQL Server Performance Tuning Hints & Tricks with Andy Warren

SQL Server Performance Tuning Hints & Tricks
录播
  • 记录日期:Jan. 29, 2020
  • 活动:录播
SQL Server Performance Tuning Hints & Tricks

Do you need to fix slow queries, blocking, or deadlocks? Are you dealing with a slow server? When you don’t have a lot of experience in Microsoft SQL Server query tuning, it can be extremely frustrating. There’s so much to consider: locking, disk IO, statistics, caching, query plans, indexes, and more. But you don't have to know everything to make a query go faster! In this on-demand query tuning webcast, you’ll learn a set of steps to detect and fix the most common Microsoft SQL Server performance issues. We'll discuss how to figure out where to start, what is worth more effort and what isn't, common patterns and anti-patterns, and what to measure. You’ll also learn a few advanced strategies that go beyond pure query tuning, such as offloading queries to a replica and encouraging developers to cache more. With these expert tips, you’ll simplify your work—and take SQL Server performance to the next level.

Topics that will be discussed include:

  • Step-by-step process for detecting and fixing common SQL Server performance issues
  • Identifying and addressing locking, disk IO, and query plan problems
  • Deciding which issues are worth your time and which aren't
  • Exploring advanced strategies, including offloading queries and caching
  • Practical examples of common patterns and anti-patterns in query tuning

Speaker:

  • Andy Warren, SQL Server Consultant and MVP at SQLServerCentral.com

观看免费网络直播

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

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