Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jKessler
Starting Member
3 Posts |
 Posted - 2013-06-12 : 07:13:29
|
| 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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-13 : 03:02:03
|
| seems like opening and closing of transactions is not properly done from application may be inside loops etc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-13 : 08:28:44
|
Run the following command to see which processes have open transactionsSELECT * FROM sys.sysprocesses WHERE open_tran > 0 Once you identify those processes, run this command to see details about those processesEXEC sp_who2 That will show you various details such as the hostname, program that is invoking running on that spid, what command it is executing etc. |
|
|
|
|
|
|
Too many parallel nested transactions