• Search for:

    1. Home
    17 Aug, 2022
    Understanding SQL Server Always On Basic Availability Groups 0 (0)
    MSSQL , , ,

    In today's competitive world, it is very necessary to keep the critical applications available 24*7 to the business as well as to the customer. All the organizations have to design their Infrastructure in such a way, so that they can … Read the rest

    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