Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    54

    Unanswered: Connection timeout

    We recently moved our SQL Server to a faster machine. Everything is working great except every once in a while we get a connection timeout to the sql server. Everything else seems to be performing better but that initial connection is taking longer.

    I realize this could be caused by a great deal of things, but if anybody has any suggestions I would appriciate it.

    Thanks much.

  2. #2
    Join Date
    Jan 2005
    Location
    TempDb
    Posts
    228
    Leave an open connection for the next time the problem occurs. When it does, run exec sp_who2 and check the BlkBy column - if there is a value there, that is the id of the process (spid) that is blocking. Often you will have multiple blocking spids, and the key to that is to find the spid that is blocking at least one other spid but is not blocked - aka the culprit.

    You can run DBCC INPUTBUFFER(culprit) to see what command it is running.

    Happy hunting.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •