[GE users] Sample Arco SQL queries?

Andreas.Haas at Sun.COM Andreas.Haas at Sun.COM
Thu Aug 31 14:30:49 BST 2006


Good idea. Possibly Grid Engine Wiki

    http://wiki.gridengine.info/

can be used for sharing queries.

Andreas

On Wed, 30 Aug 2006, Rod.Rebello at Microchip.com wrote:

> Does anyone have sample Arco SQL queries to share?  Might be nice to set
> up an archive of various queries so others don't have to reinvent them,
> especially for those of us not proficient in SQL.
>
> For example, I'd like to develop a query to summarize pending times for
> various applications across days and weeks.  This is useful to show
> potential resource bottlenecks (licenses or compute resources).   I'd like
> a table for various pending time intervals and job counts for each
> day/week period (dates across top, pending time intervals down), something
> like this, that we currently parse out of the accounting file:
>
>
> Weekly Vsim Queue Pending Times
>
> 16-Jul
> 23-Jul
> 30-Jul
> 06-Aug
> 13-Aug
> 20-Aug
> Total
> % of Jobs
> <1min
> 13393
> 15025
> 11126
> 15130
> 20436
> 17860
> 92970
> 92.22%
> 1-5
> 993
> 1263
> 811
> 1138
> 1467
> 297
> 5969
> 5.92%
> 6-10
> 224
> 233
> 44
> 39
> 82
> 28
> 650
> 0.64%
> 11-30
> 407
> 355
> 8
> 3
> 215
> 2
> 990
> 0.98%
> 31-60
> 127
> 49
> 0
> 0
> 0
> 0
> 176
> 0.17%
>> 60
> 13
> 37
> 0
> 0
> 0
> 0
> 50
> 0.04%
>
> 15157
> 16962
> 11989
> 16310
> 22200
> 18187
> 100805
>
>
>
> - Rod
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at gridengine.sunsource.net
For additional commands, e-mail: users-help at gridengine.sunsource.net




More information about the gridengine-users mailing list