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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 need help in using the Perfmon

Author  Topic 

kid_on_the_block
Posting Yak Master

172 Posts

Posted - 2006-03-23 : 00:41:00
Hi

I have to give a report out stating the Min,Avg & max values of the memory utilization .

Now when I run the perfmon it shows me the values , but these are dynamic , I have to get theses values at the end of 8 hours of the shift ....

How can that be done , does anyone have any link to some tutorials or some explanation plz

Thanks

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2006-03-23 : 03:11:24
Hmm - well, you could consider having perfmon create a log that runs from a point in time, until a point in time. Then you'll have the log to replay, review, take snapshots from etc.

Open perfmon.
Open Performance Logs and Alerts.
Select Counter Logs.
In righthand pane, right click and select New Log Setting.
..add counters, give name, use Schedule tag to select time to run etc.

be careful of adding too much and having too large a file (see the file managment tab).

HTH

*##* *##* *##* *##*

Chaos, Disorder and Panic ... my work is done here!
Go to Top of Page
   

- Advertisement -