- Paperback: 110 pages
- Publisher: CreateSpace Independent Publishing Platform (September 1, 2011)
- Language: English
- ISBN-10: 1466234776
- ISBN-13: 978-1466234772
- Product Dimensions: 6 x 0.2 x 9 inches
- Shipping Weight: 5.6 ounces
- Average Customer Review: 4.2 out of 5 stars See all reviews (16 customer reviews)
- Amazon Best Sellers Rank: #2,019,417 in Books (See Top 100 in Books)
To get the free app, enter your email address or mobile phone number.
SQL Wait Stats Joes 2 Pros: SQL Performance Tuning Techniques Using Wait Statistics, Types & Queues Paperback – September 1, 2011
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more
Customers Who Bought This Item Also Bought
More About the AuthorsDiscover books, learn about writers, read author blogs, and more.
Top Customer Reviews
The topic is indeed one of the most often misunderstood and underestimated ones in performance tuning; and before this book was published there was serious lack of consistent and structured conceptual knowledge in the area.
The book is a pure waterfall of practical hands-on experience directed to both professional DBAs as well as beginners. It is written in an easy-to-read and structured way which makes it a good starting point for diving into performance tuning techniques.
The best quality of the book is that it not only delivers valuable insights into performance tuning by detailed examples of different waits and queues, but also teaches an entire skillset of performance tuning techniques and ideas.
I highly recommend this book, and I would even make it a `must read' for anybody - regardless of their experience - who has administrator access to any instance of SQL Server.
Also, if you are new to SQL server tuning, then you would be glad that you have this weapon under your belt! And even if you are familiar with wait stats, then there are lots of concepts that you could explore via this book.
I think the best part about this book is that the author uses real world examples from his own experience in dealing with SQL Server, and also encourages feedback from his readers about what to add and improve. It's almost like taking a SQL Server wait stats course, but you just have to pay for the book. And since this is the Kindle version, you pretty much have a great reference book in the palm of your hand - no need to drag around a back pack full of heavy books. The graphics from the examples in this book are preserved in the Kindle version. They are still easy to read on the black and white Kindle screen and there are no problems with the formatting.
Over all I have to give this book a full five stars!
The authors have spent a great deal of effort into creating metaphors to illustrate the concepts in each chapter. These are stories from every day life such as the waits at the check out lane and dividing work among multiple people (parallelism). I think that this technique makes the concepts more interesting and easier to understand. Performance tuning can be very dry material, and the authors did a great job of making it more fun. They also included some real world war stories which are very interesting to read.
I was able to get through this book in one sitting, but maybe if waits was a new topic for me, I would have taken longer. I will definiately keep this book as a handy reference.
So, if you are new to SQL Server performance tuning and have never looked at waits, or if, like me, you have used waits but there is more to learn, be sure to check out this book.
You will begin understanding what Wait Stats are, why they are important and how to incorporate them into your database tuning design right from the first chapter. Each chapter and concept is thoughtfully laid out and logically builds on the other, making the material incredibly easy to learn.
Every chapter is introduced with a real world, non-SQL based, story that helps you easily relate to the database concept you are about to learn. The concept is then clearly described and multiple code examples that actually work! There are also several screenshots from SQL Server Management Studio showing actual query results to help you confirm the results of running your own queries.
The end of each chapter includes a 'Points to Ponder' section provides a review of what has been covered in the chapter, and serves as a quick reference of each point covered to help refresh your memory in the future. The closing of each chapter includes a review quiz that uses a powerful, yet often unheralded, learning technique in that the answer key gives insight into the 'why' of both the incorrect answers and correct answer. This is an excellent way to help the reader comprehend what they are learning.
SQL Wait Stats is an excellent addition to the Joes2Pros series.Read more ›
Most Recent Customer Reviews
Very good book. In very simple and understandable way are explained the concept of waits and most important (in my opinion type of waits). Read morePublished on July 18, 2013 by Kalkin
If you and interested in the complete experience you really should add this book to your SQL collection. I recommend it to everyone who would like to get that SQL "edge".Published on July 5, 2013 by Smitty8498
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. Read more
I do not own a copy of this book. I don't know why this is here. I may have looked at it, but i'm more interested in a reference book than a programming cookbook-style book.Published on May 4, 2013 by David Myers
This is simple and easy to understand for beginners. I would highly recommend any newbie to start with this book.Published on February 25, 2013 by arkph
I am sure this is an excellent book, that is why I bought it. I am still in the Joes 2 Pros volumes. I browse it, ant it looks interesting.Published on January 16, 2013 by MAR
Good focus on most common stats to look at and good scripts.
Editing could have been better. Errors are distracting.