SQL SERVER : sp_who2 Replacement

SELECT  spid,
        sp.[status],
        loginame [Login],
        hostname,
        blocked BlkBy,
        sd.name DBName,
        cmd Command,
        cpu CPUTime,
        physical_io DiskIO,
        last_batch LastBatch,
        [program_name] ProgramName  
FROM master.dbo.sysprocesses sp (nolock)
JOIN master.dbo.sysdatabases sd ON sp.dbid = sd.dbid
--WHERE sp.hostname like '%654%'
--ORDER BY spid
ORDER by
login
--cpuTime desc