Category: Sybase ASE (Page 1 of 3)

How to check blocking on Sybase database server 0 (0)

Below query can be used to check blocking on Sybase database server.

select convert(varchar(4),a.spid) as SPID,convert(varchar(15),db_name(a.dbid)) as DB,convert(varchar(12),suser_name(a.suid)) as LOGIN_NAME,
convert(varchar(4),
a.blocked) as BLOCKING_PROCESS,convert(varchar(15),suser_name(b.suid)) as BLOCKING_USER,convert(varchar(4),
a.time_blocked/60) as TIME_BLOCKED,
convert(varchar(10),a.cmd) as COMMAND,convert(varchar(18),a.hostname) as HOSTNAME ,convert(varchar(20),a.loggedindatetime) as BLOCKING_START_TIME
from master..sysprocesses a,
Read the rest

« Older posts

© 2024

Theme by Anders NorĂ©nUp ↑