On 3rd October 2011, I had started a giveaway contest of “SQL Wait Stats Joes 2 Pros” book authored by Pinal Dave, Microsoft Evangelist and Founder of SQLAuthority.com. The contest ended on 21st October 2011.
We received no. of participants in the contest and after reviewing all the entries, I have randomly picked up two Winners, who will receive signed copy of the “SQL Wait Stats Joes 2 Pros” book. Congratulation email will be send out to the winners requesting their shipping address. Find out whether you are the lucky winner of the contest.
From the 10 valid entries, the system has generated two random winners from the list and I am happy to announce the winners name here. The Winners are: Santosh Mahajan and Sangeetha Subramanyam. Congratulation!!! An email will be send out to those winners shortly requesting their shipping address.
Each of those two winners will receive one hard copy of the “SQL Wait Stats Joes 2 Pros” book signed by Pinal Dave. Once I receive the shipping address from the winners, I will send out the book to them. It may take 15-20 days. So please keep patience.
Once again Congrats Santosh Mahajan and Sangeetha Subramanyam for winning the book. Thanks to all of you for participation in the contest. Stay tuned to my blog for future updates and contests.
More About the Book
The study of wait types is a vast subject, and it would be difficult for one person to understand every wait type and its associated statistics. SQL Server 2008 R2 includes nearly 500 wait types, and this number will increase in the next version of SQL Server (codename “Denali”).
Wait types are not new to SQL Server but the techniques to interpret this feature are not widely available. Performance tuning has been a mainstream concern for SQL professionals for many years. There are many tactics which experts use to tune servers, queries, and systems; however, techniques for using wait types, wait queues, and wait statistics in performance tuning are understood by relatively few in our industry.
Of the hundreds of wait types, this book covers the most visible ones. This initial volume doesn’t cover the wait statistics with less significance or ones seldom seen. Again, every wait type potentially has multiple solutions. This book is a humble attempt to make these concepts more accessible to SQL developers.