Event ID 17052 - c0000005 EXCEPTION_ACCESS_VIOLATION

I have a windows 2000 server that hosts sql 2000 (sp3)
and IIS for a web based payroll application that runs on
our LAN. There are 25 users that use the application.
In the last two weeks I have experienced the below error
in the application log on the server.
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 58 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process.
This error only happens when a certain area of the
payroll application is used, however not all of the time;
when the error occurs it also prevents the payroll
application from working.
The really strange part is that one day we will not
receive the error and then the next day the error might
occur all day. There is nothing that has changed in the
last few weeks in either SQL, IIS or the payroll
application.
Any ideas why I am receiving this error?Have you don consistency check on the DB? DBCC CHECKDB and DBCC
CHECKCATALOG.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Andy" <anonymous@.discussions.microsoft.com> wrote in message
news:d42301c3eef2$dace10e0$a501280a@.phx.gbl...
> I have a windows 2000 server that hosts sql 2000 (sp3)
> and IIS for a web based payroll application that runs on
> our LAN. There are 25 users that use the application.
> In the last two weeks I have experienced the below error
> in the application log on the server.
> Error: 0, Severity: 19, State: 0
> SqlDumpExceptionHandler: Process 58 generated fatal
> exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
> is terminating this process.
> This error only happens when a certain area of the
> payroll application is used, however not all of the time;
> when the error occurs it also prevents the payroll
> application from working.
> The really strange part is that one day we will not
> receive the error and then the next day the error might
> occur all day. There is nothing that has changed in the
> last few weeks in either SQL, IIS or the payroll
> application.
> Any ideas why I am receiving this error?|||Yes I have, no problems there.
>--Original Message--
>Have you don consistency check on the DB? DBCC CHECKDB
and DBCC
>CHECKCATALOG.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Andy" <anonymous@.discussions.microsoft.com> wrote in
message
>news:d42301c3eef2$dace10e0$a501280a@.phx.gbl...
>> I have a windows 2000 server that hosts sql 2000 (sp3)
>> and IIS for a web based payroll application that runs
on
>> our LAN. There are 25 users that use the application.
>> In the last two weeks I have experienced the below
error
>> in the application log on the server.
>> Error: 0, Severity: 19, State: 0
>> SqlDumpExceptionHandler: Process 58 generated fatal
>> exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL
Server
>> is terminating this process.
>> This error only happens when a certain area of the
>> payroll application is used, however not all of the
time;
>> when the error occurs it also prevents the payroll
>> application from working.
>> The really strange part is that one day we will not
>> receive the error and then the next day the error might
>> occur all day. There is nothing that has changed in
the
>> last few weeks in either SQL, IIS or the payroll
>> application.
>> Any ideas why I am receiving this error?
>
>.
>|||The I suggest you go with the general recommendations: Search KB if there
are specifics re your problem, make sure you are current on service pack and
open a case with MS if needed.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
<anonymous@.discussions.microsoft.com> wrote in message
news:d0ea01c3eef7$026a0060$a401280a@.phx.gbl...
> Yes I have, no problems there.
>
> >--Original Message--
> >Have you don consistency check on the DB? DBCC CHECKDB
> and DBCC
> >CHECKCATALOG.
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at:
> >http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Andy" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:d42301c3eef2$dace10e0$a501280a@.phx.gbl...
> >> I have a windows 2000 server that hosts sql 2000 (sp3)
> >> and IIS for a web based payroll application that runs
> on
> >> our LAN. There are 25 users that use the application.
> >>
> >> In the last two weeks I have experienced the below
> error
> >> in the application log on the server.
> >>
> >> Error: 0, Severity: 19, State: 0
> >> SqlDumpExceptionHandler: Process 58 generated fatal
> >> exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL
> Server
> >> is terminating this process.
> >>
> >> This error only happens when a certain area of the
> >> payroll application is used, however not all of the
> time;
> >> when the error occurs it also prevents the payroll
> >> application from working.
> >>
> >> The really strange part is that one day we will not
> >> receive the error and then the next day the error might
> >> occur all day. There is nothing that has changed in
> the
> >> last few weeks in either SQL, IIS or the payroll
> >> application.
> >>
> >> Any ideas why I am receiving this error?
> >
> >
> >.
> >|||What type of memory configuration do U have for SQL server (fixed / dynamic) sounds like a memory contention issue btw iis and sql server, tried fixed memory?
Also possible to monitor memory object (pages/sec) counter to see if there is excessive paging when this problem occurs?|||Do you have the stack trace from the SQL Server event log?
This will provide more information for us to go on and help us debug.
Also, make sure you are on the latest version of SQL Server, as this SQL
Server bug might have already been fixed.
--
Paul Wehland
pwehland at msn dot com
"Andy" <anonymous@.discussions.microsoft.com> wrote in message
news:d42301c3eef2$dace10e0$a501280a@.phx.gbl...
> I have a windows 2000 server that hosts sql 2000 (sp3)
> and IIS for a web based payroll application that runs on
> our LAN. There are 25 users that use the application.
> In the last two weeks I have experienced the below error
> in the application log on the server.
> Error: 0, Severity: 19, State: 0
> SqlDumpExceptionHandler: Process 58 generated fatal
> exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
> is terminating this process.
> This error only happens when a certain area of the
> payroll application is used, however not all of the time;
> when the error occurs it also prevents the payroll
> application from working.
> The really strange part is that one day we will not
> receive the error and then the next day the error might
> occur all day. There is nothing that has changed in the
> last few weeks in either SQL, IIS or the payroll
> application.
> Any ideas why I am receiving this error?