• Menu
  • Skip to right header navigation
  • Skip to main content
  • Skip to secondary navigation
  • Skip to primary sidebar

OnlineProgrammingBooks.com

Legally Free Computer Books

  • All Categories
  • All Books
  • All Categories
  • All Books
  • About Us
  • Privacy policy
  • Disclaimer
  • Subscribe
  • Contact
You are here: Home ▶ Databases ▶ Mastering SQL Server 2005 Profiler

Mastering SQL Server 2005 Profiler

August 18, 2009

Free eBook: Mastering SQL Server 2005 Profiler

Free eBook “Mastering SQL Server 2005 Profiler” by Brad McGehee, DBA expert with over 12 years’ experience. SQL Server Profiler is one of the most useful of SQL Server’s “built-in” tools, recording data about various SQL Server events.

Book Description

“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.

Most DBAs are still using SQL Server 2005, so all the examples in this book are based on SQL Server 2005 Profiler. However, the differences between SQL Server 2005 and SQL Server 2008 are minimal. While you may notice some minor cosmetic changes between the two editions, and discover that SQL Server 2008 includes a few new events, every example in this book will work with SQL Server 2008 and everything you learn here is applicable to both SQL Server 2005 and SQL Server 2008. In fact, most of what is covered in this book also applies to SQL Server 2000, although you will want to
use the SQL Server 2005 Profiler tool to access your SQL Server 2000 instances.

Table of Contents

  • Getting Started with Profiler
  • Working with Traces and Templates
  • Profiler GUI Tips and Tricks
  • How to Identify Slow Running Queries
  • How to Identify and Troubleshoot SQL Server Problems
  • Using Profiler to Audit Database Activity
  • Using Profiler with the Database Engine Tuning Advisor
  • Correlating Profiler with Performance Monitor
  • How to Capture Profiler Traces Programmatically
  • Profiler Best Practices
  • Profiler Events and Data Columns Explained

Download Free PDF / Read Online

Author(s): Brad M McGehee
Format(s): PDF
File size: 16.60 MB
Number of pages: 306
Link: Download.

Similar Books:

  1. Windows Server 2008 Essentials
  2. Best of SQL Server Central Vol 5
  3. Brad’s Sure Guide to SQL Server 2008
  4. VMM 2008 Virtualization Essentials
  5. Introducing Microsoft SQL Server 2008 R2(pdf)
Previous Post: « How to Become an Exceptional DBA Second Edition
Next Post: SQL Server Execution Plans »

Primary Sidebar

Get Latest Updates

  • Facebook
  • Pinterest
  • RSS
  • Twitter
  • YouTube
  • About Us
  • Privacy policy
  • Disclaimer
  • Subscribe
  • Contact

Copyright © 2006–2023 OnlineProgrammingBooks.com