November 7, 2008 at 7:41 am
Is there anyway to trace the post performance? any script that you can capture the off hours information about system slowness? Please help. Thanks
November 7, 2008 at 8:37 am
Off hours information of system slowness?
I'm guessing that setting a trace using Profiler and getting monitoring information using Performance Monitor will do what you need.
"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
November 7, 2008 at 8:54 am
Yeah like server side tracing. I want to create a job which runs in perticular time to trace the activity.
November 7, 2008 at 9:05 am
Easily done. You can set up a Profiler job to look exactly like what you want to monitor. Export that job to a SQL file using File, Export, Script Definition. You can include a stop time or a run period (run for 5 hours, for example) Once you've got your TSQL, create a SQL Agent Job and schedule it to run the script. Ta Da!
"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
November 7, 2008 at 1:09 pm
Thanks. I will try doing that. But look at this site and advise me. I am confused where to start- There are no steps.
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
November 10, 2008 at 5:56 am
That's a very good description of how to get started. If you need something a bit more fundamental, try this article on SimpleTalk[/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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply