Timout expired issue in database in C# and SQL Server 2012 -


right facing time out issue in web application when database perform update / insert operations on multiple tables.

database size 80 gb , wanting resolve time out issue application level.

can 1 please me sort out issue basis of below point -

  1. create new indexing in running database

thanks ss

ms sql comes default setting of 30 seconds timeout transaction. adding index 80gb database might take more that.

to increate timeout value, go to:

tools > options > designers > table , database designers

and increase value.

enter image description here


Comments

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

python Tkinter Capturing keyboard events save as one single string -

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -