- Author:
- Grant Fritchey
Queries not running fast enough? Wondering about the in-memory database features in 2014? Tired of phone calls from frustrated users? Grant Fritcheys 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 techniques, especially including the newly-added, in-memory database features formerly known under the code name Project Hekaton. This book provides the tools you need to approach your queries with performance in mind. SQL Server Query Performance Tuning leads you through understanding the causes of poor performance, how to identify them, and how to fix them. Youll learn to be proactive in establishing performance baselines using tools like Performance Monitor and Extended Events. Youll learn to recognize bottlenecks and defuse them before the phone rings. Youll learn some quick solutions too, but emphasis is on designing for performance and getting it right, and upon heading off trouble before it occurs. Delight your users. Silence that ringing phone. Put the principles and lessons from SQL Server Query Performance Tuning into practice today. Covers the in-memory features from Project Hekaton Helps establish performance baselines and monitor against them Guides in troubleshooting and eliminating of bottlenecks that frustrate users What youll learn Establish performance baselines and monitor against them 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 so as to minimize performance risk Design in the performance that you need through careful query and index design Take advantage of the very latest performance optimization features in SQL Server 2014 Understand the new, in-memory database features formerly code-named as Project Hekaton Who this book is for SQL Server Query Performance Tuning is aimed at developers and database administrators having responsibility for application performance in SQL Server environments. Programmers and administrators alike will find the book a trove of good insight into bottlenecks, how to recognize them, how to eliminated them. SQL Server Query Performance Tuning provides the tools and techniques readers need to create good-performing applications that delight their users.
Index Terms
- SQL Server Query Performance Tuning
Reviews
Andrea F Paramithiotti
At the beginning of the 21st century, data are becoming as important an asset as financial resources, real estate, or intellectual property, and even more important is the ability to process them quickly and timely. The way data flow within an enterprise and are exchanged with its partners can definitely become a competitive advantage in times when market conditions are harsh. Long gone are the days when relatively simple batch processing or desktop database management systems (DBMS) were all that was needed to stay on top of things: nowadays data structures and flows need to be carefully designed, developed, tested, and run in specialized environments, and then looked after on a daily basis. Microsoft SQL Server is one such environment, widely in use to support industrial-grade, critical applications. This book does not even attempt to start from the beginning and explain what a database is or how to design and build one; it assumes a complete infrastructure that is already up and running, managed by professional database administrators-it deals only with constantly tuning it up in order to keep its performance top-notch. The subject certainly is hard, but the book deals with it in a way that is broad and thorough at the same time. Most books, for example, start with forewords and acknowledgements; this one starts with a flowchart detailing the performance tuning process. In fact, the message, clear and loud from the first pages, is: performance tuning is not a once-for-all process, but rather a continuous one that must carried out if not daily at least every time a major change occurs in the data structure. The details to look after are countless, but so luckily are the Microsoft SQL Server tools described in this book. From infrastructure analysis to resource use measurements to query design, every aspect of DBMS operation is covered; this book seems to have been written to create a work habit rather than to follow some set of procedures. The book starts by reviewing the very hardware in which queries must be executed on: methods to monitor and analyze memory, disks, and central processing unit (CPU) performance are presented, not forgetting that nowadays DBMS often run on virtual machines where performance is measured differently than on conventional machines. Indexes are then tackled as key elements in speeding up queries: among the subjects covered is index overhead, when creating too many indexes actually slows things down. Next is the Database Engine Tuning Advisor: no, we are not on a Formula One racetrack-it is simply the SQL Server tool that dynamically optimizes the indexes in use as the data workload changes. Then, the process of building the actual query is discussed: how to minimize resource use, how the query is actually executed by the hardware or virtual machine, and how to avoid deadlocks. At last, attention is given to the actual query execution: how to optimize workload and how to actually test database performance. The final chapter condenses all of the material in a checklist: in a few pages, tips and advice are ordered from drawing board to execution time. This book is not for the faint-hearted: the wealth of details is at times overwhelming; however, reference to SQL Server, 2014 edition is always at hand and to the point, and in many cases the advice given is also valid for different DBMS. Nonetheless, a solid experience in database administration is suggested to take full advantage of this book. More reviews about this item: Amazon , i-Programmer Online Computing Reviews Service
Access critical reviews of Computing literature here
Become a reviewer for Computing Reviews.