SQL Server 2017 Query Performance Tuning

Troubleshoot and Optimize Query Performance



Bookstore > Books > SQL Server 2017 Query Performance Tuning

SQL Server 2017 Query Performance Tuning
Price$44.98 - $51.56
Rating
AuthorGrant Fritchey
PublisherApress
Published2018
Pages932
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484238877
ISBN-139781484238875
EBook Hardcover Paperback

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.


  1. (5 books)



Similar Books


SQL Server 2012 Query Performance Tuning, 3rd Edition

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 2012. I...

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

SQL Server Query Performance Tuning, 4th Edition

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 and t...

Price:  $59.99  |  Publisher:  Apress  |  Release:  2014

Microsoft SQL Server 2017 on Linux

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

SQL Server 2017 Administration Inside Out

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:  $39.99  |  Publisher:  Microsoft Press  |  Release:  2018

A Developer's Guide to Data Modeling for SQL Server

A Developer's Guide to Data Modeling for SQL Server

by Eric Johnson, Joshua Jones

Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you're modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn't enough: models that don't reflect SQL Server's uniqu...

Price:  $6.70  |  Publisher:  Addison-Wesley  |  Release:  2008

Pro SQL Server on Linux

Pro SQL Server on Linux

by Bob Ward

Get SQL Server up and running on the Linux operating system and containers. No database professional managing or developing SQL Server on Linux will want to be without this deep and authoritative guide by one of the most respected experts on SQL Server in the industry. Get an inside look at how SQL Server for Linux works through the eyes ...

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

Getting Started with SQL Server 2014 Administration

Getting Started with SQL Server 2014 Administration

by Gethyn Ellis

The release of SQL Server 2014 has brought with it some great new features and enhancements that database administrators can use to make their database servers faster, highly available, and protected from disaster. As the lines between on-premise and on-cloud based solutions become even more blurred, enterprise database applications such ...

Price:  $16.99  |  Publisher:  Packt Publishing  |  Release:  2014

SQL Server 2014 Development Essentials

SQL Server 2014 Development Essentials

by Basit A. Masood-Al-Farooq

SQL Server 2014 Development Essentials is an easy-to-follow yet comprehensive guide that is full of hands-on examples. With Microsoft SQL Server 2014, you can design, build, and deploy mission-critical database applications. The variety of new in-memory features enable you to design high performance database applications that can improve ...

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