It will display current running processes:<\/p>\n
sp_who\u00a0\u00a0\r\ngo<\/pre>\n<\/p>\n
It will display processes which is running by “dbmaint” user id:<\/p>\n
sp_who 'dbmaint'\r\ngo<\/pre>\n<\/p>\n
It will display databases names available on Server:<\/p>\n
sp_helpdb\r\ngo<\/pre>\n<\/p>\n
It will display the cpu details:<\/p>\n
sp_monitor\r\ngo<\/pre>\n<\/p>\n
It will display the max memory available.\u00a0We need to check usually when we are going to do any parameter changes .
\nLike;<\/p>\n1> sp_monitorconfig \"max memory\"\r\nUsage information at date and time: Jun 5 2017 7:37AM.\r\n\r\nName Num_free Num_active Pct_act Max_Used Reuse_cnt\r\n------------------------- ----------- ----------- ------- ----------- -----------\r\nmax memory 1988192 6201808 75.72 6201808 0\r\n\r\n(1 row affected)\r\n(return status = 0)<\/pre>\n<\/p>\n
It will display multiple parameters.\u00a0Number of locks,number of open objects,number of open partitions,number of worker processes,number of user connection and procedure cache size and many more.<\/p>\n
1> sp_monitorconfig 'all'\r\n2> go<\/pre>\n<\/p>\n
To check Blocking On Server (if any):<\/p>\n
1> select physical_io,cpu,blocked,time_blocked,spid,cmd from master..sysprocesses where blocked<>0\r\n2> go<\/pre>\n<\/p>\n
To check running spid and blocking spid corresponds to that (if any):<\/p>\n
1> select spid ,blocked from sysprocesses where blocked>0\r\n2> go<\/pre>\n<\/p>\n
To check Log Suspend:<\/p>\n
1> select * from master..sysprocesses where cmd like 'LOG%'<\/pre>\n<\/p>\n
To check details of particular spid:<\/p>\n
1> select * from master..sysprocesses where spid=abc\r\n2> go<\/pre>\n<\/p>\n
Host level Commands:<\/strong><\/p>\n
To check Dataservers avaialble or running on Host:<\/p>\n
ps -aef |grep dataserver<\/pre>\n<\/p>\n
To check Backupserver status avaialble or running on Host:<\/p>\n
ps -aef |grep backupserver<\/pre>\n<\/p>\n
To check server Start time:<\/p>\n
select @@boottime<\/pre>\n<\/p>\n
To check Server name:<\/p>\n
select @@servername<\/pre>\n<\/p>\n
To check Server ASE version:<\/p>\n
select @@version<\/pre>\n<\/p>\n
To check Date on Server Level:<\/p>\n
select getdate()<\/pre>\n<\/p>\n
To check errorlog path from server level:<\/p>\n
select @@errorlog<\/pre>\n<\/p>\n
To check Backupserver Status:<\/p>\n
SYB_BACKUP...sp_who<\/pre>\n\n<\/div>\n