- 论坛徽章:
- 0
|
aix 5.3,ase12.5
发现一条过程执行了很长时间
1> select * from syslogshold
2> go
dbid reserved spid page xactid masterxactid starttime name xloid
5 0 321 3032282 0x002e44da0007 0x000000000000 Sep 16 2013 4:18PM $user_transaction 642
2 0 321 1699425 0x0019ee610006 0x002e44da0007 Sep 16 2013 4:18PM $ins 642
可是用mon监控表查询当前正在执行的sql:
select c.ipaddr,c.spid,c.blocked,a.CpuTime,a.PhysicalReads,a.LogicalReads,a.WaitTime,a.StartTime,b.LineNumber, b.SQLText
from master..monProcessStatement a,master..monProcessSQLText b,master..sysprocesses c
where a.SPID=b.SPID and a.SPID=c.spid and a.SPID<>@@spid
go
ipaddr spid blocked CpuTime PhysicalReads LogicalReads WaitTime StartTime LineNumber SQLText
10.xx.xx.xx 321 0 26 0 972 0 Sep 16 2013 4:57PM 1 execute p_xxxx_xxxx @v1 ='LK' ,
@v2 ='0014005' , @v3 ='788' , @v4 ='1080079'
结果2中逻辑读972,物理读0;开始时间4:57PM ,而且在变化,why?
结果1是不是可以推断中当前进度卡在 insert语句,结合sp_lock中加锁情况,推断出进度卡在存储过程的 insert某张表??
|
|