SQL have most IO read

Posted in 2017

CHUAN LU — Wed, 10 May 2017 14:55:43 — source: IIUG Forums & Mailing Lists

HI, How to monitor which SQL has the most IO read operation? thanks for your time.

↪ replying to CHUAN LU

John Miller iii — Wed, 10 May 2017 15:39:47 — source: IIUG Forums & Mailing Lists

If you turn sqltrace on to low it will track this information along with other very useful information when tuning queries. You pre-configure the tracing so the impact to performance in low mode is less than 0.2% from my testing. John F. Miller III miller3@us.ibm.com 503-747-1366 ids-bounces@iiug.org wrote on 05/10/2017 07:55:45 AM: > From: "CHUAN LU" <luchuan@cn.ibm.com> > To: ids@iiug.org > Date: 05/10/2017 07:56 AM > Subject: SQL have most IO read [39162] > Sent by: ids-bounces@iiug.org > > HI, > > How to monitor which SQL has the most IO read operation? > > thanks for your time. > > > ***************************************************************************= **** > Forum Note: Use "Reply" to post a response in the discussion forum. >