SQL Server Tools, Tricks, and Techniques

SQT14 SQL Server Tracing for Developers

11/19/2013

4:15pm - 5:30pm

Level: Introductory to Intermediate

Jason Strate

Database Architect

Pragmatic Works

Developers are often on the receiving end for poor database performance. To combat this practice, developers need access to a set of tools that they can use to investigate the problems that they encounter. These can be as simple as investigating queries with simple performance issues to more complex issues, such as identifying the causes for connection timeouts. In this session, we'll explore the tools available for tracing and information on how to get access to those tools.

You will learn:

  • Explanation of issues with tracing for developers
  • Introduction to extended events platform
  • Walk-through to scripting and using GUI to create extended event sessions
  • Demonstration of information available through extended events