SQL Server Profiler and Query Analyzer

This is an introductory lesson in using the SQL Server Profiler and Query Analyser.
It would make a great introduction to support staff.

However I would like a more detailed article. This only touches the surface and goes one step beyond the obvious. I would like to see a more detailed article on this. In particular how to save a trace so that the profiler can use it – useful tips like what events are required – the basics that Microsoft forgot to put in their help files.

The article does reference “Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook by Ken England (Digital Press, 2001)“