Insufficient system memory to run this query

• blich

  SSC Rookie

  Points: 28

  More actions

  November 14, 2001 at 7:33 pm

  #104635

  I am getting the error message in the subject intermittantly. I was wondering if anyone else has seen this? I am running Windows 2000 Server and SQL 2000 SP1 with 1gB of RAM.

  Upon searching around on the net I saw that it could be that the procedure cache is set too low. I cannot find a way to change this in SQL 2000. Anyone know of a way to do this? If it is not possible any other ideas would be greatly appreciated. I am going out of my mind trying to troubleshoot this.

  Thanks...

  Brian Lich

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  November 14, 2001 at 8:25 pm

  #420108

  SQL has use of the entire 1G? 1G aint as much as it seems like!

  Andy

  Andy
  Connect with me on LinkedIn

• blich

  SSC Rookie

  Points: 28

  More actions

  November 15, 2001 at 1:37 pm

  #420131

  Yeah, SQL is the only thing that is installed on it.

  I think it might be with Cold Fusion. On my web server I had Cold Fusion to maintain the database connections. I unchecked this on all of my ODBC connections, and it hasn't crashed yet.

  I am keeping my fingers crossed.

  Thanks!!!

  Brian

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738337

  More actions

  November 15, 2001 at 2:50 pm

  #420132

  Be sure it is a "good query" (no cross joins, etc). If you are truly building such a huge query, you may run out of resources.

  Steve Jones

  steve@dkranch.net