Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 |
