August 10, 2004 at 1:09 pm
Does anyone have any experience with the transaction log becoming unavailable during xml processing? We seem to be bumping into this situation when multiple users are testing at the same time.
Thanks,
Jeff
"Keep Your Stick On the Ice" ..Red Green
August 13, 2004 at 8:00 am
This was removed by the editor as SPAM
August 17, 2004 at 4:30 am
Hi Jeff,
What is the error the you are getting? I have never encountered such a scenario. Ofcourse using xml will reduce the performance when the hit rate is very high.
Nivedita Sundar.N
August 17, 2004 at 8:27 am
The error was somewhat misleading...better put, it was a chain of errors all masking each other. There are some issues with SQL Server's transaction log rolling back text and ntext transactions. According to Microsoft this was fixed in SP 3 and above.
This was only a symptom of the problem we encountered. We experienced a deadlock that triggered the whole situation. Which reminds me..think we found a bug with the query optimizer. Sounds like a new post??
"Keep Your Stick On the Ice" ..Red Green
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply