asked on

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

EugeneZ

what counters are you monitoring?

grandlordwendesmere

ASKER

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

EugeneZ

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

EugeneZ

also you can use

select cpu,physical_io, memusage, * from master..sysprocesses

EugeneZ

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:

EugeneZ

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

EugeneZ

use the exec in test environment at first from

batch file with control of time stop the batch execution CTL+C

ASKER CERTIFIED SOLUTION

EugeneZ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

catfink

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.