Menu

#35 SQL query details truncated in process screen

v1.0_(example)
open
nobody
None
1
2014-11-18
2014-11-18
Anonymous
No

I am trying to get the SQL query from the 'Process' section of the ASEmon and it the output is truncated :-

set forceplan on
select
Loggedindt=convert(varchar,A.Loggedindatetime,109),
A.Spid,
UserName,
program_name,
CPUTm=sum(convert(numeric(16,0),case when CPUTime <1500000000 then CPUTime else 0 end)),
LReads=sum(convert(numeric(16,0),LogicalReads)),
PReads=sum(convert(numeric(16,0),PhysicalReads)),
PgRead=sum(convert(numeric(16,0),PagesRead)),
PWrites=sum(convert(numeric(16,0),PhysicalWrites)),
PgWritten=sum(convert(numeric(16,0),PagesWritten)),
ScPgs=sum(convert(numeric(16,0),ScanPgs)),
IPgs=sum(convert(numeric(16,0),IdxPgs)),
TTbl=sum(convert(numeric(16,0),TmpTbl)),
UBytWrite=sum(convert(numeric(20,0),UlcBytWrite)),
UFlush=sum(convert(numeric(16,0),UlcFlush)),
UFlushFull=sum(convert(numeric(16,0),ULCFlushFull)),
avgUlcSize= case when sum(convert(numeric(16,0),UlcFlush))=0 then str(0,5,0) else str(convert(float,sum(convert(numeric(30,0),UlcBytWrite))) / sum(convert(numeric(16,0),UlcFlush)),5,0) end,
Trans=sum(Transactions),
Cmits=sum(Commits),
Rlbacks=sum(Rollbacks),
PktReceived=sum(PacketsReceived),
PktSent=sum(PacketsSent),
BReceived=sum(convert(numeric(16,0),BytesReceived)),
BSent=sum(convert(numeric(16,0),BytesSent)),
avgPktRcv=case when sum(PacketsReceived)=0 then str(0,5,0) else str(convert(float,sum(convert(numeric(16,0),BytesReceived)))/sum(PacketsReceived),5,0%2

Discussion

Anonymous
Anonymous

Add attachments
Cancel





MongoDB Logo MongoDB