profiler - automate when it should start

25112
25112 used Ask the Experts™
on
in profiler (r2) i see that you can set an end time for the profiler.. but i can't see any 'start time' that be setup..

is it possible?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
The only other way I could think of is to script the trace definition from the profiler and convert the script to a stored procedure may be and then schedule it thru the sql server jobs.
Commented:
See venk_r's comment.

Profiler is putting extra load on your server so it should be used with care. Many of the things you may want to monitor with profiler you can retrieve in the dynamic management views that are kept anyhow.  

http://sqlserverpedia.com/wiki/DM_Objects_-_Sys.dm_exec_query_stats
http://msdn.microsoft.com/en-us/library/ms188068.aspx

If you know that the statistics are cumulative (from last restart)  to monitor a certain periode it's necessary to have a snapshot from before.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial