How can I quantify and compare the workload different queries impose on the server. I've explored Query Analyzer with the EXecution Plan, Server Trace, and Client Statistics - but I don't really understand how to quantify how taxing each SQL statement is on the server.

Any best practices or Online Help resources is appreciated.

Thanks,

Alex