It will display current running processes:
|
1 2 |
sp_who go |
It will display processes which is running by “dbmaint” user id:
|
1 2 |
sp_who 'dbmaint' go |
It will display databases names available on Server:
|
1 2 |
sp_helpdb go |
It will display the cpu details:
|
1 2 |
sp_monitor go |
It will display the max memory available. We need to check usually when we are going to do any parameter changes .
Like;
|
1 2 3 4 5 6 7 8 9 |
1> sp_monitorconfig "max memory" Usage information at date and time: Jun 5 2017 7:37AM. Name Num_free Num_active Pct_act Max_Used Reuse_cnt ------------------------- ----------- ----------- ------- ----------- ----------- max memory 1988192 6201808 75.72 6201808 0 (1 row affected) (return status = 0) |
It will display multiple parameters. Number 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.
|
1 2 |
1> sp_monitorconfig 'all' 2> go |
To check Blocking On Server (if any):
|
1 2 |
1> select physical_io,cpu,blocked,time_blocked,spid,cmd from master..sysprocesses where blocked<>0 2> go |
To check running spid and blocking spid corresponds to that (if any):
|
1 2 |
1> select spid ,blocked from sysprocesses where blocked>0 2> go |
To check Log Suspend:
|
1 |
1> select * from master..sysprocesses where cmd like 'LOG%' |
To check details of particular spid:
|
1 2 |
1> select * from master..sysprocesses where spid=abc 2> go |
Host level Commands:
To check Dataservers avaialble or running on Host:
|
1 |
ps -aef |grep dataserver |
To check Backupserver status avaialble or running on Host:
|
1 |
ps -aef |grep backupserver |
To check server Start time:
|
1 |
select @@boottime |
To check Server name:
|
1 |
select @@servername |
To check Server ASE version:
|
1 |
select @@version |
To check Date on Server Level:
|
1 |
select getdate() |
To check errorlog path from server level:
|
1 |
select @@errorlog |
To check Backupserver Status:
|
1 |
SYB_BACKUP...sp_who |
