• Basically,

    After your application has done what it needs to do the connection is not instantly dropped. The connection remains open in the application pool. As such, AWAITING COMMAND is just an indication that there's an open connection on the SQL Server and it's doing nothing. It's just sitting there waiting for a command of some type.

    If you opened a query window in query analyzer and you checked in sysprocesses for that particular spid you'd see the same thing, AWAITING COMMAND.

    Commands like LAZY WRITER, CHECKPOINT SLEEP, LOCK MONITOR, etc... are just background tasks that you shouldn't need to worry about.