Hi,
I have 2 warnings in dbanalyzer:
* W3 Deletes selectivity 0%: 8 deletes, 6982 rows read, 0 rows qualified
CON: DelSel < 0.3
VAL: 0 < 0.3
* W3 155968 physical reads for user task 60, 7147899 commands, application
pid 872
CON: USER_TASK_READCNT[""] > INTERVAL * 60 ||
USER_TASK_READAVG_ABSTIME[""] > 100
VAL: 155968 > 901 * 60 || 0
Is there any way to identify the sql sentece which is doing that?
Thank you !
--
Daniel Castro
Website: http://danielti.no-ip.info:2139
MSN: [EMAIL PROTECTED]
Skype: danielti2005
ICQ : 316727989
Jabber: danielti
Linux User: 387864
AOL User: Danielti2005
Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli Deo Gloria
