Start reading SQL Wait Stats Joes 2 Pros on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here.

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

Read books on your computer or other mobile devices with our FREE Kindle Reading Apps.
SQL Wait Stats Joes 2 Pros: SQL Performance Tuning Techniques Using Wait Statistics, Types & Queues
 
 
Share your own customer images

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

Rick Morelan (Author), Pinal Dave (Author), Simon Nicholson (Editor), Joel Joel Heidal (Editor), Jessica Brown (Editor)
5.0 out of 5 stars  See all reviews (7 customer reviews) |
Digital List Price: $4.99 What's this?
Print List Price: $11.99
Kindle Purchase Price: $4.99
Prime Members: $0.00 (borrow for free from your Kindle) Prime Eligible
When Purchased, You Save: $7.00 (58%)
  • Includes free wireless delivery via Amazon Whispernet

For Kindle Device Owners

Borrow this book for free on a Kindle device with Amazon Prime. Buy a Kindle today and start your Amazon Prime free trial to borrow this book at no cost.

With Prime, Kindle owners can choose from over 145,000 titles to borrow for free – including all seven Harry Potter books (available on June 19) and more than 100 current and former New York Times Bestsellers – as frequently as a book a month, with no due dates. Learn more about Kindle Owners' Lending Library.

Formats

 Amazon Price New from Used from
Kindle Edition $4.99   -- --
Paperback $10.79   -- --
Unknown Binding --   -- --

Book Description

Publication Date: September 28, 2011
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.

Customers Who Bought This Item Also Bought

Product Details

  • File Size: 1296 KB
  • Print Length: 112 pages
  • Page Numbers Source ISBN: 1466234776
  • Sold by: Amazon Digital Services
  • Language: English
  • ASIN: B005QR92E2
  • Text-to-Speech: Enabled
  • Lending: Enabled
  • Amazon Best Sellers Rank: #80,206 Paid in Kindle Store (See Top 100 Paid in Kindle Store)

    •  Would you like to give feedback on images?

Customer Reviews

4 star
0
3 star
0
2 star
0
1 star
0
Most Helpful Customer Reviews
5 of 5 people found the following review helpful
Format:Paperback
I picked up this book at the PASS summit 2011 give away! I am glad i got my hands on this book - otherwise, i might have missed the chance of learning about wait stats in a practical manner. I like it that concepts are explained with examples and that helps me better appreciate the concept.

Also, if you are new to SQL server tuning, then you would be glad that you have this weapon under your belt! And even if you are familiar with wait stats, then there are lots of concepts that you could explore via this book.
Comment | 
Was this review helpful to you?
4 of 4 people found the following review helpful
Format:Paperback
Pinal and Rick do a great job covering the techniques of tuning using wait stats in SQL Server. I picked up the book at the PASS conference and had a hard time putting it down. It's chalk full of great details and examples are great and very applicable. I'd encourage any SQL Server professionals to pick this one up. It won't take many pages for you to realize a return on your investment.
Comment | 
Was this review helpful to you?
4 of 4 people found the following review helpful
Format:Kindle Edition|Amazon Verified Purchase
This book could be called 101 Best Wait Stats Solutions, and the title would only be inaccurate because there are more than 101 solutions in this book. There are almost 500 different wait types in SQL Server 2008, and that number is only going to increase over the next versions, so learning how to deal with wait stats now is very important. Even better, the author (Pinal Dave) has said in his blog that he will answer questions from the book if you contact him, and he has already addressed a few questions in recent posts. He also mentioned that this will be an "evolving" book, with updated versions that have reader's questions answered, so we have that to look forward to, as well.

I think the best part about this book is that the author uses real world examples from his own experience in dealing with SQL Server, and also encourages feedback from his readers about what to add and improve. It's almost like taking a SQL Server wait stats course, but you just have to pay for the book. And since this is the Kindle version, you pretty much have a great reference book in the palm of your hand - no need to drag around a back pack full of heavy books. The graphics from the examples in this book are preserved in the Kindle version. They are still easy to read on the black and white Kindle screen and there are no problems with the formatting.

Over all I have to give this book a full five stars!
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
Search Customer Reviews
Only search this product's reviews

More About the Author

› Visit Amazon's Rick A Morelan Page
Rick A Morelan
Joes2Pros is the brainchild of Rick A. Morelan.

Rick has been working with Microsoft since the late 90s and has attained over 30 Microsoft certifications in applications, networking, databases and .NET development, including MCDBA, MCTS, MCITP, MCAD, MOE, MCSE and MCSE+. His SQL certification in 2008 is the 4th generation of SQL certification in Implementation, Administration, and BI which also includes (SQL 7.0, SQL 2000, SQL 2005, and SQL 2008).

Rick has provided training for Northwest University, Volt Technical Education, and Microsoft. He currently works as a Software Design Engineer in Test for the Windows Mobile group, Bellevue College, and Moretechnology.com.

As the author of the "SQL Joes 2 Pros" book and video series, the focus is upon delivering the most effective and relevant learning material. Rick has comprehensive real-world knowledge in the subjects to prepare you for real-world troubleshooting issues while backing it up with the IT certification.

Rick lives near Seattle, Washington. Being someone dedicated to software designing and training, he is also an ardent charity worker. He trains service dogs that assist people with mobility needs. He also assists in walking the dogs and helps the puppies socialize more. Click here (See page 2).

Rick also happens to be in the Guinness Book of world records for producing the largest dog biscuit. To view the certificate, Click here

Rick has attended many trainings at Koenig-Solutions in SQL Server and C#.

Popular Highlights

 (What's this?)
&quote;
Query Execution Time is a combination of the following: CPU Time (Running) + Query Wait Time (Suspended State) &quote;
Highlighted by 6 Kindle users
&quote;
I suggest not touching the setting of number of the threads when dealing with CXPACKET wait. &quote;
Highlighted by 6 Kindle users
&quote;
You can (at any time) clear all wait stats using the following command: DBCC SQLPERF('sys.dm_os_wait_stats', CLEAR); &quote;
Highlighted by 6 Kindle users

Suggested Tags from Similar Products

 (What's this?)
Be the first one to add a relevant tag (keyword that's strongly related to this product).
 
(5)
(4)
(4)
(3)
(3)
(3)
(2)
(2)
(2)
(2)

Your tags: Add your first tag
 
See most popular tags

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
 


Active discussions in related forums
Search Customer Discussions
Search all Amazon discussions
   
Related forums

So You'd Like to...


Create a guide

Look for Similar Items by Category