VMS "Hot Files" listing

[Jack Trachtman]

Does anyone know of a "hot files*" listing program besides CA's TNG Unicenter (the old DEC Performance Advisor)?

* HotFiles: those open files on a disk that are accessed most (over some period of time)

[Ian Miller.]

Does
$ SHOW MEMORY/CACHE=(TOPQIO,VOLUME=diskname)

do what you want?

[Jack Trachtman]

Ian,

Your suggestion only works with XFC, which doesn't help me since we have both Oracle and Cache on the systems that I'm primarily interested on and they bypass any VMS cache.

[Volker Halle]

Jack,

the PERFDAT data collector and capacity planner developed by HP Austria allows IO data collection based on process, file and file per process.

There are slides from a DECUS 2004 presentation available:

http://www.decus.de/slides/sy2004/22_04/3d04.pdf

The kit comes with a 30 day temporary license key. Send mail to perfdat@hp.com

Volker.

[Michelle Popejoy]

You could also check out PerfCap www.perfcap.com

The one key PolyCenter product that CA didn't buy from DEC and put in Unicenter was the Capacity Planner. The developers eventually spun off their own company (PerfCap) and redeveloped data collection and the performance graphing and reporting (but not "advising"). They also developed PAWZ (Performance Analysis Web Zone), for which there's a demo on their site. I found that even though the OpenVMS systems were not currently collecting, I was able to choose one, go into Analyze, then graph File I/O, Show Top Hot Files. You just have to choose a Graph Period that has a hot file (I found that Jan. 10th or Jan. 3rd, node GO4CP had three hot files).

Cheers,
Michelle

[Ian Miller.]

ECP may do want you want
http://h71000.www7.hp.com/openvms/products/ecp/

[Volker Halle · Accepted solution]

Ian,

ECP does not provide hot file statistics.

Compared to the other performance data collectors, ECP only provides very basic performance metrics, but it's free and it's a VMS-only solution.

Volker.

[Jack Trachtman]

I've just noticed that VMS V7.3-2 (& V8.2) now include TDC (The Data Collector).

Does anyone know if this collects info that could easily be extracted to create a Hot Files list?

[Volker Halle]

Jack,

it doesn't look like TDC is able to provide 'hot file' data.

See table at bottom of the following page:

http://h71000.www7.hp.com/openvms/products/tdc/

Volker.

[Cass Witkowski]

We use DSM and have the database disks mounted with /nocache. Even though there is no caching XFC does still collect counters on the volumes and files on the volumes.

so the SHOW MEM /CACHE command should still give you some usefull data.

Cass

[Jack Trachtman]

Cass,

Thanks - it looks like this will help me! but I need to enable XFC this weekend on the
systems in question.