loveviolet
asked on
All kind of strange errors happening on production
Recently our production is having the all kind of different problems everyday. First it was a contiguous memory warning that was occuring about twice a day, for about 3 months now. In the past days there were also stack dumps and suddenly server shut down.... Please help!
Note that this only happens on our production, which is awe enabled, multi process machine which has 6GB memory. Another server which is having exact the same settings do not get these problems.
Please see the following 4 segments --- 4 different types of errors and I hope they are related. I am new to this site, and any help will be appreciated!
Jennifer
<logdetails edited out by CetusMOD>
Note that this only happens on our production, which is awe enabled, multi process machine which has 6GB memory. Another server which is having exact the same settings do not get these problems.
Please see the following 4 segments --- 4 different types of errors and I hope they are related. I am new to this site, and any help will be appreciated!
Jennifer
<logdetails edited out by CetusMOD>
Did you try and lower the maximum amount of memory that SQL uses? This error "WARNING: Failed to reserve contiguous memory of Size= 4128768" means the amount of memory you have SQL configured to "grab" isn't available.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You only have 6gig of memory in this machine--leaving 2gig for the operating system probably isn't enough. What else runs on this machine? What service pack do you have installed on the machine?
So what's your conclusion???
ASKER
sorry, it turns out that I can not do anything to test. Thanks for the suggestions anyways!
"sorry, it turns out that I can not do anything to test. "
Crap, how are you suppose to fix something if you can't adjust values or test?
Crap, how are you suppose to fix something if you can't adjust values or test?