Lang Yarns

High Performance SQL Server : Consistent Response for Mission-Critical Applic...

Description: High Performance SQL Server : Consistent Response for Mission-Critical Applications, Paperback by Nevarez, Benjamin, ISBN 1484264908, ISBN-13 9781484264904, Brand New, Free shipping in the US

Design and configure SQL Server instances and databases in support of high-throughput, mission-critical applications providing consistent response times in the face of variations in numbers of users and query volumes. In this new edition, with over 100 pages of additional content, every original chapter has been updated for SQL Server 2019, and th also includes two new chapters covering SQL Server on Linux and Intelligent Query Processing.

This book shows you how to configure SQL Server and design your databases to support a given instance and workload. You will learn advanced configuration options, in-memory technologies, storage and disk configuration, and more, all aimed 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 you in detecting and fixing production performance problems and minimizing application outages. You will learn about a variety of tools, ranging from the traditional wait analysis methodology to the query store or indexing, and you will learn how improving performance is an iterative process.

This book is 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.



What You Will Learn
  • Understand SQL Servers 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

SQL Server database administrators, developers, and data architects. Th is also of use to system administrators who are managing and are responsible for the physical servers on which SQL Server instances are run.

Price: 59.57 USD

Location: Jessup, Maryland

End Time: 2024-11-04T13:51:43.000Z

Shipping Cost: 0 USD

Product Images

High Performance SQL Server : Consistent Response for Mission-Critical Applic...

Item Specifics

Restocking Fee: No

Return shipping will be paid by: Buyer

All returns accepted: Returns Accepted

Item must be returned within: 14 Days

Refund will be given as: Money Back

Book Title: High Performance SQL Server : Consistent Response for Mission-Cri

Number of Pages: Xxii, 397 Pages

Language: English

Publication Name: High Performance Sql Server : Consistent Response for Mission-Critical Applications

Publisher: Apress L. P.

Subject: Databases / General, Programming / Microsoft

Publication Year: 2021

Item Weight: 28 Oz

Type: Textbook

Author: Benjamin Nevarez

Item Length: 10 in

Subject Area: Computers

Item Width: 7 in

Format: Trade Paperback

Recommended

6 High Performance Ignition Coil & 6 NGK Iridium Spark Plug For Nissan Infiniti
6 High Performance Ignition Coil & 6 NGK Iridium Spark Plug For Nissan Infiniti

$123.86

View Details
10g Tub Silver Thermal Paste High Performance Heatsink Compound CPU GPU LED
10g Tub Silver Thermal Paste High Performance Heatsink Compound CPU GPU LED

$6.99

View Details
6PCS High Performance Ignition Coil for BMW 328i 335i 435i 525i 528i X5 X6 UF667
6PCS High Performance Ignition Coil for BMW 328i 335i 435i 525i 528i X5 X6 UF667

$40.78

View Details
High Performance UF413 Ignition Coil+Spark Plug+Wire For Chevy GMC 5.3L 6.2L V8
High Performance UF413 Ignition Coil+Spark Plug+Wire For Chevy GMC 5.3L 6.2L V8

$168.44

View Details
4X High Performance Gold Thermal Grease CPU Heatsink Compound Paste Syringe
4X High Performance Gold Thermal Grease CPU Heatsink Compound Paste Syringe

$4.19

View Details
SYLVANIA 9005 SilverStar Ultra High Performance Halogen Headlight Bulb, 2 Bulbs
SYLVANIA 9005 SilverStar Ultra High Performance Halogen Headlight Bulb, 2 Bulbs

$25.00

View Details
High Performance Habits: How Extraordinary People Become That Way
High Performance Habits: How Extraordinary People Become That Way

$5.23

View Details
YTX30L-BS  High Performance - Maintenance Free - Sealed AGM Motorcycle Battery
YTX30L-BS High Performance - Maintenance Free - Sealed AGM Motorcycle Battery

$69.50

View Details
MSD 8228 High Performance Coil 45K Volts  Fits 1990-1997 Dodge Jeep Plymouth
MSD 8228 High Performance Coil 45K Volts Fits 1990-1997 Dodge Jeep Plymouth

$64.85

View Details
Universal High Performance 2 Inch Toilet Flush Valve Repair Kit with Bolts
Universal High Performance 2 Inch Toilet Flush Valve Repair Kit with Bolts

$22.72

View Details