February 6, 2013 at 8:06 am
I've some concerns about some of the 'maintenance jobs' created by my developers & the impact on the server's performance. These jobs usually run late at night to early in the morning. I thought I run Profiler when these jobs ran, so that I could start to get a handle on what they are doing. How do I schedule Profiler to Start and Stop at specific times?
February 6, 2013 at 8:09 am
create a server side trace, then just before the jobs start, have a job which starts the trace, to stop it ensure you put a stop time in the create trace command.
There is a stairway on server side tracing in the stairways section.
February 6, 2013 at 9:05 am
Gail also covers setting up server-side trace in her articles on query tuning[/url].
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 6, 2013 at 11:26 am
Thanks everyone.
Gail's article was especially helpful.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply