Very Computer

We have a three tier application; the back-end being
SQLServer, the front-end being a Java application and the
middle-tier being a web-logic server.

The users enter data via the Java application. Yesterday,
I was going through the profiler when I came across
something. I noticed that for every transaction, it puts
another dummy transaction,ie, in the example shown below,
BEGIN TRAN -- usp_Booking_Insert -- COMMIT TRAN is one and

Now, I dont know why it introduces the second transaction.
I noticed that it consumes about 16ms in the profiler.
Since our application is an OLTP application, I'm worried
because next month we will adding another 100 users.

I would really appreciate some help from others.

Thanks,
rgn

BEGIN TRAN

Can you send the script of the transaction run by the application? Is there
any error handling in your application that looks for active transactions,
which is what Profiler could be reporting?

Sunil Agarwal
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

Thanks for asking. Please email me your email id and I
shall send you the trace file itself.

Thanks,

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Perhaps the driver you're using is sending the extra transaction. Is it
JDBC?

Ron
--
Ron Talmage
SQL Server MVP

Yes. THe weblogic EJB's are written to connect using
JDBC.

THanks,
rgn

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!