SQLRNNR (9/4/2015)

---

PB_BI (9/4/2015)

---

Nice question - BOL says that sysprocesses will be removed from future versions and to use sys.dm_exec_connections, sys.dm_exec_sessions, and sys.dm_exec_requests instead (https://msdn.microsoft.com/en-us/library/ms179881.aspx). That's what I love about QOTD - I now know, from looking for an answer, a new thing. Cheers 🙂

For the most part those DMVs work in replacing sysprocesses. Part of the reason sysprocesses is still around is this connect item:

https://connect.microsoft.com/SQLServer/feedback/details/257502/deprecation-of-sysprocesses-dmvs-doesnt-fully-replace-all-columns