Start reading SQL Wait Stats Joes 2 Pros on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Colour:
Image not available
 

SQL Wait Stats Joes 2 Pros: SQL Performance Tuning Techniques Using Wait Statistics, Types & Queues [Kindle Edition]

Rick Morelan , Pinal Dave , Simon Nicholson , Joel Joel Heidal , Jessica Brown
4.4 out of 5 stars  See all reviews (5 customer reviews)

Print List Price: £6.49
Kindle Price: £3.59 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £2.90 (45%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.

Formats

Amazon Price New from Used from
Kindle Edition £3.59  
Paperback £6.49  
Kindle Daily Deal
Kindle Daily Deal: Up to 70% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Book Description

You learn a lot when thrown into a crisis situation, where everyone is looking to you for answers. The system is down, the CEO is pleading to you for answers as the each minute cuts the company’s bottom line. When you are in a hurry, you need some new ideas right away. This book is your helpful tool. When used correctly, you can determine solutions and even related solutions to simple (yet lesser known) areas of SQL Server. Learn what causes SQL tasks to wait or site in queues. Even if your system is not in trouble right now, you can use what you will learn in this book to view the history of wait statistics.


Product details

  • Format: Kindle Edition
  • File Size: 1296 KB
  • Print Length: 112 pages
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B005QR92E2
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Bestsellers Rank: #334,343 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


More About the Authors

Discover books, learn about writers, and more.

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

4.4 out of 5 stars
4.4 out of 5 stars
Most Helpful Customer Reviews
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?
5.0 out of 5 stars awesome read 21 May 2014
By Dev
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?
5.0 out of 5 stars Excellent 23 Nov. 2012
By Gelder
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?
5.0 out of 5 stars Great product 15 Nov. 2012
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?
4.0 out of 5 stars A bit basic... 13 April 2014
By Simon_K
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?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category