{"product_id":"9781430242048","title":"SQL Server 2012 Query Performance Tuning","description":"\u003cp\u003eQueries not running fast enough? Tired of the phone calls from frustrated users? Grant Fritchey’s book \u003cem\u003eSQL Server 2012 Query Performance Tuning \u003c\/em\u003eis 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. It provides the tools you need to approach your queries with performance in mind. \u003c\/p\u003e\u003cp\u003e\u003cem\u003eSQL Server 2012 Query Performance Tuning \u003c\/em\u003eleads 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 \u003cem\u003eSQL Server 2012 Query Performance Tuning \u003c\/em\u003einto practice today.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eEstablish performance baselines and monitor against them \u003c\/li\u003e\n\u003cli\u003eTroubleshoot and eliminate bottlenecks that frustrate users \u003c\/li\u003e\n\u003cli\u003ePlan ahead to achieve the right level of performance \u003c\/li\u003e\n\u003c\/ul\u003eWhat you’ll learn\u003cul\u003e   \u003cli\u003eEstablish performance baselines and monitor against them \u003c\/li\u003e   \u003cli\u003eRecognize and eliminate bottlenecks leading to slow performance \u003c\/li\u003e   \u003cli\u003eDeploy quick fixes when needed, following up with long term solutions \u003c\/li\u003e   \u003cli\u003eImplement best-practices in T-SQL so as to minimize performance risk \u003c\/li\u003e   \u003cli\u003eDesign in the performance that you need through careful query and index design \u003c\/li\u003e   \u003cli\u003eTake advantage of the very latest performance optimization features in SQL Server 2012 \u003c\/li\u003e  \u003c\/ul\u003e  Who this book is for      \u003cp\u003e     \u003cem\u003eSQL Server 2012 Query Performance Tuning \u003c\/em\u003eis 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.\u003cem\u003e SQL Server 2012 Query Performance Tuning \u003c\/em\u003eprovides the tools and techniques readers need to create good-performing applications that delight their users.         \u003c\/p\u003e     Table of Contents\u003col\u003e   \u003cli\u003eSQL Query Performance Tuning \u003c\/li\u003e   \u003cli\u003eSystem Performance Analysis \u003c\/li\u003e   \u003cli\u003eSQL Query Performance Analysis \u003c\/li\u003e   \u003cli\u003eIndex Analysis \u003c\/li\u003e   \u003cli\u003eDatabase Engine Tuning Advisor \u003c\/li\u003e   \u003cli\u003eLookup Analysis \u003c\/li\u003e   \u003cli\u003eStatistics Analysis \u003c\/li\u003e   \u003cli\u003eFragmentation Analysis \u003c\/li\u003e   \u003cli\u003eExecution Plan Analysis \u003c\/li\u003e   \u003cli\u003eQuery Recompilation Analysis \u003c\/li\u003e   \u003cli\u003eQuery Design Analysis \u003c\/li\u003e   \u003cli\u003eBlocking Analysis \u003c\/li\u003e   \u003cli\u003eDeadlock Analysis \u003c\/li\u003e   \u003cli\u003eCursor Cost Analysis \u003c\/li\u003e   \u003cli\u003eTesting Query Performance \u003c\/li\u003e   \u003cli\u003eDatabase Workload Optimization \u003c\/li\u003e   \u003cli\u003eSQL Server Optimization Checklist \u003c\/li\u003e  \u003c\/ol\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47127972708592,"sku":"9781430242048","price":41.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430242048_p0.jpg?v=1763749832","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430242048","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}