Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2012-12-10 : 09:11:48
|
| Having not used a trace before I now need to monitor CPU and Memory usage in a Trace file over a 24hr period so I can check what jobs/processes were running at that time, how do I do this? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-12-10 : 15:12:50
|
| If I understand correctly, you want to correlate profiler information with performance monitoring? |
 |
|
|
johnson_ef
Starting Member
16 Posts |
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2012-12-11 : 07:05:04
|
quote:
Originally posted by sodeep
If I understand correctly, you want to correlate profiler information with performance monitoring?
Yes, that is correct, i wish to log the usage of CPU and memory by process if possible to see what is using these resources.@johnsonThanks for the link. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-12-11 : 10:35:49
|
| Here it is http://www.simple-talk.com/sql/database-administration/correlating-sql-server-profiler-with-performance-monitor/ |
|
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
|
|
|
|
|
Creating a Trace file?