SUB :MSSQL Lock Timeout is CRITICAL

• svijay_victory

  SSC Enthusiast

  Points: 106

  More actions

  January 13, 2009 at 4:19 am

  #97126

  Hi Everybody,

  I am new to sql server 2000. I am getting the following the error in the event viewer in my production database.

  Timeout (30000 milli seconds) waiting for a transaction response from symantec Antivirus servive

  Also

  my client side dba has sent the following mail

  Lock timeouts are very high - 1164 (Critical threshold is 1000)

  please anybody can share u r ideas .

  OS: WINDOWS SERVER 2003

  SQLSERVER 2000

  Thanks in Advance,

  vijay.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738683

  More actions

  January 13, 2009 at 8:38 am

  #925941

  Are you scanning the mdf/ldf files with Symmantec? You should exclude all database files from scanning.