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 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. You'll learn to be proactive in establishing
performance baselines using tools like Performance Monitor and Extended Events. You'll learn to
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 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
