High Performance SQL Server, 2nd Edition

Consistent Response for Mission-Critical Applications



Bookstore > Books > High Performance SQL Server, 2nd Edition

Price$44.53 - $55.70
Rating
AuthorBenjamin Nevarez
PublisherApress
Published2021
Pages397
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484264908
ISBN-139781484264904
EBook Hardcover Paperback

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.


  1. (3 books)



Similar Books


Microsoft SQL Server 2008 R2 Administration Cookbook

Microsoft SQL Server 2008 R2 Administration Cookbook

by Satya Shyam K Jayanty

Provides Advanced Administration techniques for SQL Server 2008 R2 as a book. Covers the essential Manageability, Programmability, and Security features. Emphasizes important High Availability features and implementation. Explains how to maintain and manage the SQL Server data platform effectively....

Price:  $32.99  |  Publisher:  Packt Publishing  |  Release:  2011

Dynamic SQL, 2nd Edition

Dynamic SQL, 2nd Edition

by Edward Pollack

Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the changing landscape of analytics and database administration. Code examples have been updated with new system objects and functions to impro...

Price:  $30.40  |  Publisher:  Apress  |  Release:  2019

SQL Cookbook, 2nd Edition

SQL Cookbook, 2nd Edition

by Anthony Molinaro, Robert de Graaf

You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated cookbook provides a framework to help you construct solutions and execut...

Price:  $45.37  |  Publisher:  O'Reilly Media  |  Release:  2020

Securing SQL Server, 2nd Edition

Securing SQL Server, 2nd Edition

by Peter A. Carter

Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy for your database enterprise. This new edition covers threat analysis, common attacks and countermeasures, and provides an introduction to compliance that is useful for meeting regulatory requirements such as the GDPR. The multi-layered...

Price:  $29.47  |  Publisher:  Apress  |  Release:  2018

Nginx HTTP Server, 2nd Edition

Nginx HTTP Server, 2nd Edition

by Clement Nedelcu

Nginx is a lightweight HTTP server designed for high-traffic websites, with network scalability as the primary objective. With the advent of high speed Internet access, short loading times and fast transfer rates have become a necessity. This free, open source solution will either come as a full replacement of other software such as Apach...

Price:  $26.99  |  Publisher:  Packt Publishing  |  Release:  2013

Beginning SQL Queries, 2nd Edition

Beginning SQL Queries, 2nd Edition

by Clare Churcher

Get started on mastering the one language binding the entire database industry. That language is SQL, and how it works is must-have knowledge for anyone involved with relational databases, and surprisingly also for anyone involved with NoSQL databases. SQL is universally used in querying and reporting on large data sets in order to genera...

Price:  $27.56  |  Publisher:  Apress  |  Release:  2016

Pro SQL Database for Windows Azure, 2nd Edition

Pro SQL Database for Windows Azure, 2nd Edition

by Scott Klein, Herve Roggero

Pro SQL Database for Windows Azure, 2nd Edition shows how to create enterprise-level database deployments without the usual investment in datacenter and other infrastructure. Take advantage instead of Microsoft's worldwide backbone for cloud computing that delivers all the power of SQL Server in the form of the cloud-based SQL Database fo...

Price:  $49.99  |  Publisher:  Apress  |  Release:  2012

Microsoft SQL Server 2008 High Availability

Microsoft SQL Server 2008 High Availability

by Hemantgiri S. Goswami

Install various SQL Server High Availability options in a step-by-step manner. A guide to SQL Server High Availability for DBA aspirants, proficient developers and system administrators. Learn the pre and post installation concepts and common issues you come across while working on SQL Server High Availability. Tips to enhance performance...

Price:  $29.99  |  Publisher:  Packt Publishing  |  Release:  2011