Learn more Shop now Learn more Shop now Shop now Shop now Shop now Shop now Shop now Shop now Shop now Shop now Learn More Shop now Learn more Click Here Shop Kindle Learn More Shop now Shop Women's Shop Men's


on 15 November 2012
The inside out guide to SQL wait stats. Once completed your an expert forever and will be able to quickly and accurately troubleshoot.
0Comment|Was this review helpful to you?YesNoReport abuse
on 5 June 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
0Comment|Was this review helpful to you?YesNoReport abuse
on 23 November 2012
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
0Comment|Was this review helpful to you?YesNoReport abuse
on 21 May 2014
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.
0Comment|Was this review helpful to you?YesNoReport abuse
on 13 April 2014
...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.
0Comment|Was this review helpful to you?YesNoReport abuse


Need customer service? Click here