Stairway to Server-side Tracing
Learn how to use the SQL Trace subsystem in SQL Server to audit your instances. This series will examine the basics of SQL Trace and teach you how to set up, schedule, and manage traces and the data generated.
- The first part of our stairway series on SQL Trace examines the overview of this subsystem in SQL Server, it's architecture and the kind of information it returns.
- This is the second article in our Stairway Series on SQL Tracing. Learn how to build traces in code with T-SQL.
- In this third article of our Stairway Series on tracing, Dan Guzman goes into the method of using Profiler to help you create a custom trace of the events that you need to monitor.
- An introduction to the SQL Server default and black box traces targeted at DBAs who are new to these specialized traces. The article shows how to enable and disable the default trace feature and create a black box trace. The captured events are discussed along with how to view current and historical trace data of these traces.
- An introduction to the SQL Trace catalog views and functions used to view existing trace definitions targeted at DBAs and Developers. The article discusses T-SQL queries to view defined traces, query trace status and start/stop/delete traces.
- How to import a trace file into a table using T-SQL and the Profiler tool, for subsequent ad-hoc analysis.
- How to use SQL Jobs, scripts and SSIS to manage traces and trace data collection.
- Level 8 of this stairway series looks at the automation of your tracing using Integration Services.
- In this level you will see how to employ the Data Collector feature of SQL Server to automate management of SQL Traces among multiple servers.
- Compares and contrasts tracing using Profiler with server-side tracing, illustrating important performance differences so that one can choose the right tool for the task at hand.