SQL Query for SCCM performance

Select * from vlogs where logtime >GETTIME ()-1 AND ProcedureName <> 'spDRSSendChangesForGroup' ORDER BY logtime Des

verify replication status

spdiagdrs

verify active jobs

sp_who2 activ

select top 100 * from vlogs

where LogText not like 'Info%' and LogText not like 'Debug%' and LogText != 'Web Service heartbeat' and LogText not like 'Not sending changes %' and LogText != 'Received signal to stop.'

order by LogLine desc

select top 100 * from vlogs
where LogText not like 'Info%' and LogText not like 'Debug%' and LogText != 'Web Service heartbeat' and LogText not like 'Not sending changes %' and LogText != 'Received signal to stop.'
order by LogLine desc


select distinct conversation_handle from sys.transmission_queue  where conversation_handle='c48e4204-1fe1-e511-a9d8-005056af53b7'


select * from vlogs where LogText like '%error%' order by LogLine desc


spdiagdrs

select * from ssb_dialogpool where  toservice like '%C01%'='c48e4204-1fe1-e511-a9d8-005056af53b7'