July 29, 2009 at 11:43 am
Hey all,
I am somewhat of a n00b when it comes to SQL 2000 administration. So, on our production database there are about 4000 processes running. Nearly all of them are created by .Net SQlClient, by our software written in vb.net 1.1. All of them have status of "sleeping", have 0 open transactions, command is "AWAITING COMMAND" and they all say "not waiting".
Anyways... we are getting a random "General Network Error" problem and I can't seem to solve it. The error is intermittent, sometimes it happens regularly and sometimes it won't happen for hours. Could this be related to the number of processes and/or locks in my database? Any information would be greatly appreciated. Thanks!!
riley
July 29, 2009 at 12:42 pm
Typically that error is an interruption in the communciation between your server and the client. The number of processes shouldn't be an issue, though each one takes resources. It's possible that you might low on memory, but I'd expect a different error.
July 29, 2009 at 1:01 pm
Hey,
thanks for your response. I think you may be onto something upon further inspection of my logs I am finding a ton of 17803 errors, followed by "Insufficient memory available" then followed by "WARNING: failed to reserve contiguous memory of Size=65536"
This confuses me a little. Is this the amount of memory the server needs to perform a particular query? Why must it be contiguous? About a week ago, I had adjusted my reserved physical ram settings to 4096 kb, and the overall ram usage, i bumped it up. This error started showing up yesterday, I don't know if they are related. So I guess we probably need to disable some of the more intense queries, to use less RAM? Or get more RAM? Is there anything I can do in the meantime with the memory config stuff in sql manager? thanks again
riley
July 29, 2009 at 1:44 pm
That's more along the lines of what I'd expect.
The memory usage in SQL Server can be a little strange. I know there are certain things that might need contiguous references, and I'd have to look to see if I could dig up a reference. I would definitely look at adding more memory if you are getting those messages.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply