Microsoft SQL Server 2014 Query Tuning & Optimization und über 1,5 Millionen weitere Bücher verfügbar für Amazon Kindle. Erfahren Sie mehr
  • Alle Preisangaben inkl. MwSt.
Nur noch 3 auf Lager (mehr ist unterwegs).
Verkauf und Versand durch Amazon.
Geschenkverpackung verfügbar.
Menge:1
Gebraucht: Sehr gut | Details
Verkauft von Warehouse Deals
Zustand: Gebraucht: Sehr gut
Kommentar: Gebrauchsspuren. Kleiner Schnitt oder Kratzer auf der Vorderseite. Kleine Falte oder kleiner Knick auf der Vorderseite. Kleiner Fleck oder geringe Abnutzung auf der Rückseite. Kleine Falte oder kleiner Knick auf der Rückseite. Kleiner Fleck oder geringe Abnutzung auf dem Buchrücken. Kleine Falte oder kleiner Knick am Buchrücken. Kleiner Fleck oder geringe Abnutzung auf den Seiten. Amazon-Kundenservice und Rücknahmegarantie (bis zu 30 Tagen) bei jedem Kauf.
Ihren Artikel jetzt
eintauschen und
EUR 9,00 Gutschein erhalten.
Möchten Sie verkaufen?
Zur Rückseite klappen Zur Vorderseite klappen
Anhören Wird wiedergegeben... Angehalten   Sie hören eine Probe der Audible-Audioausgabe.
Weitere Informationen
Dieses Bild anzeigen

Microsoft SQL Server 2014 Query Tuning & Optimization (Englisch) Taschenbuch – 1. Oktober 2014


Alle 2 Formate und Ausgaben anzeigen Andere Formate und Ausgaben ausblenden
Amazon-Preis Neu ab Gebraucht ab
Kindle Edition
"Bitte wiederholen"
Taschenbuch
"Bitte wiederholen"
EUR 37,37
EUR 28,63 EUR 24,23
38 neu ab EUR 28,63 4 gebraucht ab EUR 24,23
Jeder kann Kindle Bücher lesen — selbst ohne ein Kindle-Gerät — mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.


Produktinformation


Mehr über den Autor

Entdecken Sie Bücher, lesen Sie über Autoren und mehr

Produktbeschreibungen

Über den Autor und weitere Mitwirkende

Benjamin Nevarez is a Microsoft SQL Server MVP and independent consultant with more than 20 years of experience in relational databases. He specializes in SQL Server query tuning and optimization. Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections, and SQLBits.

Welche anderen Artikel kaufen Kunden, nachdem sie diesen Artikel angesehen haben?


In diesem Buch (Mehr dazu)
Ausgewählte Seiten ansehen
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis
Hier reinlesen und suchen:

Kundenrezensionen

Es gibt noch keine Kundenrezensionen auf Amazon.de
5 Sterne
4 Sterne
3 Sterne
2 Sterne
1 Sterne

Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)

Amazon.com: 6 Rezensionen
3 von 3 Kunden fanden die folgende Rezension hilfreich
Query Tuning Title Worthy of Your Bookshelf 17. Oktober 2014
Von A. Bertrand - Veröffentlicht auf Amazon.com
Format: Kindle Edition
Benjamin presents a thorough explanation of the entire query optimization process, and a lot of the background you'll need to make sense of it all. He treats indexes, statistics and plan caching, as well as how to deal with common issues such as parameter sniffing. He explains popular options like Optimize for Ad Hoc Workloads and Forced Parameterization, and how they change the way plans are cached and reused. He also discusses many undocumented features and trace flags that can help you better understand (or coerce) SQL Server's approach to your query, and how to use Trace, Extended Events and DBCC commands to review the decisions the optimizer had made and the impact they've had.

There is also a good portion of content dedicated to many new SQL Server 2014 features, including In-Memory OLTP ("Hekaton"), clustered columnstore indexes, incremental statistics, and the new cardinality estimator.

The book ends with a complex but informative chapter on query optimizer limitations that lead to sub-optimal plans, and how to use hints and plan guides to work around them.

