Publication year: 2021
ISBN: 978-1-4842-6491-1
Internet Resource: Please Login to download book
An excellent complement to query performance tuning books and provides the other half of what you need to know by focusing on configuring the instances on which mission-critical queries are executed. You will: 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
Subject: Database Management, SQL Server, VMWare, Extended events, Waits, Wait events, Disk configuration, Capacity planning, Indexes, Query Optimization, In-Memory OLTP, In-Memory Database, Query Store, Tempdb, Performance Troubleshooting, Monitoring and Diagnostics, Wait Statistics, Performance Baselines, High Thruput, Mission Critical