gboro54 [
http://community.jboss.org/people/gboro54] created the discussion
"Re: ms sql server XA performance issues"
To view the discussion, visit:
http://community.jboss.org/message/621887#621887
--------------------------------------------------------------
After some investagtion with the DBA, we found that a bad query plan had been cached thus
causing the slowness. Once we cleaned this up the query was running at around 30seconds.
--------------------------------------------------------------
Reply to this message by going to Community
[
http://community.jboss.org/message/621887#621887]
Start a new discussion in Datasource Configuration at Community
[
http://community.jboss.org/choose-container!input.jspa?contentType=1&...]