Sponsored
Enjoy fast, free delivery, exclusive deals, and award-winning movies & TV shows.
$46.17 with 16 percent savings
List Price: $54.99 Image
FREE delivery Tuesday, April 28
Or Prime members get FREE delivery Saturday, April 25. Join Prime
In Stock
$$46.17 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$46.17
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Shipper / Seller
Amazon.com
Amazon.com
Shipper / Seller
Amazon.com
Returns
FREE 30-day refund/replacement
FREE 30-day refund/replacement
Quick refund
Usually issued within 24 hours. See exceptions
FREE return
At least one free return option available.
Convenient dropoff
At any of our 50,000 US locations.
See return policy
Gift options
Available at checkout
Available at checkout This item is a gift. Change
At checkout, you can add a custom message, a gift receipt for easy returns and have the item gift-wrapped
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Added to

Sorry, there was a problem.

There was an error retrieving your Wish Lists. Please try again.

Sorry, there was a problem.

List unavailable.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

  • High Performance SQL Server: Consistent Response for Mission-Critical Applications

Follow the author

Get new release updates & improved recommendations
Something went wrong. Please try your request again later.

High Performance SQL Server: Consistent Response for Mission-Critical Applications 2nd ed. Edition

4.9 out of 5 stars (16)

{"desktop_buybox_group_1":[{"displayPrice":"$46.17","priceAmount":46.17,"currencySymbol":"$","integerValue":"46","decimalSeparator":".","fractionalValue":"17","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"DDJUDrewRuRFK2y0LA2XV4G6zurEVAQGk4v0bxcYeXFXOMUsfNPtreXMIf%2BzfrgoWRRLp3WBWyphMCFeZkhnYYSXdUG2C7HQmTc8kXP4UQldNP61gWFV5gVb1xZwI1IsL8pwbqjZnOUKbasH320C3A%3D%3D","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}]}

Purchase options and add-ons

Sponsored

Frequently bought together

This item: High Performance SQL Server: Consistent Response for Mission-Critical Applications
$46.17
Get it as soon as Tuesday, Apr 28
In Stock
Ships from and sold by Amazon.com.
+
$51.99
Get it as soon as Tuesday, Apr 28
In Stock
Ships from and sold by Amazon.com.
+
$69.99
Get it as soon as Tuesday, Apr 28
In Stock
Ships from and sold by Amazon.com.
Total price: $00
To see our price, add these items to your cart.
Details
Added to Cart
Choose items to buy together.

Customers also bought or read

Loading...

Editorial Reviews

From the Back Cover

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 the book 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.

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



About the Author

Benjamin Nevarez is a database professional based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of four books: SQL Server 2017 on Linux, High Performance SQL Server, SQL Server 2014 Query Tuning & Optimization, and Inside the SQL Server Query Optimizer, and he has co-authored other books, including SQL Server 2012 Internals. Benjamin has been a speaker at many SQL Server conferences and events around the world, including the PASS Summit, SQL Server Connections and SQLBits. His blog can be found at benjaminnevarez.com and he can be reached on twitter at @BenjaminNevarez and on Facebook.


Product details

  • Publisher ‏ : ‎ Apress
  • Publication date ‏ : ‎ January 22, 2021
  • Edition ‏ : ‎ 2nd ed.
  • Language ‏ : ‎ English
  • Print length ‏ : ‎ 420 pages
  • ISBN-10 ‏ : ‎ 1484264908
  • ISBN-13 ‏ : ‎ 978-1484264904
  • Item Weight ‏ : ‎ 1.55 pounds
  • Dimensions ‏ : ‎ 7.01 x 0.95 x 10 inches
  • Best Sellers Rank: #3,188,852 in Books (See Top 100 in Books)
  • Customer Reviews:
    4.9 out of 5 stars (16)

About the author

Follow authors to get new release updates, plus improved recommendations.
Benjamin Nevarez
Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

Benjamin Nevarez is a database professional based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of several books including “SQL Server Query Tuning & Optimization”, “High Performance SQL Server”, “SQL Server 2017 on Linux”, and “Inside the SQL Server Query Optimizer” and has also coauthored other books including “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences and events around the world and can be reached on twitter at @BenjaminNevarez and Facebook at https://www.facebook.com/BenjaminNevarez

Sponsored

Customer reviews

