November 14, 2001 at 7:33 pm
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
November 14, 2001 at 8:25 pm
SQL has use of the entire 1G? 1G aint as much as it seems like!
Andy
November 15, 2001 at 1:37 pm
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
November 15, 2001 at 2:50 pm
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply