SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques
暫譯: SQL Server 高級故障排除與性能調優:最佳實踐與技術
Korotkevitch, Dmitri
買這商品的人也買了...
-
$704計算機網絡, 6/e
商品描述
This practical book provides a comprehensive overview of troubleshooting and performance tuning best practices for Microsoft SQL Server. Database engineers, including database developers and administrators, will learn how to identify performance issues, troubleshoot the system in a holistic fashion, and properly prioritize tuning efforts to attain the best system performance possible.
Author Dmitri Korotkevitch, Microsoft Data Platform MVP and Microsoft Certified Master (MCM), explains the interdependencies between SQL Server database components. You'll learn how to quickly diagnose your system and discover the root cause of any issue. Techniques in this book are compatible with all versions of SQL Server and cover both on-premises and cloud-based SQL Server installations.
- Discover how performance issues present themselves in SQL Server
- Learn about SQL Server diagnostic tools, methods, and technologies
- Perform health checks on SQL Server installations
- Learn the dependencies between SQL Server components
- Tune SQL Server to improve performance and reduce bottlenecks
- Detect poorly optimized queries and inefficiencies in query execution plans
- Find inefficient indexes and common database design issues
- Use these techniques with Microsoft Azure SQL databases, Azure SQL Managed Instances, and Amazon RDS for SQL Server
商品描述(中文翻譯)
這本實用的書籍提供了 Microsoft SQL Server 故障排除和性能調優最佳實踐的全面概述。資料庫工程師,包括資料庫開發人員和管理員,將學習如何識別性能問題、以整體方式排除系統故障,並正確優先考慮調優工作,以達到最佳的系統性能。
作者 Dmitri Korotkevitch,Microsoft 數據平台 MVP 和 Microsoft 認證大師 (MCM),解釋了 SQL Server 資料庫組件之間的相互依賴性。您將學習如何快速診斷系統並發現任何問題的根本原因。本書中的技術與所有版本的 SQL Server 兼容,並涵蓋本地和雲端的 SQL Server 安裝。
- 發現 SQL Server 中性能問題的表現方式
- 了解 SQL Server 診斷工具、方法和技術
- 對 SQL Server 安裝進行健康檢查
- 了解 SQL Server 組件之間的依賴關係
- 調優 SQL Server 以改善性能並減少瓶頸
- 檢測優化不良的查詢和查詢執行計劃中的低效率
- 找出低效的索引和常見的資料庫設計問題
- 將這些技術應用於 Microsoft Azure SQL 資料庫、Azure SQL 管理實例和 Amazon RDS for SQL Server
作者簡介
Dmitri Korotkevitch is a Microsoft Data Platform MVP and the Director ofDatabase Services at Chewy.com. He specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second, and has years of experience working with Microsoft SQL Server as an Application and Database Developer, Database Administrator, and Database Architect. Dmitri also provides SQL Server consulting services and training to clients around the world.
作者簡介(中文翻譯)
Dmitri Korotkevitch 是微軟數據平台 MVP,並擔任 Chewy.com 的數據服務總監。他專注於設計、開發和性能調優複雜的 OLTP 系統,這些系統每秒處理數千筆交易,並擁有多年作為應用程式和數據庫開發人員、數據庫管理員及數據庫架構師的經驗。Dmitri 也為全球客戶提供 SQL Server 諮詢服務和培訓。