how to use sp_who2 and where should i put it to check ?
-
thank for willing help
-
thank for willing help
The sp_who2 internal procedure provides the following information: Spid—The system process ID. status—The status of the process (e.g., RUNNABLE, SLEEPING). loginame—Login name of the user. hostname—Machine name of the user. blk—If the process is getting blocked, this value is the SPID of the blocking process. dbname—Name of database the process is using. Cmd—The command currently being executed (e.g., SELECT, INSERT) CPUTime—Total CPU time the process has taken. DiskIO—Total amount of disk reads for the process. LastBatch—Last time a client called a procedure or executed a query. ProgramName—Application that has initiated the connection (e.g., Visual Basic, MS SQL Query Analyzer) You can use them.
Arun Singh Noida.
-
The sp_who2 internal procedure provides the following information: Spid—The system process ID. status—The status of the process (e.g., RUNNABLE, SLEEPING). loginame—Login name of the user. hostname—Machine name of the user. blk—If the process is getting blocked, this value is the SPID of the blocking process. dbname—Name of database the process is using. Cmd—The command currently being executed (e.g., SELECT, INSERT) CPUTime—Total CPU time the process has taken. DiskIO—Total amount of disk reads for the process. LastBatch—Last time a client called a procedure or executed a query. ProgramName—Application that has initiated the connection (e.g., Visual Basic, MS SQL Query Analyzer) You can use them.
Arun Singh Noida.
thank for your reply.Thank a lot