SQL Server Performance

c0000005 EXCEPTION_ACCESS_VIOLATION

Discussion in 'General DBA Questions' started by Jack_low, Jun 17, 2006.

  1. Jack_low New Member

    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.

  2. Luis Martin Moderator

    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.



  3. Jack_low New Member

    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
  4. Luis Martin Moderator

    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.



  5. Jack_low New Member

    It is SQL server 2000 standard edition, so i don't think it has that feature
  6. Luis Martin Moderator

    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.



  7. joechang New Member

    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?


  8. satya Moderator

  9. Jack_low New Member

    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

Share This Page