topic Re: VMS "Hot Files" listing in Operating System - OpenVMS

VMS "Hot Files" listing

Jack Trachtman — Wed, 23 Mar 2005 11:34:50 GMT

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)

Re: VMS "Hot Files" listing

Ian Miller. — Wed, 23 Mar 2005 11:39:56 GMT

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

do what you want?

Re: VMS "Hot Files" listing

Jack Trachtman — Wed, 23 Mar 2005 12:08:20 GMT

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.

Re: VMS "Hot Files" listing

Volker Halle — Wed, 23 Mar 2005 12:23:33 GMT

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.

Re: VMS "Hot Files" listing

Michelle Popejoy — Thu, 24 Mar 2005 09:40:09 GMT

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

Re: VMS "Hot Files" listing

Ian Miller. — Thu, 24 Mar 2005 11:52:22 GMT

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

Re: VMS "Hot Files" listing

Volker Halle — Thu, 24 Mar 2005 12:02:55 GMT

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.

Re: VMS "Hot Files" listing

Jack Trachtman — Thu, 24 Mar 2005 18:28:47 GMT

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?

Re: VMS "Hot Files" listing

Volker Halle — Fri, 25 Mar 2005 02:44:06 GMT

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.

Re: VMS "Hot Files" listing

Cass Witkowski — Wed, 06 Apr 2005 00:45:35 GMT

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

Re: VMS "Hot Files" listing

Jack Trachtman — Wed, 06 Apr 2005 10:37:15 GMT

Cass,

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