SQL Server Performance Forum – Threads Archive

SqlDumpExceptionHandler

Hi, I have SP which is running continuosly in a loop.. (windows service program calls that SP).. And after a while, my SQL Server stops with following message .. SqlDumpExceptionHandler: Process 68 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. What could be causing this error? I have gone through couple of post and say that need to figure out the SQL which is resulting this error.. In SQL Profiler, I can see SP name which is running but not the SQL Statements which are executing.. In Dump log also, I can see the SP Name which has resulted into this exception but not actual SQL Statement. If I restart the server then everything works fine for a while.. Not getting any consistency when this error is generated. I have installed Latest Service Pack of SQL Server 2000. Any help would be highly appreciated.. Regards,
Nilay. PS: I am not sure if this is the right forum to post this question. If it is not kindly move to right forum.

What events are you capturing in Profiler? You would need to capture the SP Statement to get the actual statement. Also, you should track errors. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

THis is the right forum, and could you please explain about h/w of the server :
Processor
Memory
HDD etc. And see whether this KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;281769 has any relevance to the topic. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi, Configuration was not good (392MB RAM, P3 and 20 MB) as it was testing server.. I changed SQL Server to machine with 40 GB, 512 MB and P4.. Also reinstalled SQL Server 2000 again with latest service pack (Service pack 3a).. And since then I am not facing the problem.. I guess the problem was related to
– PC and installation of SQL Server..
– Less configuration,
– Improper installation of SQL Server.. Thanks,
Nilay.

I suspect the PC and installation of SQL Server generating this similar dump handler errors. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>