High Performance SQL Server " Consistent Response for Mission-Critical Applications / Benjamin Nevarez
Publication year: 2021
: 978-1-4842-6491-1
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
: 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
