Archives of the TeradataForum

Message Posted: Fri, 05 Aug 2005 @ 10:07:56 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: PMON overhead

From:		Anomy Anom

<-- Anonymously Posted: Friday, August 05, 2005 05:53 -->

Anomy Anom wrote:

A Teradata consultant once advised our team that we should minimize the use of PMON because it requires a lot of overhead. Is that true? If so, why doesn't PMON itself show the fact that a monitor session is using a lot resources?

You have several options to minimize the resources used by PMON.

First of all you can let your users run PMON through ISS (The Teradata Manager Server datacollection service). This requires a centralized server that collectes the data on behalf off all the users. So instead of each PMON user using their own MONITOR-session - one will be shared among all users.

Secondly (as we have done) you can write your own webcomponent(s) using the COM-objects provided together with Teradata Manager and present the data on a webpage instead. Again you will have he advantage that one server is doing the job for all users.

Anyway, we have never experienced any notisable overhead. We use a dedicated user for the PMON-operations and this user consumes an average of 60-70 CPU seconds pr. day. The problem with intensive use of PMON in direct mode is the fact that you could run out of MONITOR-sessions which can cause unpleasent situations.

TD has all of the PMON-data in memory anyway, so the datacollection is basically a question of delivering the data - not collecting it on the system.

Regards


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Attachments

Library

Quick Reference