September 17, 2008 at 7:09 am
Dear All,
In production environment I frequently see stack dump errors like
--> Access Violation occurred reading address 4106F008
--> Scheduler non-eyelding
--> latch time-out etc...............
as of my knwledge stack dump will occur whenever sql server is overloaded like lack of physical memory and when bulk operations like BCP and when some stored procedure running.
For some stack dump errors we need to install latest service packs. For some stack dumps errors just we can ignore, some times we neeed to restart the SQL Server, some times we need to contact Microsoft PSS and open a case.
I would like to know little bit more about STACK DUMP errors.
1. What exactly the stack dump error is and what it mean?
2. Why these stack dump errors occur?
3. What is common solution for these STACK DUMP errors?
4. By seeing stack dump some times we can find the SQL query which is caused the stack dump and some times we can't find. Is there any tool to extract the SQL query from stack dump file?
and please provide me some articles or some documentaion where I can find more about STACK DUMP.
Please help me I appreciate your participation in this thread.
Rajesh Kasturi
September 17, 2008 at 7:59 am
There isn't much documentation on these, often because they is no common solution. These errors aren't common.
It could be hardware or it could be some bug. Really you want to call Microsoft and ask them these questions.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
September 17, 2008 at 10:23 pm
Thanks for your reply.
Rajesh Kasturi
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply