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 |
|
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! |
 |
|
|
|
|
|