High Performance SQL Server: The Go Faster Book
暫譯: 高效能 SQL Server：加速指南
Benjamin Nevarez
買這商品的人也買了...
-
Linux Device Driver Programming 驅動程式設計$690$587 -
電腦網際網路, 6/e (國際版)(Computer Networking: A Top-Down Approach, 6/e)(附部分內容光碟)$650$585 -
藍牙 2.0 傳輸器$120$114 -
Java 學習手冊 (Learning Java, 4/e)$980$774 -
5.1 聲道 USB Audio Adapter$150$143 -
精通 Python｜運用簡單的套件進行現代運算 (Introducing Python: Modern Computing in Simple Packages)$780$616 -
完整學會 Git, GitHub, Git Server 的24堂課$360$284 -
Python 機器學習 (Python Machine Learning)$580$452 -
寫給 PM、RD 與設計師看的設計需求分析─使用者想要的應用程式都是這樣打造出來的 (Designing the Requirements: Building Applications that the User Wants and Needs)$580$458 -
$403實戰 ES2015：深入現代 JavaScript 應用開發 -
圖解密碼學與比特幣原理$580$458 -
Python 初學特訓班 (附250分鐘影音教學/範例程式)$480$379 -
今天不學機器學習，明天就被機器取代：從 Python 入手+演算法$590$502 -
jQuery 最強圖解實戰講座$450$356 -
超圖解 Arduino 互動設計入門, 3/e$680$537 -
Python 自動化的樂趣｜搞定重複瑣碎 & 單調無聊的工作 (中文版) (Automate the Boring Stuff with Python: Practical Programming for Total Beginners)$500$395 -
演算法技術手冊, 2/e (Algorithms in a Nutshell: A Practical Guide, 2/e)$580$458 -
Microsoft SQL Server 2016 管理實戰$699$594 -
人工智慧來了$500$395 -
Laravel 啟動與運行 (Laravel: Up and Running: A Framework for Building Modern PHP Apps)$780$616 -
Effective SQL 中文版 | 寫出良好 SQL 的 61個具體做法 (Effective SQL : 61 Specific Ways to Write Better SQL)$450$356 -
TensorFlow + Keras 深度學習人工智慧實務應用$590$460 -
寫程式前就該懂的演算法 ─ 資料分析與程式設計人員必學的邏輯思考術 (Grokking Algorithms: An illustrated guide for programmers and other curious people)$390$308 -
$331實用機器學習 (Real-world Machine Learning) -
大數據時代的演算法：機器學習、人工智慧及其典型實例$400$316
商品描述
Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload. You'll learn advanced configuration options, in-memory technologies, storage and disk configuration, and more, all toward enabling your desired application performance and throughput.
Configuration doesn't stop with implementation. Workloads change over time, and other impediments can arise to thwart desired performance. High Performance SQL Server covers monitoring and troubleshooting to aid in detecting and fixing production performance problems and minimizing application outages. You'll learn a variety of tools, ranging from the traditional wait analysis methodology to the new query store, and you'll learn how improving performance is really an iterative process.
High Performance SQL Server is based on SQL Server 2016, although most of its content can be applied to prior versions of the product. This book is an excellent complement to performance tuning books focusing on SQL queries, and provides the other half of what you need to know by focusing on configuring the instances on which mission-critical queries are executed.
- Covers SQL Server instance-configuration for optimal performance
- Helps in implementing SQL Server in-memory technologies
- Provides guidance toward monitoring and ongoing diagnostics
What You Will Learn
- Understand SQL Server's database engine and how it processes queries
- Configure instances in support of high-throughput applications
Provide consistent response times to varying user numbers and query volumes - Design databases for high-throughput applications with focus on performance
- Record performance baselines and monitor SQL Server instances against them
- Troubleshot and fix performance problems
Who This Book Is For
High Performance SQL Server is aimed at SQL Server database administrators, developers, and data architects. The book is also of use to system administrators who are managing and are responsible for the physical servers on which SQL Server instances are run.
商品描述(中文翻譯)
設計和配置 SQL Server 實例及資料庫，以支援關鍵任務的高吞吐量應用程式，並在用戶數量和查詢量變化的情況下提供一致的響應時間。學習如何配置 SQL Server 並設計資料庫以支援特定的實例和工作負載。您將學習高級配置選項、內存技術、存儲和磁碟配置等，所有這些都是為了實現您所期望的應用程式性能和吞吐量。
配置並不僅止於實施。隨著時間的推移，工作負載會發生變化，其他障礙也可能出現，妨礙所需的性能。《高效能 SQL Server》涵蓋了監控和故障排除，以幫助檢測和修復生產性能問題，並最小化應用程式的停機時間。您將學習各種工具，從傳統的等待分析方法到新的查詢存儲，並了解改善性能實際上是一個迭代過程。
《高效能 SQL Server》基於 SQL Server 2016，儘管其大部分內容也適用於該產品的早期版本。本書是專注於 SQL 查詢的性能調優書籍的絕佳補充，並通過專注於配置執行關鍵任務查詢的實例，提供您所需了解的另一半知識。
- 涵蓋 SQL Server 實例配置以達到最佳性能
- 幫助實施 SQL Server 內存技術
- 提供監控和持續診斷的指導
您將學到的內容：
- 了解 SQL Server 的資料庫引擎及其如何處理查詢
- 配置實例以支援高吞吐量應用程式
提供對變化的用戶數量和查詢量的一致響應時間
- 設計高吞吐量應用程式的資料庫，重點放在性能上
- 記錄性能基準並監控 SQL Server 實例
- 故障排除並修復性能問題
本書的適用對象：
《高效能 SQL Server》針對 SQL Server 資料庫管理員、開發人員和資料架構師。本書對於管理和負責運行 SQL Server 實例的物理伺服器的系統管理員也有幫助。
