From SRB

SRB Survey 2007

Guestimate or Estimate number

For the SRB Survey, all we need is an approximate number of files, the size of the data managed and total number of users. It is not necessary that we need the exact numbers (as we are not doing a scientific survey).

But, if you feel your data grid has grown really large and you are not able to make an approximate guesses, you can run the script grid-summary present in $SRB-HOME/admin/Useful-Scripts/grid-summary. This will provide the statistics required in our survey.

$SRB-HOME/admin/Useful-Scripts/grid-summary

Older SRB server

On the other hand, if you are using a older SRB verison, you can use any of the appropriate SQL queries on your MCAT and find the exact number. You will have to open up your database and run these scripts. BTW, allow us to point out that its a good sign if your data grid administrator knows all these approximate numbers. We expect your datagrid administrator to know these numbers and tune your MCAT database routinely to keep SRB running faster. Our team will be happy to share our notes if required. The following SQL has to be run by your database person to find out the numbers...

To calculate SRB File Count (total amount of files by all users in your data grid):

 % select count(*) from mdas_ad_repl; 

To calculate SRB data size: (total amount of data in your data grid):

% select sum(data_size) from mdas_ad_repl
where data_id = container_id and data_size > 0
;

To calculate the number of users in your data grid: It might be appropriate to make your guess here as the not all your users might have an individual SRB user account (in some cases some project hide the SRB from end user). If your project has individual SRB user accounts, this could help...

% select count(*) from mdas_cd_user;

If you need any help, use our mailing list: srb-chat@sdsc.edu