Trade in Mastering SQL Server Profiler for an Amazon.co.uk gift card of up to £1.55, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more
SQL Server Profiler is one of the most useful of SQL Server's "built-in" tools, recording data about various SQL Server events. "Mastering SQL Server Profiler" will make it easier for you to learn how to use Profiler, analyze the data it provides, and to take full advantage of its potential for troubleshooting SQL Server problems. All the examples have been optimized to work with both SQL Server 2005 and 2008.
{"itemData":[{"priceBreaksMAP":null,"buyingPrice":17.26,"ASIN":"1906434158","isPreorder":0},{"priceBreaksMAP":null,"buyingPrice":19.99,"ASIN":"1906434026","isPreorder":0},{"priceBreaksMAP":null,"buyingPrice":19.99,"ASIN":"1906434603","isPreorder":0}],"shippingId":"1906434158::7oxGRcPw53UOm6HGDvf75%2BGpO3NRhH2twxgD1OEre1dMvc0kIDrMbUzn%2FC43VgDTzde2D8F4a9%2Fg%2BH4%2FXpgTCTPBJlmsZHYT,1906434026::QMb1NOwJmIj48FWd00fRnvQtRIWPUdXBM3HNAk1FzhsB%2F20D86wNAU0Y3Yg67xXo9DUoGUkDxeO1mhWBSchjY6keSUF%2BIZqX,1906434603::v6zQ7n%2FnnIo6Ym4p3Jqjyyj6j5JxTopKpzeUwjWq60x2FSgQCedp5T%2BHnghkG0shSAXQvfTJDzSffweaxMZhw5L66gTYsNpN","sprites":{"addToWishlist":["wl_one","wl_two","wl_three"],"addToCart":["s_addToCart","s_addBothToCart","s_add3ToCart"],"preorder":["s_preorderThis","s_preorderBoth","s_preorderAll3"]},"currenyCode":"GBP","shippingDetails":{"xz":"availability","yz":"same","xy":"availability","xyz":"availability"},"tags":["x","y","z"],"strings":{"showDetails":"Show details","differentAvailabilityAll":"Some of these items are dispatched sooner than the others.","addToWishlist":[null,null,null],"shippingError":"An error occurred, please try again","differentAvailability":"One of these items is dispatched sooner than the other.","preorder":["Pre-order this item","Pre-order both items","Pre-order all three items"],"addToCart":["Add to Basket","Add both to Basket","Add all three to Cart"],"showDetailsDefault":"Show availability and delivery details","priceLabel":["Price:","Price For Both:","Price For All Three:"],"hideDetailsDefault":"Hide availability and delivery details","hideDetails":"Hide details"}}
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:4.2 out of 5 stars 4 reviews
5 of 5 people found the following review helpful
5.0 out of 5 starsA must-read for anyone administrating a Sql box24 Sep 2009
By David Martin - Published on Amazon.com
Format:Paperback|Amazon 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.
4 of 4 people found the following review helpful
5.0 out of 5 starsMastering Profiler Review11 July 2009
By Douglas S. Tombow - Published on Amazon.com
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.
0 of 1 people found the following review helpful
5.0 out of 5 starsInformative29 Oct 2009
By Nitin C. Salgar - Published on Amazon.com
Format:Paperback
Well written and complete. I love books by Simple Talk
There are various other books by same publication which are equally good.