The profiler doesn't have a snapshot model. It has a "time-line" model where you profile all of your application and if you need to filter out specific times, you can click and drag on the time line.
So, two things that might help you are "user events"- this is a way of 'synchronizing' your code to the time line. Please check the out here:
http://www.red-gate.com/supportcenter/C ... wledgebase
(its not restricted to ASP.NET).
Secondly, as far as automation of a profiling session goes, we have the command-line version called profiler.exe. Deatils here:
http://www.red-gate.com/supportcenter/C ... e_Profiler