New Microsoft SQL Server Video Tutorial: Pt. 3 - What Do You Do With Your Trace Data? How to Write Queries Against Your Trace

Pt. 3 - What Do You Do With Your Trace Data? How to Write Queries Against Your Trace - view details

Do you want to know how many times a query has run in your trace? What about finding aggregates like what the minimum duration, maximum duration, and average durations/page reads/CPU? This is a great video that teaches you how to manipulate the trace data into a table for querying. Even then, you still have some work to do...

Highlights from this video:

• How to save a trace to a table
• Querying trace tables
• Writing reporting-style queries against traces
• Working with ntext data types and GROUP BY/WHERE clauses
• Modifying your trace table to make it usable in aggregates
• Saving the queries traced to a SQL file

and much more

• Category: Performance Tuning SQL Queries: Indexes and Execution Plans
• Skill Level: 400 (Intermediate - Advanced)
• Length: 11:30 (0.00MB)
• Applies to Versions: SQL Server 2000
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required

Note: You must have the TSCC codec installed to view this video