There are a couple of omissions, like issues with auto-update of stats for filtered indexes, and the new DMV sys.dm_exec_query_profiles.

But otherwise, this has quickly become a convenient reference for me; the dog-ears are already replacing several of my bookmarks to blog posts that happen to mention some obscure detail or trace flag, and in many cases Benjamin has described it in more detail and/or framed it with better context.

I think anyone familiar with T-SQL could use this book to help them get up to speed pretty quickly, even having zero knowledge of the optimizer before diving in.

I posted a more thorough review here: http://sqlperformance.com/2014/10/sql-performance/review-query-tuning-optimization
1 von 1 Kunden fanden die folgende Rezension hilfreich
Performance tuning using the Query Processor - interesting 16. Dezember 2014
Von Ian Stirk - Veröffentlicht auf Amazon.com
Format: Kindle Edition
Hi,

I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review are given here. For my review of all chapters, search i-programmer DOT info for STIRK together with the book's title.

This book aims to give you the tools and knowledge to get peak performance from your queries, how does it fare?

The book covers query tuning and optimization, aiming to give you the tools and knowledge to get peak performance from your queries and applications. The optimizer creates an execution plan, detailing how the query will be fulfilled, the quality of this plan depends on various factors (e.g. database design, indexes available etc). This book looks at the factors that affect the plan, with a view to improving query performance.

The book is aimed at SQL Server professionals, database developers, DBAs, and data architects. It assumes some knowledge of SQL Server, and a familiarity with the SQL language.

Below is a chapter-by-chapter exploration of the topics covered.

Chapter 1 An Introduction to Query Tuning and Optimization

The chapter opens with the idea that the more you know about how SQL Server works, the more you’re in a better position to understand and fix SQL problems.

It continues with a brief look at the major architectural components: the storage engine (controls getting data, concurrency, and integrity), and the relational engine (aka the query processor, this creates a plan, executes the query and returns the results). This chapter provides an overview on how the query processor works.

The query processing process is broken down and its steps discussed, namely:
*Parsing and binding (parsing ensures SQL syntax is valid, binding is mostly name resolution)
*Query optimization:
-Generating candidate execution plans (want good-enough plan. often potentially lots of plans, uses rules and heuristics, there is limited optimization time)
-Assessing the cost of each plan (cost of physical operator [CPU, IO etc] together with estimated rows [cardinality] reflects total cost)
*Query execution and plan caching (execution plan stored in plan cache. Cache checked first to see if plan exists, since optimization can be relatively expensive)

The chapter next focuses on execution plans, their components, and how to read them. They are the primary method of interacting with the query processor. The different formats of the plans are discussed, namely: graphical, XML and text – it is noted the latter will be deprecated. Plans often contain warning messages (e.g. NoJoinPredicate), which are useful indications of perhaps a problematic or suboptimal plan. The ability to obtain the plan from a trace or the plan cache is discussed together with the relevant tool usage. Finally, the use of SET STATISTICS TIME and IO are discussed with examples, providing another useful tuning tool.

This chapter provides a very good overview of how the query processor works (parsing, binding, optimization, execution), as well as providing a useful overview of concepts that are used in the remainder of the book.
There are useful diagrams showing the query processing, and compilation and recompilation processes. There’s some useful code for creating an Extended Events (XE) session for recording plan information.

There’s a useful tip about examining the schema associated with the XML plan to discover any new plan elements (e.g. StatementOptmEarlyAbortReason, NonParallelPlanReason). There is good example code to illustrate the concepts discussed, good links to related chapters, and links to website for further information – is it is throughout the book.
.
.
.
Conclusion

This book aims to give you the tools and knowledge to get peak performance from your queries and applications. It differs from other performance related books by concentrating on the factors that influence the production of a good execution plan, and thus improve performance.

The book is generally easy to read, this is quite an achievement since some of the concepts are deep and undocumented. There are good links between the chapters, helpful website links for further information, good diagrams to support the discussions, and helpful example code to support the assertions made. The appendices should prove very useful. I enjoyed the author’s pragmatic approach e.g. use hints as a last resort, and always test recommendations on your own system.

