Need a sysmaster sql to find I/O meister.
Posted in 1997
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? 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 *