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.

Powered by Good Will. (Will is the person who offers his sympathy to others together with ideas, but who does not give any guarantee about the completeness of the concepts or the immaculate perfection of the scripts on this site. Use this site to grasp SQL Server concepts and to get knowledge. )