Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Creating a Trace file?
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Bill_C
Constraint Violating Yak Guru

United Kingdom
299 Posts

Posted - 12/10/2012 :  09:11:48  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 12/10/2012 :  15:12:50  Show Profile  Reply with Quote
If I understand correctly, you want to correlate profiler information with performance monitoring?
Go to Top of Page

johnson_ef
Starting Member

India
16 Posts

Posted - 12/11/2012 :  04:00:07  Show Profile  Reply with Quote
Hi Bill,

MSDN give one good page which may help you in this situation. Probably, you might have googled it, still I paste it here, for whole community can view it.

http://msdn.microsoft.com/en-us/library/cc966540.aspx

-Johnson
Go to Top of Page

Bill_C
Constraint Violating Yak Guru

United Kingdom
299 Posts

Posted - 12/11/2012 :  07:05:04  Show Profile  Reply with Quote
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.

@johnson

Thanks for the link.
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 12/11/2012 :  10:35:49  Show Profile  Reply with Quote
Here it is

http://www.simple-talk.com/sql/database-administration/correlating-sql-server-profiler-with-performance-monitor/
Go to Top of Page

Bill_C
Constraint Violating Yak Guru

United Kingdom
299 Posts

Posted - 12/12/2012 :  00:43:28  Show Profile  Reply with Quote
quote:
Originally posted by sodeep

Here it is

http://www.simple-talk.com/sql/database-administration/correlating-sql-server-profiler-with-performance-monitor/



Thanks.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000