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

results = sql.rows("select spid, time_blocked, blocked from master..sysprocesses WHERE db_name(dbid)=${dbname}") }. our instance here is spid , can  i change to spid   ie.. as mentioned below

results = sql.rows("select spid, time_blocked, blocked from master..sysprocesses WHERE spid =${wildvalue}")

do i need to create datasource for CMD & TIME_bloked? if what are the properties for them