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

Database Training Days 101: SQL Server Performance Tuning to Optimize Cloud Costs with Pinal Dave

SQL Server Performance Tuning to Optimize Cloud Costs
录播
  • 记录日期:May 11, 2022
  • 活动:录播
SQL Server Performance Tuning to Optimize Cloud Costs

Every query has a cost, typically measured through three critical resources: CPU, IO, and memory. When queries are not optimized for the cloud, they often lead to the need for expensive upgrades to cloud subscription models or result in extremely slow query performance. In this session, we will focus on how to tune queries for optimal efficiency when deployed to the cloud, ensuring they run smoothly with limited resources. Developers and DBAs will receive actionable knowledge and scripts to immediately enhance the performance of their slow-running queries.

Topics that will be discussed include:

  • Understanding the cost of queries in terms of CPU, IO, and memory
  • Strategies for optimizing queries for cloud environments
  • Techniques to avoid unnecessary cloud subscription upgrades
  • Practical scripts and tips for immediate performance improvements

Speaker:

  • Pinal Dave, SQL Server Performance Tuning Expert at SQLAuthority.com

观看免费网络直播

请稍候……

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

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