It might be argued that the book is not as diverse as it could be, since it doesn’t cover all aspects of performance e.g. RAID levels, SQLDIAG, wait stats and queues. I think this misses the point, the book concentrates on those factors that influence the quality of the execution plan. Besides, the additional references provided will cover these other areas.

The book is suitable for intermediate to advanced level DBAs/developers, and should take your level of understanding of performance tuning in general, and the optimizer in particular, from level 5 to 8 or 9. Although the book is primarily for SQL Server 2014, it typically indicates in which version of SQL Server a given feature was introduced, so should prove useful in SQL Server 2012 and 2008.

I enjoyed reading this book. If you spend time troubleshooting performance problems, or you want a deeper understanding of the optimizer and the factors that influence it, I can heartily recommend this excellent book.
1 von 1 Kunden fanden die folgende Rezension hilfreich
Exceptional book, deep technical content made approachable 4. Dezember 2014
Von Anthony Nocentino - Veröffentlicht auf Amazon.com
Format: Taschenbuch
Benjamin is a great author with significant SQL Server experience and this new book further solidifies his place in the community.

Query processing and its inner workings are extremely dense technical concepts that Benjamin is able to present to the reader in a very approachable readable manner. The book elegantly walks you through the major components of the query processor and dives deep where need.

The code examples in the book are concise and accurately reenforce the key points the author is trying to convey in the text.

The book excels at connecting very complicated query processing topics together for the reader in a simple and approachable manner.

It covers the many new features of SQL 2014, including In-Memory OLTP, incremental statistics, the new cardinality estimator and the new features added to columstore indexes.

There few shortcomings with this book, I would have preferred citations throughout the book. Key concepts are introduced without citation and I would like to jump into some topics, specifically into the materials the author used when writing. The book does have an exceptional reference section, but there is no connection back to the text.

This book is now an a permanent fixture in my library of SQL Server references that I will likely need to replace when I wear it out.

I have more details on my blog at: http://www.centinosystems.com/blog/sql/book-review-query-tuning-optimization/
1 von 1 Kunden fanden die folgende Rezension hilfreich
The chapters do not need to be read in sequence making it easy to research a specific topic without reading the entire ... 9. November 2014
Von Marilu Gordon - Veröffentlicht auf Amazon.com
Format: Taschenbuch
Besides occasionally checking the execution plan in MS Query Analyzer, I never gave much thought to how MS SQL optimized queries. It was a black box and I felt I didn't need to know what happened in there. After running into some issues at work with long-running queries, I began to earnestly seek more information. Mr. Nevarez's book is a one-stop shopping ultimate resource on all things I have been learning in the past year. There is valuable information for both the novice and the expert, both the developer and administrator. The language used does not talk down to the uninitiated nor does it bore the professional. The text encompasses three types of samples for all three types of learners: graphs and photos, hands-on drills and written descriptions. The chapters do not need to be read in sequence making it easy to research a specific topic without reading the entire book. My absolute favorite part was the documentation of the Microsoft "undocumented" flags, options and parameters for use when investigating slow queries. This book is the newest tool in my toolbox and it should be in your toolbox too!
1 von 1 Kunden fanden die folgende Rezension hilfreich
The best book on performance since Ken England's Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook 16. Dezember 2014
Von Mladen Andrijasevic - Veröffentlicht auf Amazon.com
Format: Taschenbuch Verifizierter Kauf
In my opinion this is the best book on performance since Ken England's Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook which was published in 2001. Benjamin Nevarez is clear and comprehensive. Chapter 6 on Statistics is very detailed and covers the new cardinality estimator of SQL 2014.

Perhaps the best indicator of a book is how applicable the book is to our immediate work, and here the book came just in time to help me solve a problem. There was a discrepancy between the estimated and actual number of rows and I had just read that sometimes it is necessary to do an update statistics with FULLSCAN, which I did and a new recommended index popped up in green. The breaking down complex queries section and the reference to Steve Howard's paper "When to Break Down Complex Queries" resolved the problem.

I have little doubt that Query Tuning & Optimization will become indispensable.
Waren diese Rezensionen hilfreich? Wir wollen von Ihnen hören.