Do you work on SQL Server as a SQL developer or administrator and want to gain some good knowledge on SQL Wait Stats and Parallel Execution from SQL Guru Pinal Dave? Then this post will help you to win a hard copy of his book.
Pinal Dave, who is a Microsoft Evangelist published a book “SQL Wait Stats Joes 2 Pros” recently. He accepted my request and going to giveaway 2 copies of his book to my blog followers. Read more to register for the contest and Win the book Free.
Contest Rule – Enter to Win
But now I am going to give 2 (two) copies of this book as Free to my blog followers. It’s quite easy to win this book. If you want to be the lucky winner, just follow the steps mentioned below:
This giveaway contest of the book will remain open from 3rd October 2011 to 21st October 2011. Take part of the contest and win two copies of the book. We will randomly chose 2 winners from the participants and the result will be declared on 24th October 2011. We will send a Congratulation mail to the Winners and contact them for the shipping address.
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.