4.9 out of 5 stars
16 global ratings
Sponsored
Great New Edition of a Great Technical Book
5 out of 5 stars
Great New Edition of a Great Technical Book
One of the technical books that sit on my work desk at arm’s length as a resource book is Benjamin Navarez’s book on SQL Server performance, High Performance SQL Server: Consistent Response for Mission-Critical Applications. I have the first edition of this book. There are 2 new chapters in the new edition: SQL Server on Linux & Intelligent Query Processing. All the other chapters are also updated. The total number of new pages is at around 120 according to the author. And what I like with the new edition is that the chapters are divided among Part Headings which gives a good flow of the content. Do I recommend this book? Yes, that’s for sure!
Thank you for your feedback
Sorry, there was an error
Sorry we couldn't load the review

Top reviews from the United States

  • Reviewed in the United States on August 8, 2022
    Format: KindleVerified Purchase
    This valuable book should be read by any SQL developer looking to understand the configuration and performance of a SQL Server instance and its internal relational engine which is continuously refined to take advantage of advances in storage and memory technologies.

    High-level but very comprehensive info on SQL Server (all versions but esp. 2019 and 2022).
  • Reviewed in the United States on May 9, 2021
    Format: Paperback
    We as DBAs are always goggling for our issues and questions. That is so, because not all books have everything a DBA needs for a high performing SQL environment(and who doesn't?).
    All chapters are extremely well written. The good and accurate writing follows an awesome flow.
    The good news is that you can look at individual chapters without being interested in the other chapters and yet get your money's worth out of the book.
    My favorite chapter were: Part II - Chapter 3 about the SQL Server Configuration. Lot of times, as DBAs we get handed a server which are not up to our desired standards. We can now go to the infra team, armed with this knowledge and help ourselves get a good server.
    The next chapter that is my favorite, and I bet he can write one full book on this is the Chapter 5. Analyzing Wait Stats. I have spent inordinate amount of time analyzing these on the fly while facing some real time production issues. You don't want to miss this.

    I wish Ben can also create an audio post of these so we can listen to them while driving and such.

    I have heard and seen Ben speak at many of our SQL events. This book is pretty much a solid reflection of his mastery of the subject and his ability to explain it to the mortal DBAs.

    I wish him all the very best for this and future books.
  • Reviewed in the United States on April 15, 2021
    Format: Paperback
    One of the technical books that sit on my work desk at arm’s length as a resource book is Benjamin Navarez’s book on SQL Server performance, High Performance SQL Server: Consistent Response for Mission-Critical Applications.

    I have the first edition of this book.

    There are 2 new chapters in the new edition: SQL Server on Linux & Intelligent Query Processing. All the other chapters are also updated. The total number of new pages is at around 120 according to the author. And what I like with the new edition is that the chapters are divided among Part Headings which gives a good flow of the content.

    Do I recommend this book?

    Yes, that’s for sure!
    Customer image
    5.0 out of 5 stars
    Great New Edition of a Great Technical Book

    Reviewed in the United States on April 15, 2021
    One of the technical books that sit on my work desk at arm’s length as a resource book is Benjamin Navarez’s book on SQL Server performance, High Performance SQL Server: Consistent Response for Mission-Critical Applications.

    I have the first edition of this book.

    There are 2 new chapters in the new edition: SQL Server on Linux & Intelligent Query Processing. All the other chapters are also updated. The total number of new pages is at around 120 according to the author. And what I like with the new edition is that the chapters are divided among Part Headings which gives a good flow of the content.

    Do I recommend this book?

    Yes, that’s for sure!
    Images in this review
    Customer image Customer image
  • Reviewed in the United States on April 18, 2021
    Format: Paperback
    Lately we have been doing 2019 upgrades from 2016, (skipping 2017) and this book was very helpful in performance analysis, I would still recommend this to every DBA out there to have in your shelf. The first part is almost same as the first edition, but the later chapters including 2019 topics and differentiation between older version just saves so much of Google and reading time. If you ask me, Do you recommend to your friend, YES!!!! Go for it.. Thanks Author ✍️
  • Reviewed in the United States on February 9, 2021
    Format: Paperback
    Firstly, Benjamin Nevarez is an excellent author. The high performance SQL Server book is a MUST to have for any DBA or database analysts who deal with Sql Server database administration. Beyond our years of experience, having a reference copy of this helps add value to the job in much better scale. My 5 stars to Benjamin and his books.. I add this to my collection and read it completely.
    2 people found this helpful
    Report