Error in SQLLogs

• sudarram

  SSChasing Mays

  Points: 623

  More actions

  March 14, 2009 at 8:21 am

  #93290

  Hi All,

  On checking the Sql Logs i found the following error.

  "MSG: Error: 1204, Severity: 19, State: 1 The SQL Server cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users or ask the system administrator to check the SQL Server lock and memory configuration."

  I couldnot understand this.Can anyone tell me about this.

  Thanks in advance

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  March 14, 2009 at 8:24 am

  #959708

  SQL Server uses memory to allocate locks and if that memory space is full then more locks cannot be taken until space is freed.

  Check out this article.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question