Customer Reviews


5 Reviews
5 star:
 (3)
4 star:
 (1)
3 star:
 (1)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
Share your thoughts with other customers
Create your own review
 
 

The most helpful favourable review
The most helpful critical review


5.0 out of 5 stars Excellent
This is an excellent review for anyone wanting to get a good grounding in wait stats, as a 5+ year experienced DBA I found some parts very interesting and useful to concreted my knowledge. This book in worth the read for any level DBA
Published on 23 Nov. 2012 by Gelder

versus
3.0 out of 5 stars Explains common waits but is too wordy and analogies are laboured
Hi,

I have written a detailed review of this book on "www i-programmer info" the first part of this review follows:

This short book aims to give you an understanding of wait stats, what they are, and how they can be used to improve SQL performance. Does it succeed?

When you submit a query to SQL Server, it runs on the CPU, however, if it...
Published 23 months ago by Ian Stirk


Most Helpful First | Newest First

3.0 out of 5 stars Explains common waits but is too wordy and analogies are laboured, 5 Jun. 2013
Hi,

I have written a detailed review of this book on "www i-programmer info" the first part of this review follows:

This short book aims to give you an understanding of wait stats, what they are, and how they can be used to improve SQL performance. Does it succeed?

When you submit a query to SQL Server, it runs on the CPU, however, if it can't run for any reason (e.g. waiting to get data from disk), SQL Server records why the query couldn't run, internally as a wait state (commonly known as wait stats). Examining these wait stats can reveal why a given SQL Server instance is performing sub-optimally.

Using wait stats together with performance monitor (PerfMon) counters to investigate problems on SQL Server is a well known performance tuning technique. This book aims to provide a guide to the more common wait stats, the techniques involved in using them, and offers advice on how to reduce them to improve SQL performance.

I expected the book to start with an overview of what Dynamic Management Views (DMVs) are, so as to put the wait stats DMV into context, but it doesn't, instead it starts with an analogy about inventions. Most chapters have a similar format, firstly explaining some common related wait stats, their causes, and methods used to reduce them. Each chapter ends with a review of the chapter's content and a short quiz - both of these are short and enjoyable. The wait stats and the methods used to reduce them are explained adequately.

The wait stats examined include:

*CXPACKET

*SOS_SCHEDULER_YIELD

*PAGEIOLATCH_xx

*IO_COMPLETION

*ASYNCH_IO_COMPLETION

*BACKUPIO

*BACKUPBUFFER

*LCK_M_xx

*WRITELOG

*MSSQL_XP

*OLEDB

Thanks
Ian
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


5.0 out of 5 stars Excellent, 23 Nov. 2012
By 
Gelder (Burnley, Lancashire) - See all my reviews
(REAL NAME)   
Verified Purchase(What is this?)
This review is from: SQL Wait Stats Joes 2 Pros: SQL Performance Tuning Techniques Using Wait Statistics, Types & Queues (Kindle Edition)
This is an excellent review for anyone wanting to get a good grounding in wait stats, as a 5+ year experienced DBA I found some parts very interesting and useful to concreted my knowledge. This book in worth the read for any level DBA
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


5.0 out of 5 stars Great product, 15 Nov. 2012
Verified Purchase(What is this?)
This review is from: SQL Wait Stats Joes 2 Pros: SQL Performance Tuning Techniques Using Wait Statistics, Types & Queues (Kindle Edition)
The inside out guide to SQL wait stats. Once completed your an expert forever and will be able to quickly and accurately troubleshoot.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


5.0 out of 5 stars awesome read, 21 May 2014
Verified Purchase(What is this?)
This review is from: SQL Wait Stats Joes 2 Pros: SQL Performance Tuning Techniques Using Wait Statistics, Types & Queues (Kindle Edition)
Very good read for any dba... Not in too much depth but very good for starters. Now I know where my sql server is spending its time.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


4.0 out of 5 stars A bit basic..., 13 April 2014
Verified Purchase(What is this?)
...but as a desktop help, you cannot fault it. Does not go into great detail but does not need to and still gets the point across.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


Most Helpful First | Newest First

This product

Only search this product's reviews