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
 SQL Server 2008 Forums
 Transact-SQL (2008)
 limiting execution time for a select command

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
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -