SQL Socket Locks

• KEVIN WALKER-491108

  Grasshopper

  Points: 13

  More actions

  January 3, 2008 at 3:24 pm

  #177891

  I have a script that connects to the SQL Database, writes records, and Closes, but seems to be causing up to 5 Socket locks that do not seem to be releasing following record Close. After about 250-300 socket locks, the SQL Server stops responding to all calls, including application logins and SQL Server Maintenance logins. Can anyone point me to the likely cause for something that?

• Warren Peace

  SSCertifiable

  Points: 5881

  More actions

  January 3, 2008 at 4:03 pm

  #764606

  Post your script. Is it a vbscript, TSQL, pearl, POSIX.....?