November 13th 11:00 AM CST

Jason Spangler - Profiler? What is this Tool you Speak of?

Meeting Details

Many new DBA's are unaware of the power of SQL Profiler. Many don't know it exists. And better yet, it's FREE. This session will generalize the importance of using Profiler to troubleshoot and tune your SQL queries. By demonstrating Profiler on a running server, attendees will get a look at what SQL is currently executing. This session will show how to discover query duration, reads, writes, locks, deadlocks, stored procedure executions and more.

Jason is a SQL Server DBA by day, and a Firefighter/EMT by night. Since 2001, he has been a full time DBA with additional duties in Altiris, Sharepoint, and software development. He has achieved MCITP for SQL Server 2008 DBA and MCTS in Database Development. As an active member in PASS, he has presented several times at SQL Saturday events. For 12 years, he has also been a volunteer Firefighter and EMT helping his community through fire prevention and teaching firefighting and vehicle extrication techniques to new firefighters.