Re: want to monitor top 10 heavy sql statements to IDS server.
Hi,
There is on product called Server Studio JE. you can
take advantage of this product.
Thanks
Anup
--- Dick Cunningham <Cunnind@co.thurston.wa.us> wrote:
> Guo,
>
> I use this simple bit of script to show active
> queries by descending expense:
>
> database sysmaster;
> select first 15 sqx_estcost cost,
> syssessions.username[1,10] User,
> syssessions.tty[1,10],
> sqx_iscurrent Crnt,
> sqx_sessionid sid,> TRIM(sqx_sqlstatement[1,25]) sql
> from syssqexplain, syssessions
> where sqx_iscurrent = 'Y'
> where sqx_sessionid = syssessions.sid
> and sqx_sessionid <> DBINFO('sessionid')
> order by sqx_iscurrent desc, sqx_estcost desc;
>
> Not very sophisticated, but effective enough for our
> purposes.
>
> Dick Cunningham
> Thurston County
>
> >>> "Guo Dong Wan " <wanguod@cn.ibm.com> 10/24/05
> 5:30 PM >>>
> Hello all,
>
> We have one customer project, our customer
> would use tivoli to
> monitor IDS server status, and they want to get the
> top 5 or top 10 heavy
> sql statments per few minutes, as I think it should
> be some script to get
> those information, from sysmaster database or other
> ways.
> Anyone have them, or samples, Any ideas and
> suggestions ?
> Thanks!
>
>
>
> Best Regard!
>
> Guo Dong Wan
> Email: wanguod@cn.ibm.com
>
>
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com