Forum Discussion

manthena2020's avatar
manthena2020
Icon for Advisor rankAdvisor
2 years ago

Collection the data metrics where there are unique keys

SPID = 1 BLOCKED = 0 SPID = 3 BLOCKED = 0 SPID = 4 BLOCKED = 0 SPID = 5 BLOCKED = 0 SPID = 6 BLOCKED = 0 SPID = 7 BLOCKED = 0 SPID = 8 BLOCKED = 0 SPID = 9 BLOCKED ...
manthena2020's avatar
manthena2020
Icon for Advisor rankAdvisor
2 years ago

ok, what if i am querrying select spid, cmd, blocked, time_blocked from master..sysprocesses

Then i will get my collection script would be 

SPID1.BLOCKED: 0.CMD:tunning.time_blocked:18:52 ? 

is it right