SQL Server 2017 Query Performance Tuning
Troubleshoot and Optimize Query Performance
| Price | $53.39 - $57.69
|
| Rating |  |
| Author | Grant Fritchey |
| Publisher | Apress |
| Published | 2018 |
| Pages | 932 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1484238877 |
| ISBN-13 | 9781484238875 |
Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them.
This book covers the latest in performance optimization features and techniques and is current with SQL Server 2017. If your queries are not running fast enough and you're tired of phone calls from frustrated users, then this book is the answer to your performance problems.
SQL Server 2017 Query Performance Tuning is about more than quick tips and fixes. You'll learn to be proactive in establishing performance baselines using tools such as Performance Monitor and Extended Events. You'll recognize bottlenecks and defuse them before the phone rings. You'll learn some quick solutions too, but emphasis is on designing for performance and getting it right. The goal is to head off trouble before it occurs.
Use Query Store to understand and easily change query performance; Recognize and eliminate bottlenecks leading to slow performance; Deploy quick fixes when needed, following up with long-term solutions; Implement best practices in T-SQL to minimize performance risk; Design in the performance that you need through careful query and index design; Utilize the latest performance optimization features in SQL Server 2017; Protect query performance during upgrades to the newer versions of SQL Server.
- Grant Fritchey (7 books)
5 5 17
Similar Books
SQL Server 2012 Query Performance Tuning, 3rd Edition
by Grant Fritchey
Queries not running fast enough? Tired of the phone calls from frustrated users? Grant Fritchey's book SQL Server 2012 Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance optimization features and techniques. It is current with SQL Server 20...
Price: $46.34 | Publisher: Apress | Release: 2012
SQL Server 2022 Query Performance Tuning, 6th Edition
by Grant Fritchey
Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expand...
Price: $44.99 | Publisher: Apress | Release: 2022
SQL Server 2017 Administration Inside Out
by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
Dive into SQL Server 2017 administration - and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, cloud, or hybrid. Four SQL Serve...
Price: $34.23 | Publisher: Microsoft Press | Release: 2018
SQL Server Query Performance Tuning, 4th Edition
by Grant Fritchey
Queries not running fast enough? Wondering about the in-memory database features in 2014? Tired of phone calls from frustrated users? Grant Fritchey's book SQL Server Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance optimization features ...
Price: $77.64 | Publisher: Apress | Release: 2014
Microsoft SQL Server 2017 on Linux 
by Benjamin Nevarez
This comprehensive guide shows, step-by-step, how to set up, configure, and administer SQL Server 2017 on Linux for high performance and high availability. Written by a SQL Server expert and respected author, Microsoft SQL Server 2017 on Linux teaches valuable Linux skills to Windows-based SQL Server professionals. You will get clear cove...
Price: $29.93 | Publisher: McGraw-Hill | Release: 2018
Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
by Itzik Ben-Gan
Optimize your queries - and obtain simple and elegant solutions to a variety of problems - using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you'll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you're a database administrator or developer, ...
Price: $26.72 | Publisher: Microsoft Press | Release: 2012
SQL Server 2019 Administration Inside Out
by Randolph West, Melody Zacharias, William Assaf, Sven Aelterman, Louis Davidson, Joseph D'Antoni
Dive into SQL Server 2019 administration - and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to plan, implement, manage, and secure SQL Server 2019 in any production environment: on-premises, cloud, or hybrid. Six experts th...
Price: $48.15 | Publisher: Microsoft Press | Release: 2020
MySQL 8 Query Performance Tuning
by Jesper Wisborg Krogh
Identify, analyze, and improve poorly performing queries that damage user experience and lead to lost revenue for your business. This book will help you make query tuning an integral part of your daily routine through a multi-step process that includes monitoring of execution times, identifying candidate queries for optimization, analyzin...
Price: $19.24 | Publisher: Apress | Release: 2020