Identifying Performance Problems with SQL 2005 Profiler

2007

TL; DR

How to use Perfmon, Visual Studio Team Edition, SQL Profiler, DTA, Analysing Trace Output and ClearTrace to identify poor performance areas in your system.

Session Details

How to use Perfmon, Visual Studio Team Edition, SQL Profiler, DTA, Analysing Trace Output and ClearTrace to identify poor performance areas in your system.

3 things you'll get out of this session

Speaker

Martin Bell's previous sessions

What’s New in SQL Server 2008 T-SQL - 2009

Powershell - old tricks for a new dog? - 2009

"SELECT TOP(@x) Name FROM MyFavouriteDMVs ORDER BY MyRanking" - 2008

Identifying Performance Problems with SQL 2005 Profiler - 2007