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)

One thought on “SQL Server Profiler and Query Analyzer

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s