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

gboro54 do-not-reply at jboss.com
Fri Aug 19 22:45:25 EDT 2011

gboro54 [http://community.jboss.org/people/gboro54] created the discussion

"ms sql server XA performance issues"

To view the discussion, visit: http://community.jboss.org/message/621881#621881

We have a query we are trying to execute on JBoss AS 5.1 with a MS SQL datasource configured as an XA resource. In this case the query is taking more then 40 minutes to execute when invoking it via tha app where invoking it via a SQL client is take 1-4 minutes. We are using MS SQL JDBC driver 2.0. Are there any performance issues with this configuration? Are there any tuning tips anyone can offer. My initial thought is to update the driver as from some information I have gathered indicates ms sql driver 2.0 may have issues with XA transactions. Any input is welcome.


Reply to this message by going to Community

Start a new discussion in Datasource Configuration at Community

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110819/aa431337/attachment.html 

More information about the jboss-user mailing list