December 13, 2014 at 9:10 pm
Hello,
I am using sql server 2012.
I have developed software with vb front end.Multi user environment.
My application runs well with sql server.But some times software gives error as "Timed out expired"
At that time when i connect to sql server through udl file,it fails to connect.
network is not issue.Network is fine.Server name is fine.
Could not getting why this is issue.
December 14, 2014 at 5:00 am
You need to gather more data. Run a query against sys.dm_exec_requests to see if there are blocked or blocking processes on your server. Also look at sys.dm_os_wait_stats to see what is causing the server to run slow.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 14, 2014 at 6:36 am
Quick thought, could this be a name resolution issue (DNS/Browser service)?
😎
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply