-
检查在sybase15.7 for linux 6环境下安装与创建服务时，存在逻辑读较多情况的SPID
资源介绍
通过以下语句检查逻辑读较多的SPID
select SPID, KPID, BatchID, ContextID, DBID, ProcedureID, StartTime,
ElapsedTime=datediff(ss,StartTime,max(EndTime)),
CPUTime=sum(CpuTime),LogicalReads=sum(LogicalReads),
PagesModified=sum(PagesModified)
from master..monSysStatement
group by SPID, KPID, BatchID, ContextID, DBID, ProcedureID, StartTime
having datediff(ss,StartTime,max(EndTime)) > 0
and sum(LogicalReads) > 0
order by 7