SQL Wait Stats Joes 2 Pros and over 2 million other books are available for Amazon Kindle . Learn more
£6.49
FREE Delivery in the UK on orders over £10.
Usually dispatched within 2 to 4 weeks.
Dispatched from and sold by Amazon.
Gift-wrap available.
Quantity:1
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

SQL Wait Stats Joes 2 Pros Paperback – 1 Jan 2011


See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
£6.49
£5.15 £5.60

Frequently Bought Together

SQL Wait Stats Joes 2 Pros + SQL Server Interview Questions and Answers
Price For Both: £13.48

One of these items is dispatched sooner than the other.

Buy the selected items together


Product details

  • Paperback: 112 pages
  • Publisher: Joes 2 Pros International LLC (1 Jan 2011)
  • Language: English
  • ISBN-10: 0985226862
  • ISBN-13: 978-0985226862
  • Product Dimensions: 15.2 x 0.6 x 22.9 cm
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Bestsellers Rank: 1,598,094 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, and more.

Inside This Book (Learn More)
Browse and search another edition of this book.
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

4.4 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

By Dev on 21 May 2014
Format: Kindle Edition Verified Purchase
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
By Simon_K on 13 April 2014
Format: Paperback Verified Purchase
...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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback
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
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
By Gelder on 23 Nov 2012
Format: Kindle Edition Verified Purchase
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
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Kindle Edition Verified Purchase
The inside out guide to SQL wait stats. Once completed your an expert forever and will be able to quickly and accurately troubleshoot.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Look for similar items by category


Feedback