0

I executed stored procedure sp_who2 'Active'. In result I got list of active connections to db. But I also noticed that there are some connections where LastBatch equals to 01/01.

What does it mean? There are some queries that is never executed, but connection to db is still available?

enter image description here

demo
  • 6,038
  • 19
  • 75
  • 149
  • 1
    According to [this](https://www.itprotoday.com/microsoft-sql-server/lastbatch-mastersysprocesses), that will be displayed for connections created without using RPC calls. Unfortunately the link it refers to 404s, and I'm having trouble finding anything more recent to confirm it. – Diado Dec 04 '18 at 11:47
  • 1
    @Diado thx, your article helps! – demo Dec 05 '18 at 10:31

0 Answers0