SQLBits 2011

Working with Server Side Traces

Learn to create and customise TSQL scripts for capturing SQL Profiler data in a server side trace. Examine methods for stopping, starting and storing these traces, and finally look at free tools available for analysing the captured data.

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 E. Leo's previous sessions

Cognitive Services, Bots, and Search: Dev Tools for AI

In this session, we’ll look at the different options within the Cognitive Services suite, show you how to connect to the APIs using Python code, walk through a live bot demo, and build an Azure Cognitive Search index. You should leave this session feeling like you’ve had a jump start to further your AI developer skill set.

Building Your T-SQL Tool Kit: Window Function Fundamentals

Sets are king when it comes to SQL Server, but sometimes you need to see data row by row. Window Functions help you get the best of both worlds. Learn when and where these functions can help you get what you need without compromising performance.

Why APPLY?

Most T-SQL developers know that the APPLY operator can be used to invoke a table valued function. But do you know the other ways APPLY can be used? Come learn five additional use cases and leave with a few new tricks up your T-SQL sleeves.

What's Buried in the Plan Cache?

In this session, we'll examine the query plan cache to see what plans are saved, what plans are reused, when plans are recreated, methods for observing the contents of the plan cache, and finally, methods for manipulating plan reuse and recreation.

Working with Server Side Traces