RAL Tier1 Metrics for GridPP

The RAL Tier1 must produce every quarter metrics for the GridPP project.

For each metric the method that is used to collect the information is given. Also included are comments on what is being measured and how reliable the information is.

0.101 Number of registered users (DNs excluding DTEAM)

This is currently calculated from the grid-mapfile on the CE.

 # grep -v dteam /etc/grid-security/grid-mapfile | wc -l
 1342

Quarter	2005 Q4	2006 Q2	2006 Q4	2007 Q3
Value	1342	1831	2726	5633

In the future as more features of VOMS are enabled the grid-mapfile will begin to empty of users. We will have to download a list of valid users from each VOMS server.

0.102 Number of active users (DNs excluding DTEAM)

This is calculated from the APEL database.

  mysql> select DISTINCT LCGUserID from LcgRecords where LCGUserVO != 'dteam' and 
                 YEAR(EventDate) = 2006 and MONTH(EventDate) >= 4 and 
                 MONTH(EventDate) <= 6 group by LCGUserID ;

  mysql> select LCGUserID,count(*) as jobcount from LcgRecords where LCGUserVO != 
                 'dteam' and  YEAR(EventDate) = 2006 and MONTH(EventDate) >= 4 and
                 MONTH(EventDate) <= 6 group by LCGUserID having jobcount >= 10;

Quarter	2005 Q4	2006 Q1	2006 Q2	2006 Q3	2006 Q4	2007 Q1	2007 Q2	2007 Q3
Value	83	166	201	203	246	310	311	282
>=10 jobs	n/a	94	126	121	154	168	188	166

Also a break down of active UK certificates is available.

   mysql> select DISTINCT LCGUserID from LcgRecords where LCGUserVO != 'dteam' and
                 LCGUserID like '/C=UK/O=eScience%' and  
                 YEAR(EventDate) = 2006 and MONTH(EventDate) >= 4 and 
                 MONTH(EventDate) <= 6 group by LCGUserID ;

Quarter	2005 Q1	2005 Q2	2005 Q3	2005 Q4	2006 Q1	2006 Q2	2006 Q3	2006 Q4	2007 Q1	2007 Q2	2007 Q3
Value	10	19	29	37	44	55	53	57	62	58	45

0.116 Percentage of jobs run via the grid (based on Tier-1 stats)

Percentage bar graph of Grid/Non-Grid usage for 2006

Percentage bar graph of Grid/Non-Grid usage for 2007

0.128 T1 meeting JRA1 commitments.

Not being met.