To check used and free data space

select convert(char(16), db_name(d.dbid))
+ "|Data_Total_MB=" + convert(char(9), ceiling (sum(case when u.segmap != 4 then u.size/1048576.*@@maxpagesize end )))
+ "|Free_MB=" + convert(char(14), (convert(numeric(8,1),
           ((sum(case when u.segmap != 4 then u.size/1048576.*@@maxpagesize end ))) - (sum(case 

Below query can be used to check when was last update stats run on the database.

use DBNAME
go
select SUBSTRING(@@servername,1,20) 'Server_Name',db_name() 'DB_Name', SUBSTRING(object_name(id),1,30) 'table_name',statmoddate from systabstats where id=object_id('tablename') and indid=0

Sample output:

Below query can be used to check logins and associated server roles granted to them.

1select suser_name(suid) as 'login',role_name(srid) as 'role' from master..sysloginroles
2go

Below are the ways to know the list of tables which are marked for replication in Sybase ASE.

1. using sp_setreptable procedure

1use DB
2go
1sp_setreptable
2go

2. using below sql query

select object_name(id) as Name from … Read the rest

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