[jboss-user] [Datasource Configuration] - Re: ms sql server XA performance issues

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&...]