December 12, 2006 at 5:17 am
Hi All,
I have a scenario where i have to use ado.net transaction. This transaction losts for almost 10min. During the transaction period none of users will be accessing the application. I am using many temporary tables in stored procedures which participate in the transaction. I would like to know after the ADO.Net transaction is complete will there be any hit on sql - server peformance.
When the sql server and applicaiton server(IIS) is on the same machine ( test enverionment) after the transaction is completed my system is giving me a message saying virtual memory is low blah blah...
Can you kindly let me know the answer and reason.
Thanks,
Raghunath K
December 12, 2006 at 12:57 pm
I sometimes wonder about some of the posts! I suggest you start with basics in o/s etc. etc. You don't have enough physical memory to satisfy the requirements of your applications - you need to add more physical memory to your test machine.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
December 12, 2006 at 2:44 pm
The transaction would not be part of this issue. Basically a transaction object issues a BEGIN TRAN on the server with a reference that can be used for ROLLBACK and COMMIT. The issue has to lie elsewhere. As fot any hit only if a portion of the transaction fails and all the work has to be rolledback. I would suggest looking at the breakdown of your process and see if you have written it optimally.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply