Monday, February 13, 2012

AV & contineus stack dumps on SQL7.

Hi,
I've got SQL7-SP3 installation on NT4-SP6. Now, today I
noticed that for number of days it is generating stack
dumps every few minutes. It goes like this:
===================== SqlDumpExceptionHandler: Process 51 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process.
* BEGIN STACK DUMP:
-
-
-
-
language_exec: Process 51 generated an access violation.
SQL Server is terminating this process.
====================== Input buffer always say:
* select rsc_type, req_mode, req_status from
master..syslockinfo
I tried to search the knowledge base, but it reports tons
of reasons for AV. I have seen AV & stack dumps number of
times in past (on different servers) that goes only for
once, but the one I am looking at currently is doing it
constantly at few minutes interval.
I havn't heard any performance cry yet and don't know how
it is affecting.
Anyone seen this kind of behaviour or have any input on
this are welcome to shed some light. Your input is
appreciated. Thanks.
Adi.We found a monitoring software that was querying
syslockinfo, causing AV and stack dump. Stopping this
monitoring software service stopped stack dumps.
Still I wonder how did it started happening as we have
ditto configuration and setup on number of other servers
where everything seems to be working fine.
Anyways, thanks for your replies guys. Appreciate it.
Adi ..
>--Original Message--
>Hi,
>I've got SQL7-SP3 installation on NT4-SP6. Now, today I
>noticed that for number of days it is generating stack
>dumps every few minutes. It goes like this:
>=====================>SqlDumpExceptionHandler: Process 51 generated fatal
>exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
>is terminating this process.
>* BEGIN STACK DUMP:
>-
>-
>-
>-
>language_exec: Process 51 generated an access violation.
>SQL Server is terminating this process.
>======================>Input buffer always say:
>* select rsc_type, req_mode, req_status from
>master..syslockinfo
>I tried to search the knowledge base, but it reports tons
>of reasons for AV. I have seen AV & stack dumps number of
>times in past (on different servers) that goes only for
>once, but the one I am looking at currently is doing it
>constantly at few minutes interval.
>I havn't heard any performance cry yet and don't know how
>it is affecting.
>Anyone seen this kind of behaviour or have any input on
>this are welcome to shed some light. Your input is
>appreciated. Thanks.
>Adi.
>.
>

No comments:

Post a Comment