Working with Server Side Traces
You may have heard that you should always use a server-side trace to capture SQL profiler data, but do you know how to create one? Can you tweak to make it work to your liking? Furthermore, do you know how to process the data you’ve captured? If not, then this session is for you.
First, we’ll examine the anatomy of a profiler trace script and look at the different ways to customise the data being retrieved. Then, we’ll talk about methods for stopping and starting the trace, how to know what traces are already running, and ways to schedule a trace to start under certain server conditions. Lastly, we will look at the different tools available to you for analysing the data you’ve gathered, including the SQL Server Profiler client application, “home-grown” T-SQL queries, ClearTrace, and the ReadTrace component of the RML Utilities.
Christina Leo is a Netherlands based, independent consultant specializing in T-SQL development and performance tuning. She happily shares her 14 years of technical experience with the SQL Server community by teaching at local and international SQL Server user group meetings and technical events, including multiple SQL Saturdays, SQL Bits, TechEd Africa, and the PASS Summit.