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.
Author |
Topic |
FarzinSh
Starting Member
7 Posts |
Posted - 2013-08-24 : 06:00:35
|
Can we set a limit on the execution time of a single select or insert command?I am using c# and .net entity framework to run insert and select commands simultaneously on a single table.The problem we are currently facing with is that sometimes when many inserts and selects request execution at once, sql server command execution time goes up drastically resulting in a poor performance. To avoid this I thought we could limit the execution time for each command so as not to let them keep sql server more than they really should. Any ideas? |
|
MuMu88
Aged Yak Warrior
549 Posts |
Posted - 2013-08-24 : 11:19:02
|
You can implement timeout as described here:http://stackoverflow.com/questions/10143980/implementing-a-timeout-in-c-sharp |
|
|
FarzinSh
Starting Member
7 Posts |
Posted - 2013-08-25 : 01:13:41
|
thx for your respond though it didnt make sense since they cant stop and cancel the executing command in case timer counts more than the set time.They are just throwing an exception. |
|
|
|
|
|