[Oslc-pm] Some additional metric subclasses to consider for 2.0 perf mon vocabulary

[John Arwe]

My only guidance (not objection) would be to be careful about 

(1) Keep them as widely applicable (fewest restrictions on the semantics) 
as possible, so they are more easily re-used.

ConnectionEntriesUsed (the strawman) is a better than FCM
ConnectionEntriesUsed would have been.  I will note that in this specific 
case, the description and the term name are not obviously equivalent.  If 
the "FCM" is a critical required part of the semantics, rather than an 
exemplary use, you probably care about that.  If we allow multiple types 
on an ems:Measure (I think we do), the FCM could be added as a second type 
in an instance so the base term is more widely re-usable.


(2) Avoiding anything that tightly couples a metric to exactly one or even 
to very few implementation(s) unless they are very widely deployed.

Database Managed Space (DMS) and "locklist" *might* be proprietary or 
single-implementation terms, so I'd want to be clear that those 
particulars are exemplary rather than limiting.  If the next DBMS that 
wanders in also has a DMS-equivalent concept with a different name, I'd 
want the community to re-use this same PerfMon vocabulary term by default.



Best Regards, John

Voice US 845-435-9470  BluePages
Tivoli OSLC Lead - Show me the Scenario


"Oslc-Pm" <oslc-pm-bounces at open-services.net> wrote on 12/03/2012 10:48:09 
AM:

> From: Julianne Bielski/Raleigh/IBM at IBMUS
> To: oslc-pm at open-services.net
> Cc: Jing Qiong Liu <liujingq at cn.ibm.com>
> Date: 12/03/2012 10:48 AM
> Subject: [Oslc-pm] Some additional metric subclasses to consider for
> 2.0 perf mon vocabulary
> Sent by: "Oslc-Pm" <oslc-pm-bounces at open-services.net>
> 
> All,
> 
> There's a number of metrics related to database and database server 
> performance health that I believe should be added to the 2.0 
> vocabulary in support
> of our scenarios.
> 
> Please consider these, and by EOW, if there are no objections, I 
> will add them as subclasses:
> 
> 1. http://open-services.net/ns/perfmon/#BufferPoolHitRatio
> 
> This attribute can determine whether buffer pool assignment is 
> efficient. If the pool hit ratio is low, increasing the number of 
> buffer pool pages might improve performance.
> 
> 2. http://open-services.net/ns/perfmon/#ConnectionEntriesUsed
> 
> The percentage of FCM connection entries used during processing 
> within the partitioned database server. If the percentage of FCM 
> connection entries used is high compared to normal operating levels,
> you can increase the number of FCM connections; if the percentage is
> low compared to normal operating levels, you can decrease the value.
> 
> I have an outstanding question to the database SME asking how "high"
> or "low" affects performance of the database server.
> 
> 3. http://open-services.net/ns/perfmon/#TableSpaceUsed
> 
> The percentage of space used in the Database Managed Space (DMS) 
> tablespace. Use the returned value to determine if the
> tablespace needs more space.
> 
> 4. http://open-services.net/ns/perfmon/#LockListUsed
> 
> The percentage of space used in the locklist of this database. Use 
> the returned value to determine how much of the locklist space is 
> free for new locks to be requested. 
> 
> 5. http://open-services.net/ns/perfmon/#SortOverflows
> 
> Percentage of application sorts that overflowed during the 
> monitoring interval. An overflow occurs when a sort has run out of 
> space in the sort heap and requires disk space for temporary 
> storage. If this percentage is high, you might want to adjust the 
> database configuration by increasing the value of the SORTHEAP 
> configuration parameter. 
> 
> I have an outstanding question to the database SME asking how "high"
> or "low" percentage of overflows affects performance of the database 
server.
> 
> 
> -- Regards,
> 
> Julianne Bielski, STSM
> ITM Core Chief Architect
> Tivoli, IBM Software Group
> tel: (919) 224-1170      (T/L) 687-1170
> e-mail: bielsk at us.ibm.com
> 
> "All growth is a leap in the dark, a spontaneous unpremeditated act 
> without benefit of experience." — Henry Miller
> _______________________________________________
> Oslc-Pm mailing list
> Oslc-Pm at open-services.net
> http://open-services.net/mailman/listinfo/oslc-pm_open-services.net

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://open-services.net/pipermail/oslc-pm_open-services.net/attachments/20121207/f9fa776b/attachment-0003.html>