Friday, April 10, 2009

PASS Sessions Submitted, Should I Be Committed?

Well, even though the deadline was extended 2 weeks, I got 2 sessions submitted for the PASS Summit submitted by the original deadline.  Now the question is, should I be committed for even attempting to speak at a national (international) event?

Here are the sessions:

Profiler: An Underused Tool

Profiler has been around for awhile, but is often left in the DBA's toolbox. Profiler is a flexible tool that can be used for Auditing, Monitoring, and Performance Tuning

Goals:

  1. Understand when, why, and how to use Profiler
  2. Understand the differences between Profiler and server-side tracing.
  3. Understand performance and security considerations for using Profiler.

Dive into the Default Trace

Beginning with SQL Server 2005 there is a server-side trace installed and started by default in every SQL Server installation. Not many DBA's take advantage of the wealth of information collected through this trace. This trace includes 34 events in 2005 and 35 events in 2008 that audit non-DDL activity on your SQL Server.

Goals:

  1. Learn what events are included in the Default Trace.
  2. Learn how to query the Default Trace
  3. Learn how to process the Default Trace files to keep the information beyond the default amount of data (5 20MB files).

Now that I’ve submitted, how about you?

1 comment:

  1. You're mad, Jack!!! But you shouldn't be committed. You should be rolled back.

    ReplyDelete

So what do you think I am?