|
||||||||||||||||||||
|
||||||||||||||||||||
|
||||||||||||||||||||
SQL Server 2008 Query Performance Tuning Distilled
und über 1 Million weitere Bücher verfügbar für Amazon Kindle .
Erfahren Sie mehr
| ||||||||||||||||||
|
Dieses Buch gibt es in einer neuen Auflage:
|
Wird oft zusammen gekauft
Produktinformation
|
Mehr über den Autor
Entdecken Sie Bücher, lesen Sie über Autoren und mehr
› Besuchen Sie die Seite von Grant Fritchey auf Amazon
› Besuchen Sie die Seite von Grant Fritchey auf Amazon
Produktbeschreibungen
Kurzbeschreibung
SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble shooting methodology for identifying poorly-performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedicated to one of the top causes of poorly performing queries and shows methods for identifying and dealing with the problems in that chapter's domain. Emphasis is always put upon or placed upon practical methods that you can put to immediate use in your day to day work. SQL Server 2008 functionality, tips, and tricks are emphasized in each subject area. * Emphasizes the practical. Does not bury readers in theory. * Gives readers practical techniques to immediately apply in their daily work. * Dedicates a chapter to each of the most common, performance related problem areas. What you'll learn * Identify and fix poorly performing queries that are hurting your business. * Read query execution plans and identify bottlenecks in performance. * Record system performance metrics for trend analysis. * Learn to design databases and write Transact SQL code to avoid common problems. * Understand what an index is, what it does, and how to build one. * Use industry accepted best practices and understand how to develop your own to arrive at optimal database performance. Who this book is for SQL Server Query Performance Tuning Distilled is aimed at anyone writing business critical Transact SQL queries, and also at those responsible for the continued good performance of those queries. Developers, database administrators, business intelligence analysts, and any others who develop Transact SQL queries will find this book an indispensible resource for getting the most out of what SQL Server 2008 has to offer.
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
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis
Vorgeschlagene Tags zu ähnlichen Produkten(Was ist das?)Setzen Sie den ersten relevanten Tag hinzu (ein Schlüsselwort, das mit diesem Produkt in engem Zusammenhang steht).
|
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:
21 Rezensionen
32 von 33 Kunden fanden die folgende Rezension hilfreich
Fantastic for Performance Tuners
21. April 2009
Format:Taschenbuch
My gauge of an amazing book is simple: if I've got a question, and I reach for the book BEFORE I search the web, then it's an amazing book.
Several times in the last two weeks, I reached for this book first.
Query performance tuning is the art of reading a query's execution plan, figuring out why it's not fast, and then determining the most cost-effective way to make it faster. Anybody can throw more indexes in and just hope it speeds up, but as the book illustrates, sometimes that can hurt more than help.
To do a good job, the tuner needs to know about indexing, statistics, execution plans, compilations, blocking, deadlocks, and query design issues that can force a query to perform poorly. Some of this stuff is covered in abstract terms in college classes, but for the most part, all of us - developers, DBAs, sysadmins - are pretty much unprepared to guess what's going on inside the SQL Server engine.
When you first design and deploy an application, that's a great thing: you don't need to know what's going on inside the black box. SQL Server handles a lot of load with the default settings, with pretty much any application design, before things start to creak and groan. I've seen people build amazingly big SQL Server applications without any knowledge of how indexes or execution plans work. When you start to run into performance problems, you need expert help fast - and that's what this book provides.
Regardless of your seniority level, you're going to find this book's price an extremely worthwhile investment. The book's authors, Grant Fritchey and Sajal Dam, strike a great balance between bringing you up to speed versus diving into advanced concepts. Chapter 4 on Index Analysis is a great example. It spends the first few pages bringing the beginners up to speed on what an index is and how B-trees work. Then it gradually layers on an explanation of how you would approach index design and why the width of your index matters. The explanation includes queries that prove the concepts, with screenshots of results where appropriate. The discussion ramps up to more advanced topics like covering indexes, filtered indexes, and compression.
I really like the organization of this book because it progresses in the same way that I'd recommend training for a performance tuner. If you need to make an application run faster, read the book in order. Don't be tempted to jump to, say, execution plan analysis - you'll make poor decisions without understanding the concepts discussed earlier.
I've been performance tuning applications for years, trying to wring every last dollar's worth out of my hardware to make our applications run faster, and I keep learning things as I go through this book. Normally, I try to read the entire book cover to cover before posting a review, but in this case, it's going to be quite a while before I finish the book. I just keep reading a chapter, catching enough things I didn't know before, and then stopping to apply that knowledge and test it out in my lab. I highly recommend it.
Several times in the last two weeks, I reached for this book first.
Query performance tuning is the art of reading a query's execution plan, figuring out why it's not fast, and then determining the most cost-effective way to make it faster. Anybody can throw more indexes in and just hope it speeds up, but as the book illustrates, sometimes that can hurt more than help.
To do a good job, the tuner needs to know about indexing, statistics, execution plans, compilations, blocking, deadlocks, and query design issues that can force a query to perform poorly. Some of this stuff is covered in abstract terms in college classes, but for the most part, all of us - developers, DBAs, sysadmins - are pretty much unprepared to guess what's going on inside the SQL Server engine.
When you first design and deploy an application, that's a great thing: you don't need to know what's going on inside the black box. SQL Server handles a lot of load with the default settings, with pretty much any application design, before things start to creak and groan. I've seen people build amazingly big SQL Server applications without any knowledge of how indexes or execution plans work. When you start to run into performance problems, you need expert help fast - and that's what this book provides.
Regardless of your seniority level, you're going to find this book's price an extremely worthwhile investment. The book's authors, Grant Fritchey and Sajal Dam, strike a great balance between bringing you up to speed versus diving into advanced concepts. Chapter 4 on Index Analysis is a great example. It spends the first few pages bringing the beginners up to speed on what an index is and how B-trees work. Then it gradually layers on an explanation of how you would approach index design and why the width of your index matters. The explanation includes queries that prove the concepts, with screenshots of results where appropriate. The discussion ramps up to more advanced topics like covering indexes, filtered indexes, and compression.
I really like the organization of this book because it progresses in the same way that I'd recommend training for a performance tuner. If you need to make an application run faster, read the book in order. Don't be tempted to jump to, say, execution plan analysis - you'll make poor decisions without understanding the concepts discussed earlier.
I've been performance tuning applications for years, trying to wring every last dollar's worth out of my hardware to make our applications run faster, and I keep learning things as I go through this book. Normally, I try to read the entire book cover to cover before posting a review, but in this case, it's going to be quite a while before I finish the book. I just keep reading a chapter, catching enough things I didn't know before, and then stopping to apply that knowledge and test it out in my lab. I highly recommend it.
20 von 21 Kunden fanden die folgende Rezension hilfreich
SQL Server 2008 Query Performance Tuning Distilled
5. Mai 2009
Format:Taschenbuch|Von Amazon bestätigter Kauf
Great book. I've been waiting for the re-write to Sajal Dam's book on SQL Server 2000 performance tuning for a very long time. The only problem with it is that that too many example scripts do not match the code in the book. [case in point: On pg. 289 it references a script called stats_changes.sql. The code in the download is nothing like the code on pg. 290. Ditto for pg. 177 and several others.] This leaves the reader to figure it out for themself. The book includes an email address for the author that rejects all attempts to send him email and I see no updates to the download since it was first published. If these oversites are corrected, this would be a great learning resource for the SQL Server professional charged with performance tuning responsibilities.
8 von 8 Kunden fanden die folgende Rezension hilfreich
A great reference book on SQL Tuning.
24. November 2009
Format:Taschenbuch
One of the finest book on SQL Server Perf Tuning. To be honest I used to have the SQL Server performance tuning book by Ken England on SQL 2000 and looking for it's sequel on 2005. I went to the book store and ordered the book but it was disappointing. Then this book was given to me by one of my friends. A great reference book as I was expecting. Lot of theories and matching examples make this book stand out from the rest. SQL Server is just not SQL Tuning. It includes Database System tuning. This book has given a dedicated chapter in making you understand the same. It gives you a perspective on how to approach to a performance tuning from identification of the performance bottleneck to troubleshooting the problem. I enjoyed reading chapters on indexing and Index, Statistics and Execution Cache Analysis. However, I wanted to see more detail on tuning XML and Service Broker.
I will suggest this book for other DBAs and SQL Programmers who want to know the theories behind Index and Statistics, BLocking and Deadlocking, Fragmentation.
I will suggest this book for other DBAs and SQL Programmers who want to know the theories behind Index and Statistics, BLocking and Deadlocking, Fragmentation.
Waren diese Rezensionen hilfreich?
Wir wollen von Ihnen hören.
Kunden diskutieren
|
Das Forum zu diesem Produkt
Fragen stellen, Meinungen austauschen, Einblicke gewinnen Aktive Diskussionen in ähnlichen Foren
Kundendiskussionen durchsuchen
|
Ähnliche Foren
|
||||||||||||||||||||||||||||||||||
Lieblingslisten
Ähnliche Artikel finden
Anhand des Sachgebietes nach ähnlichen Produkten suchen:
Ihr Kommentar
Möchten Sie die Produktinformationen aktualisieren oder Feedback zu den Produktabbildungen geben?
|
