hi I have an error message in sql server 2000 and it has cause the whole server stop responding. See below Stack Dump being sent to d:ms sql serverMSSQLlogSQL00010.dmp ******************************************************************************* * * BEGIN STACK DUMP: * 06/15/06 10:25:56 spid 156 * * Exception Address = 00403431 (lck_lock(class LockRequest const &,class Lock Res const &,class LockInfo *) + 0000008D Line 0+00000000) * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION * Access Violation occurred reading address 20202028 * Input Buffer 370 bytes - * SELECT * FROM INVMAS WHERE SGLOT1 = 'Z' and SGLOT2 = 'PO' and SGLOT3 = ' * 6' and SGLOT4 = '05' and SGLOT5 = '9351' and SGLOT6 = '' and SG = '1 * ' and CHOP = 'SZ0697' and SGWTH = '67' any suggestion and help will be greatly appreciated.
I think you have a hardware problem. Did you check memory with hardware people? Luis Martin Moderator SQL-Server-Performance.com All in Love is Fair Stevie Wonder All postings are provided “AS IS†with no warranties for accuracy.
Hi luis memory?? Can you explain futher why the memory can cause the problem?? i have check with hardware people,they said the memory is in good condition Actually i have restart the server, everything is fine but this kind of error keep bothering me. It happen a few times within a few months. The Temp solution i have in my mind is to reboot the server whenever it happen
Dou you have more than one processor for paralelism? Check: http://support.microsoft.com/kb/318874 Luis Martin Moderator SQL-Server-Performance.com All in Love is Fair Stevie Wonder All postings are provided “AS IS†with no warranties for accuracy.
Is not sql version problem. If you have more than one processor leave on for paralellism. Luis Martin Moderator SQL-Server-Performance.com All in Love is Fair Stevie Wonder All postings are provided “AS IS†with no warranties for accuracy.
i think this is an error in the SQL Server process, so it is SQL Server that must be restarted, not the whole server system (ie, the OS) its possible this could be a bug with earlier builds of SQL 2000, so updating to either the latest post sp4 hotfix or the latest pre-sp4 hotfix might resolve this. another possibility is memory as luis suggested does your system use ECC-memory? on what basis did your hardware people claim that memory is good? did they go into to the bios and check the memory error log?
A hotfix is available as per this KBAhttp://support.microsoft.com/?kbid=909089&SD=tech link that may suit your needs. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
May be i should try install latest service pack Actually i try to restart sql server only, but it hang (not able to stop) after trying to stop the service . That is why i restart the server. The server has more than one processor and is it any memory problem will log into BIOS memory log?? i have no idea after it
