Here are some SQL/procedures which are handy for determining what is going on in the system.
-- List processes
sp_iqwho ;
-- Show detailed connection properties
sp_iqshowpsexe ;
-- Show open transaction / versions
sp_iqtransaction ;
-- Show SQL running from a specific connection
sp_iqcontext 578 ;
-- Show I/O related information by connection
select distinct
a.connHandle, a.connOrCurCreateTime, a.Userid, a.IQThreads,
CONNECTION_PROPERTY( 'DiskRead', Number ) AS DiskRead,
CONNECTION_PROPERTY( 'DiskWrite', Number ) AS DiskWrite,
CONNECTION_PROPERTY( 'CacheRead', Number ) AS CacheRead,
CONNECTION_PROPERTY( 'CacheHits', Number ) AS CacheHits,
a.CmdLine
from sp_iqcontext() a, sa_conn_properties() b
where a.ConnOrCursor = 'CONNECTION'
and cmdLine != 'NO COMMAND' and a.ConnHandle=b.Number and b.PropName ='DiskRead';
-- MultiPlex Only
sp_iqversionuse ;
|
|
