Re: Need a sysmaster sql to find I/O meister.
In article <67f2pq$gdq$1@usenet11.supernews.com>, Jeff Lanham
<jeffl@etcscan.com> writes
>Greetings Family,
>
>We had a situation today where our tempdbs's where getting hammered hard
>with I/O. Mostly writes. As it turned out someone was running a large
>select with an order by. We happened to stumble upon who the culprit was an
>induce a bit of on-the-spot training. Now we have a question:
>
>Is there a way to query sysmaster to find the session id of a heavy I/O
>offender?
>
Yep...
select * from syssesprof
Easy!!
>ODS 7.32.UC4
>Sequent
>DYNIX/ptx 4.1.4
>
>TIA,
> Jeff
>
>---------------------------------------------------------------------------
>Jeff Lanham jeffl@etcscan.com
>DBA UIN: 2721788
>SCAN/Deluxe Payment Protection Systems, Inc.
>Bothell, WA
>* Eagles may soar, *
>* but weasels aren't sucked into jet engines *
>
>
>
--
David Williams