• Search for:

    Monthly Archives: August 2022

    1. Home  - 2022  - 
    2. August
      3. ( Page2 )
    9 Aug, 2022
    How to check blocking on Sybase database server 0 (0)
    Sybase ASE

    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