December 3, 2002 at 2:14 pm
I have been running SQL 2k/Win2k AS with AWE enabled for about a year now. A couple months ago I ran into some issues that seemed to point to AWE as a problem so I disabled it. Recently I had SQL services shut down and restart by themselves. I have not had much luck researching some of the error messages associated with these. Below are some of the key phrases in the errors:
"PSS NULL for assert - raising EXCEPTION_ILLEGAL_INSTRUCTION"
"Stack overflow dump not possible"
"SQL Server Assertion: File:<umsio.cpp>, line=117 Failed Assertion = 'm_busyCnt==1'"
Event 17310
Error 8344
Any information would be appreciated. My suspicion is that this is memory related.
Remember this when a developer tells you it will just be temporary. Temporary = Permanent.
December 3, 2002 at 3:45 pm
Most likely it is, but you will need to work with PSS on this one.
Steve Jones
December 3, 2002 at 4:09 pm
The restart is most likely that the service is set to restart on failure.
As for the other no documentation you will need to check with MS on this one unless there is more details in SQL log or Event Viewer logs. If this is the first occurrance then may be a fluke. If not and you suspect memory, remove all but one stick if your server can support that low and see if occurrs again. Or replace all the memory, make sure you used a completely matched set of memory for stability and interoperability. If a DELL or similar type with a memory card off the motherboard then reseat (had an issue with this a few months ago).
December 5, 2002 at 8:28 pm
Do you have any NT Event log entries that report any hardware related problems around the same time?
Do you have your server set to create a dump on a hardware error? If not, I'd configure it just in case this happens again and crashes your server. Then you'll have the doco you need to let support diagnose the problem.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply