Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry.
> Shop now
I picked up this book at the PASS summit 2011 give away! I am glad i got my hands on this book - otherwise, i might have missed the chance of learning about wait stats in a practical manner. I like it that concepts are explained with examples and that helps me better appreciate the concept.
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.
The real professional inspiration comes not from quantity but from quality. This becomes even more obvious by the thin book written by Rick A. Morelan and Pinal Dave on `SQL Performance Tuning techniques using wait statistics, Types and Queues'.
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.
This book could be called 101 Best Wait Stats Solutions, and the title would only be inaccurate because there are more than 101 solutions in this book. There are almost 500 different wait types in SQL Server 2008, and that number is only going to increase over the next versions, so learning how to deal with wait stats now is very important. Even better, the author (Pinal Dave) has said in his blog that he will answer questions from the book if you contact him, and he has already addressed a few questions in recent posts. He also mentioned that this will be an "evolving" book, with updated versions that have reader's questions answered, so we have that to look forward to, as well.
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!
This is the first title I have read in the "Joes 2 Pros" series, so I hope that the other books have a similar format. While digging into wait stats to solve a performance problem is very exciting (OK, I'm a geek), reading a book on SQL Server performance is usually like taking a couple of Benadryl. Zzzzzzz. This book is the exception!
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.
Pinal and Rick do a great job covering the techniques of tuning using wait stats in SQL Server. I picked up the book at the PASS conference and had a hard time putting it down. It's chalk full of great details and examples are great and very applicable. I'd encourage any SQL Server professionals to pick this one up. It won't take many pages for you to realize a return on your investment.
With SQL Wait Stats, Pinal Dave, Rick Morelan et al. of the Joes2Pros series take the reader deeper into the world of Performance Tuning by providing a look 'under the hood' of SQL Server and how to leverage this knowledge to improve database performance.
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 ›