SQL Server Performance

What Last_Batch means?

Discussion in 'SQL Server 2005 General DBA Questions' started by CanadaDBA, Sep 11, 2008.

  1. CanadaDBA New Member

    Does only running a SELECT statemnet updates Last_Batch in master.dbo.sysprocesses?
  2. CanadaDBA New Member

    Well, I found this: http://technet.microsoft.com/en-ca/cc825503.aspx
    I want to detect if a connection has been idle for more than 60 minutes. I have licnese limitation for an application and want to drop idle connections. What should I do to detect this status?
  3. satya Moderator

    http://blogs.msdn.com/sql_protocols/archive/2006/03/09/546852.aspx on your keep-alive information.Coming to auto-disconnect SQL Server has no such need, and because of that applications rarely handle the disconnect well. Unless your application will benefit from this and is specifically written to tolerate the disconnection behavior that Oracle needs, I would avoid the temptation to interfere.

Share This Page