automating Perfmon - advanced scheduling

Hi.

We want to have our Perfmon Counter Log run automatically.  Perfmon's scheduling options are pretty weak. We want to set it up to run every other Tuesday at 7:00 AM, for example.

Is there any simple way of doing this?  Say, with a Windows Scheduled Task that runs a batch file?
Does perfmon have undocumented command line parameters?

I already read this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;323314
I was hoping that there was a simpler solution.

Thanks
grandlordwendesmereAsked:
Who is Participating?
 
Eugene ZCommented:
what counters are you monitoring?
0
 
grandlordwendesmereAuthor Commented:
a few from Memory
a few from Processor
a few from Physical Disk
a few Sql server ones
Buffer manager, Databases, Locks, General Stats, Memory Manager)
and, finally System\Processor Queue Length

0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Eugene ZCommented:
if you are using SQL SERVERS 2000
there are system statistical functions that can help you

@@CPU_BUSY
@@IDLE
@@IO_BUSY
@@PACK_RECEIVED
@@PACK_SENT
@@PACKET_ERRORS
@@TIMETICKS
@@TOTAL_ERRORS
@@TOTAL_READ
@@TOTAL_WRITE
fn_virtualfilestats
0
 
Eugene ZCommented:
also you can use

select cpu,physical_io, memusage, * from master..sysprocesses
0
 
Eugene ZCommented:
also  there is in reskit
Perfmtr.exe: Performance Meter

http://www.microsoft.com/technet/prodtechnol/winntas/maintain/netmgmt.mspx

This command-line tool displays text-based information on the performance of a computer running Windows 2000.

Performance Meter can show:

CPU usage
file cache usage
header
I/O usage
POOL usage
Cache Manager reads and writes
server statistics
virtual memory usage
x86-based processor Virtual DOS Machine (VDM) usage
To use PerfMtr
At the command prompt, type:
0
 
Eugene ZCommented:
one more from MS_DOS command
that you can run from sql server
with xp_cmdshell command as job,

Typeperf.exe: Performance Data in the Command Window

http://www.microsoft.com/windows2000/techinfo/reskit/en-us/default.asp?url=/windows2000/techinfo/reskit/en-us/core/fneb_mon_bhod.asp
0
 
Eugene ZCommented:
use the exec in test environment at first from

batch file with control of time stop the batch execution CTL+C
0
 
catfinkCommented:
I know this question has been closed, but others may seek to do the same thing, so here is my solution:

1.  Open PerfMon and setup your counters
2.  Save the perfmon file on your drive
3.  Create a batch file that starts the perfmon file you saved, i.e.
     start myperfmon.msc
4.  Create a Scheduled Task to run each Tuesday at 7PM (per your request) and have it execute the batch file.

I currently do this and it works perfectly.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.