Customer Review

12 of 12 people found the following review helpful
5.0 out of 5 stars You're mad if you don't get this book!, 1 Mar. 2010
This review is from: Professional SQL Server 2008 Internals and Troubleshooting (Paperback)
I'm not a SQL Server expert by any stretch of the imagination but I had a customer who was experiencing real performance issues with our application. I'd tried collecting the necessary data from Perfmon and Profiler myself and got into all sorts of problems. I had way too much data and had no idea how to present it or even if it was the right data to tell me what I needed to know. I'd bought the book and had it for a couple of weeks but hadn't had the time to read it.

I got so exasperated I stopped everything I was doing and sat for an evening and read through a couple of sections about the tools available to collect performance related data - SQLDiags, Perfstats etc. The next day, within 30 minutes I had a database with reports showing me all the information I needed.

The following day we ran a whole bunch of tests using the new tools introduced in this book and we found the major problem that was causing performance issues in the app.

These guys have written a fantastic book obviously from real life practical experience, not theory. Well done guys and thanks for your help!

Now I've got to find the time to sit down and read the book front to back!

TIP! One thing that wasn't in the book is what to do if you've collected some performance data, run ReadTrace to load it into the PerfAnalysis db and then you want to run another set of tests but keep the original set of results for later analysis. Luckily I went to a SQL PASS user group where Christian Bolton did a presentation and reminded us that when you use this tool you need to rename the PerfAnalysis database first before running your next collection of data otherwise you'll overwrite your previous data collection.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Be the first person to comment on this review.

[Add comment]
Post a comment
To insert a product link use the format: [[ASIN:ASIN product-title]] (What's this?)
Amazon will display this name with all your submissions, including reviews and discussion posts. (Learn more)
Name:
Badge:
This badge will be assigned to you and will appear along with your name.
There was an error. Please try again.
Please see the full guidelines ">here.

Official Comment

As a representative of this product you can post one Official Comment on this review. It will appear immediately below the review wherever it is displayed.   Learn more
The following name and badge will be shown with this comment:
 (edit name)
After clicking on the Post button you will be asked to create your public name, which will be shown with all your contributions.

Is this your product?

If you are the author, artist, manufacturer or an official representative of this product, you can post an Official Comment on this review. It will appear immediately below the review wherever it is displayed.  Learn more
Otherwise, you can still post a regular comment on this review.

Is this your product?

If you are the author, artist, manufacturer or an official representative of this product, you can post an Official Comment on this review. It will appear immediately below the review wherever it is displayed.   Learn more
 
System timed out

We were unable to verify whether you represent the product. Please try again later, or retry now. Otherwise you can post a regular comment.

Since you previously posted an Official Comment, this comment will appear in the comment section below. You also have the option to edit your Official Comment.   Learn more
The maximum number of Official Comments have been posted. This comment will appear in the comment section below.   Learn more
Prompts for sign-in
 


Review Details

Item

4.9 out of 5 stars (14 customer reviews)
5 star:
 (13)
4 star:
 (1)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
£39.99
Add to basket Add to wishlist
Reviewer


Location: UK

Top Reviewer Ranking: 6,015,500