June 11, 2013 at 1:08 pm
Just recentally we have started to get dump files with the following description:
Description: Too many parallel nested transactions
When this happens and the dump files start to get created the server starts begins to time out making the applications crash.
Does anyone have any suggestions on how/what i can do to try and track down this error so i can see what caused it and keep it from happening in the future.
Thanks,
John
June 18, 2013 at 5:14 am
We have the most recent service pack (sp4). I am going to start by testing the MAXDOP, i know it will not fix the source of the issue but at least it should not allow it to happen. (When we get the error all the system resources are getting used which is what is causing the server to become none responsive.)
***Stack Dump being sent to D:\Data\LOG\SQLDump0005.txt
* ********************************************************
*
* BEGIN STACK DUMP:
* 06/10/13 17:32:22 spid 148
*
* Location: lckmgr.cpp:385
* Expression: 0
* SPID: 148
* Process ID: 14140
* Description: Too many parallel nested transactions
*
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply