Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL return after running sp_who2

Posted on 2004-08-03
5
Medium Priority
?
621 Views
Last Modified: 2008-02-01
After I running the sp_who2, i fould the some returns which i have dont know,
SPID  Status                    DBName        Command
----------------------------------------------------------------------
 1     sleeping                   master           SIGNAL HANDLER
 2     BACKGROUND        master           LOCK MONITOR
 3     BACKGROUND        master          LAZY WRITER
 4     sleeping                   master          LOG WRITER
 5     sleeping                   master          CHECKPOINT SLEEP

Can anyone explain to me what is that talking about? Thanks
0
Comment
Question by:shyline777
  • 3
3 Comments
 
LVL 7

Expert Comment

by:FDzjuba
ID: 11709714
its just some data from the server of the current activity of the server, what exactly do you want to know about it ?
0
 
LVL 7

Expert Comment

by:FDzjuba
ID: 11709728
sp_who returns a result set with the following information.

Column Data type Description
spid smallint The system process ID.  
ecid smallint The execution context ID of a given thread associated with a specific SPID.
ECID = {0, 1, 2, 3, ...n}, where 0 always represents the main or parent thread, and {1, 2, 3, ...n} represent the sub-threads.
 
status nchar(30) The process status.
loginame nchar(128) The login name associated with the particular process.
hostname nchar(128) The host or computer name for each process.
blk char(5) The system process ID for the blocking process, if one exists. Otherwise, this column is zero.
When a transaction associated with a given spid is blocked by an orphan distributed transaction, this column will return a '-2' for the blocking orphan transaction.
 
dbname nchar(128) The database used by the process.
cmd nchar(16) The SQL Server command (Transact-SQL statement, SQL Server internal engine process, and so on) executing for the process.

0
 
LVL 7

Accepted Solution

by:
FDzjuba earned 200 total points
ID: 11709753
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question