Where are your bottlenecks?
I'm sure most people reading this will be aware of the joys of trace.view but I've never *really* got it to show me where my main bottlenecks are. It's just a bit too much like hard work to be honest.
Enter ANTS profiler.
Absolutely superb piece of kit that needs to be in every developers toolkit - whether ASP.NET or winforms. Even those freaky C# guys.
What it does is sit in the background while you run your app, clicking about and emulating the actions of a user.
When you've finished, it opens up a history of activity, the top 100 slowest functions and allows you to actually drill down into the relevent piece of code. There's even a nice little red bar for those really slow calls.
S'very nice. You can get it here
www.red-gate.com If you're serious about tweaking your code, I definitely think its worth it.
However, if you're happy with functions that take 2seconds - stick with the trace :P