Books > Computing & IT > Computer programming
|
Not currently available
SQL Server 2017 Query Performance Tuning - Troubleshoot and Optimize Query Performance (Paperback, 5th ed.)
Loot Price: R1,227
Discovery Miles 12 270
You Save: R442
(26%)
|
|
SQL Server 2017 Query Performance Tuning - Troubleshoot and Optimize Query Performance (Paperback, 5th ed.)
Supplier out of stock. If you add this item to your wish list we will let you know when it becomes available.
|
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. What You'll Learn 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 Who This Book Is For Developers and database
administrators with responsibility for application performance in
SQL Server environments. Anyone responsible for writing or creating
T-SQL queries will find valuable the insight into bottlenecks,
including how to recognize them and eliminate them.
General
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!
|
|
Email address subscribed successfully.
A activation email has been sent to you.
Please click the link in that email to activate your subscription.