Trending

Wednesday, January 8, 2014

SQL Server: Collecting and Analyzing Trace Data

Learn how to collect trace data and use it to help with tasks like troubleshooting performance and workload benchmarking, applicable for developers and DBAs from SQL Server 2005 onwards
One of the easiest ways to collect information about SQL Server workloads is to capture trace information. This course will introduce you to using SQL Trace and SQL Profiler for tracing SQL Server activity, including common pitfalls and problems to avoid. You’ll learn how to analyze the collected information using a variety of methods that will help with performance troubleshooting, workload benchmarking, activity auditing, and much more. The course is perfect for developers and DBAs who need to collect information about workloads running on SQL Server for analytic purposes. The information in the course applies to all versions from SQL Server 2005 onwards.



Table of content

Introduction
  • Introduction
  • Collecting Trace Information
  • Workload Analysis
  • Course Structure
SQL Trace Architecture
  • Introduction
  • What is SQL Trace?
  • What are Events?
  • The Trace Controller
  • Event Producers
  • Traces
  • I/O Providers
  • When to use SQL Trace
  • Security Considerations
  • Summary
Using SQL Server Profiler
  • Introduction
  • What is Profiler?
  • Creating New Traces
  • Demo: Creating a New Trace from Scratch
  • Demo: Creating a New Trace from a Template
  • Demo: Creating a New Trace from a Trace File
  • Filtering Trace Events
  • Trace Templates – Introduction
  • Trace Templates – SP_Counts and Standard
  • Trace Templates – TSQL and TSQL_Duration
  • Demo: TSQL_Duration Template
  • Trace Templates – TSQL_Grouped and TSQL_Locks
  • Trace Templates – TSQL_Replay and TSQL_SPs
  • Trace Templates – Tuning
  • Demo: Trace Templates
  • Saving Captured Data
  • Demo: Saving Captured Data
  • Tips for Tracing with Profiler
  • Summary
Server-Side Trace
  • Introduction
  • Performance Comparison
  • The SQL Trace DMVs
  • Demo: Trace DMVs
  • Programmatically Creating Traces
  • sp_trace_create
  • sp_trace_setevent
  • sp_trace_setfilter
  • sp_trace_setstatus
  • Demo: Programatically Creating Traces
  • Generating Trace Scripts with Profiler
  • Demo: Scripting Trace from Profiler
  • Summary
Tracing Scenarios
  • Introduction
  • Default Trace in SQL Server
  • Events Captured by the Default Trace
  • Common Questions about the Default Trace
  • Scenarios to use the Default Trace
  • Demo: Default Trace
  • Identifying Blocking Issues
  • Demo: Identifying Blocking Issues
  • Identifying Deadlock Issues
  • Demo: Identifying Deadlock Issues
  • Identifying Recompile Issues
  • Demo: Identifying Recompile Issues
  • Security and Compliance Auditing
  • Demo: Security and Compliance Auditing
  • Capturing a Tuning Workload
  • Demo: Capturing a Tuning Workload
  • Capturing a Replay Workload
  • Demo: Capturing a Replay Workload
  • Common Trace Mistakes
  • Summary
Analzying Trace Data
  • Introduction
  • Analyzing Trace Data with Transact-SQL
  • Demo: Analyzing Trace Data with Transact-SQL
  • Analyzing Data in Profiler
  • Demo: Analyzing Data in Profiler
  • Demo: Merging PerfMon Data in Profiler
  • Extracting Trace Events
  • Demo: Extracting Trace Events
  • Normalizing Trace Data
  • Demo: sp_get_query_template
  • Demo: ReadTrace from RML Utilities
  • Demo: ClearTrace
  • Database Tuning Advisor Workload Analysis
  • Demo: DTA Workload Analysis
  • Summary
Replaying Trace Workloads
  • Introduction
  • Profiler Replay
  • Profiler Replay Requirements
  • Demo: Profiler Replay
  • RML Utilities OStress Replay
  • RML OStress Replay Requirements
  • Demo: RML Ostress
  • SQL Server 2012 Distributed Replay
  • Distributed Replay Requirements
  • Demo: Distributed Replay
  • Replay Tool Limitiations
  • Replay Tool Benefits
  • Which Tool to Use?
  • Summary
 

Uploaded.net

  1. http://ul.to/3rswc5vo
  2. http://ul.to/r486mpr2
Cloudzer.net
  1. http://clz.to/file/lvdgveiq
  2. http://clz.to/file/ibj3uwqv

No comments:

Post a Comment

About

Contact Form

Name

Email *

Message *

Copyright © 2013 TOTdownload.com
Designed By Blogger Templates