I have developed one simple vb.net 2012 project with sql server 2008 R2 backend. sql server database has simple recovery module and server computer has 64 gb memory and dual processor capability.
but my problem is system suddenly getting hang for 2 or 3 minutes after that working good as usual.
During system hang am getting message says "time out expired sql server".
During System hang, Sql server database view's are also not working.
we have around 20 to 30 users only with two users in remote area.
I have used simple sql command query with simple sql transaction for commit or rollback in the vb.net code.
Exceute command is set to 0.
connection timeout is set by default 15 seconds
remote connections allow and remote query set to 600 seconds.
please help me to solve this issue!