SQL Server 2005 Background Process

[sendba]

All

I have installed
Microsoft SQL Server 2005 - 9.00.2047.00 (X64)
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)

In 2000 when we give sp_who2 active it shows all the background process and the rows affected will be 21 or 22 rows when there is no active transaction.

In 2005 i see 43 rows when i execute sp_who2 active when there is no active transactions.

Please let me know is this normal

I am using windows 64 Bit on SQL Server 2005 64 Bit.

Thanks

 

[SQLDenis]

use sys.dm_exec_sessions in SQL server 2005

this will list all user processes

select * from sys.dm_exec_sessions 
where is_user_process = 1

sp_who2 lists all processes (the ones below 51 are not user but SQL server processes)

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions