Solved

automating Perfmon - advanced scheduling

Posted on 2004-09-16
11
3,419 Views
Last Modified: 2008-12-08
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
0
Comment
Question by:grandlordwendesmere
  • 7
11 Comments
 
LVL 42

Expert Comment

by:EugeneZ
ID: 12078385
what counters are you monitoring?
0
 

Author Comment

by:grandlordwendesmere
ID: 12079009
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
 
LVL 42

Expert Comment

by:EugeneZ
ID: 12087391
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
 
LVL 42

Expert Comment

by:EugeneZ
ID: 12087415
also you can use

select cpu,physical_io, memusage, * from master..sysprocesses
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 42

Expert Comment

by:EugeneZ
ID: 12087536
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
 
LVL 42

Expert Comment

by:EugeneZ
ID: 12087589
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
 
LVL 42

Expert Comment

by:EugeneZ
ID: 12087628
use the exec in test environment at first from

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

Accepted Solution

by:
EugeneZ earned 100 total points
ID: 12087664
0
 

Expert Comment

by:catfink
ID: 23123304
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

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now