Solved

automating Perfmon - advanced scheduling

Posted on 2004-09-16
11
3,428 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
11 Comments
 
LVL 43

Expert Comment

by:Eugene Z
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 43

Expert Comment

by:Eugene Z
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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 43

Expert Comment

by:Eugene Z
ID: 12087415
also you can use

select cpu,physical_io, memusage, * from master..sysprocesses
0
 
LVL 43

Expert Comment

by:Eugene Z
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 43

Expert Comment

by:Eugene Z
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 43

Expert Comment

by:Eugene Z
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 43

Accepted Solution

by:
Eugene Z 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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Format Date fields 11 58
Complex SQL Server WHERE CLause 9 37
Use SSRS to email customers? 4 26
How do i delete the last node in an xml in T-SQL 7 23
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

739 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