Buy New
$23.95
Qty:1
  • List Price: $29.99
  • Save: $6.04 (20%)
FREE Shipping on orders over $35.
Usually ships within 1 to 3 weeks.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Trade in your item
Get a $0.58
Gift Card.
Have one to sell? Sell on Amazon
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

Mastering SQL Server Profiler Paperback – March 20, 2009


Amazon Price New from Used from
Paperback
"Please retry"
$23.95
$19.40 $18.50


Frequently Bought Together

Mastering SQL Server Profiler + SQL Server Execution Plans + Performance Tuning with SQL Server Dynamic Management Views (High Performance SQL Server)
Price for all three: $70.08

Buy the selected items together

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 372 pages
  • Publisher: Simple Talk Publishing (March 20, 2009)
  • Language: English
  • ISBN-10: 1906434158
  • ISBN-13: 978-1906434151
  • Product Dimensions: 6.1 x 9.2 inches
  • Shipping Weight: 1.1 pounds (View shipping rates and policies)
  • Average Customer Review: 3.8 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Best Sellers Rank: #1,576,552 in Books (See Top 100 in Books)

More About the Author

Brad M. McGehee is a MCTS, MCSE+I, MCSD, and MCT (former) with a Bachelor's degree in Economics and a Masters in Business Administration. Brad was a Microsoft SQL Server MVP for 10 years, and has over 18 years SQL Server experience, over 9 years training experience, and has been involved in the IT since 1982.

Brad has been a frequent speaker at SQL PASS, European PASS, SQL Server Connections, SQLTeach, devLINK, SQLBits, SQL Saturdays, TechFests, Code Camps, SQL in the City, SQL Server user groups, webinars, and other industry seminars, where he shares his 18 years of cumulative knowledge and experience.

Since 2007, Brad has presented over 154 presentations to over 10,300 attendees in six different countries.

Brad was the founder of the popular community site SQL-Server-Performance.Com, and operated it from 2000 through 2006, where he wrote over one million words on SQL Server topics.

Customer Reviews

3.8 out of 5 stars
5 star
3
4 star
0
3 star
0
2 star
2
1 star
0
See all 5 customer reviews
Excellent written style.
David Martin
Why he dumbed down this book so much for someone with loads of dba experience is a mystery.
Pirc_defense_expert
I've read dozens of SQL Server books over the years, including many about Profiler.
Douglas S. Tombow

Most Helpful Customer Reviews

5 of 5 people found the following review helpful By David Martin on September 24, 2009
Format: Paperback Verified Purchase
If you have decades of experience in Sql Server, and taken hands-on admin courses, skip this book. You don't need it. If you haven't mastered trace yet, you never will.

IF, on the other hand, you are responsible for Sql boxes at work, and know in your heart you are not well-versed in troubleshooting issues (outside of the old Microsoft holdover "Reboot and Pray") then buy this book, spend a weekend reading and practicing, and you'll have locked down the skills on the most important tool in the Sql toolbox.

I found this title by accident (a Amazon hint on another title's page). I ordered it overnight and consumed it. Excellent written style. Easy to read. Solid coverage on a software tool.

Profiler is actually just a GUI wrapped around Trace. The book specifically covers the GUI (Profiler) and provides enough filler information to perform Trace through Stored Procedures. There is no real information on the SMO API, which is what Profiler uses (it's just a .NET SMO consumer).

This book was written for SS 2005, and 2008 has added several features that extend Trace's abilities. Once you read this book, you'll be prepared for the new features of 2008.

If you find this title useful, then I would also suggest another title from the same publisher. Grant Fritchey's "Execution Plans" book builds on Brad's book and helps you move from "Reactive Mode" to "Proactive Mode" in dealing with query analysis. Together, they make a DBA good at what he does.
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
4 of 4 people found the following review helpful By Douglas S. Tombow on July 11, 2009
Format: Paperback
A single, comprehensive (and well-written) resource from one of the best!

I've read dozens of SQL Server books over the years, including many about Profiler. Although most were helpful for getting started, they didn't cover enough information to really understand the best ways to use this complex and powerful tool.

Brad McGehee's book delivers on the promise of its title - after reading it, you'll feel like you are truly on your way to mastery. It combines a wealth of knowledge with best practice advice, gleaned from real-world experience. He provides a good balance of introductory concepts and advanced topics that can be quickly digested, uses screen shots to add clarity, and shares tips and techniques to use Profiler more effectively. Most important, Brad's writing style is organized, logical, progressive, engaging and easy to understand. No more slugging through heavy technical documentation to pick out the few worthwhile nuggets.

In my opinion, Brad McGehee is one of the most effective authors of technical SQL Server literature. His commitment to raising the skill level and performance of DBAs is admirable...and appreciated!

I recommend this book to all SQL professionals looking to master this difficult subject...and save countless hours of effort in the process.
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
Read the Microsoft help files for free instead. This book is "How to select xyz columns" rather than "WHY to select xyz columns"

The author lost me at, "While you may be wary of working on a production instance, you need not be. Most of what we will do with Profiler will have minimal performance impact and can't hurt your production instance."

Actually, running Profiler in production is a really bad idea, unless you have an exemption from the business and are doing it for a short defined period.
Run it in a Test environment, and learn how to simulate load.
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
0 of 1 people found the following review helpful By Nitin C. Salgar on October 29, 2009
Format: Paperback
Well written and complete. I love books by Simple Talk

There are various other books by same publication which are equally good.
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
3 of 9 people found the following review helpful By Pirc_defense_expert on October 12, 2010
Format: Paperback
im guessing the other reviewers are friends of the author because this book is not very good. First of all, most of the book is regurgitation of ms help file on profiler. There is very little if any insight into using profiler. its all statements about terminology and where to click to do what in profiler. its stuff you can figure out quite quickly. Why he dumbed down this book so much for someone with loads of dba experience is a mystery. The title of the book should be something like intro to using sql profiler for people who know jack about sql/sqlserver.
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
Search

What Other Items Do Customers Buy After Viewing This Item?