Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Timeout in my application

Author  Topic 

CodeMaker
Starting Member

1 Post

Posted - 2009-02-11 : 23:15:44
Hello Team,

My new project is in .NET and SQL Server.

This project right now facing problem of timeouts while running procedures.

The reason is, we have used many threads in bussiness layer and all are doing operation at same time. So database having more force or pressure.

like one thread will insert new order details, one will delete some orders, some thread will update order table and from UI some user will update the order status.

all operations may be on different orders but procedures show timeouts usually..


So I am here to find solution for the this repeated problem and It will be really helpful if someone guide me towards acheiving it.

Kindly lead me..

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-12 : 07:29:43
Are you updating stats after this DML operation?
Go to Top of Page
   

- Advertisement -