BAT & Perfmon

[Eric]

Does anyone know if there is a way to use Batch files or CommandLine() to start performance monitoring (windows Run command perfmon)on the server, NOT TM1 Server with performance cubes. As always trying to see how many ways I can circumvent the IT department when executing new ETL's on Dev.

[Daniel Lennon]

Hi Eric,

You could always use VB in Excel...

Sub PerfMon()
Shell "perfmon", 1
End Sub

Kind Regards,
Daniel.

[rossi]

Hi Daniel
Do you have an example of the VB please?
thank you
Paolo
prossi45@hotmail.com

[Daniel Lennon]

Sub PerfMon()
Shell "perfmon", 1
End Sub

Kind Regards,
Daniel.

[rossi]

cheers for that
Paolo

[Eric]

I used the command line to open an excel file that when it opens it runs the perfmon shell and then closes the excel file. Works perfect thanks!

Ok dumb question time.

How do I stop the perfmon in VBA?

[Steve Rowe]

A complete guess, did you try Shell "perfmon",0 ?

[Andy Key]

Eric,

If you want to use the same Excel approach you can use:

Code: Select all

Sub ClosePerfMon()
   AppActivate "Performance"
   SendKeys "%{F4}", True
End Sub

Note: "Performance" is the title of the PerfMon window under XP, check that it is the same under your server OS, and %{F4} translates to Alt F4.

You need to be aware though, that if you have other foreground applications running on that server and one of those grabs the focus between the AppActivate and the SendKeys it will get the Alt F4 sent to it rather than to PerfMon.

[Eric]

Awesome!

Think I can use the same methodology to kill winzip after a backup? (If anyone doesn't know. If you call winzip via TI it will zip everythin, but it will not close after it is completed.

[Andy Key]

Eric,

Can you not use the WinZip command line interface (WZZIP)?

[Mike Cowie]

Just to add another command-line zipping utility to the list, I've had really good luck using 7ZIP, which is freeware:
http://www.7zip.com/

I haven't used it directly from TM1, but have done some extracting and zipping from other apps where a command-line EXE was needed.

Regards,