1
vote
1answer
39 views

SQL Server 2008 Timeout Expired

I asked the question below on Stackoverflow without any answers, however, someone suggested I ask the question on serverfault also. Hopefully someone can help. I recently publish my ASP.Net MVC 3 web ...
0
votes
1answer
167 views

Transferring 60GB of data over fiber connection - VPN connection times out [closed]

In an attempt to transfer a 60GB file (SQL database file) over the wire via a VPN connection, we're only able to get about 1/8 the file over. How can we get around this timeout issue? Or do we have ...
1
vote
1answer
1k views

SQL Server 2008 second instance times out when logging in — but only the first time?

This is a strange one that has plagued me for a while now. When logging in to the second instance of SQL Server 2008 on one of our database servers, we get a timeout error: Cannot connect to ...
0
votes
1answer
482 views

Diagnosing SQL Server 2008 Timeout After Prolonged Use

After every few days of faultless operation, the following information event pops up in my database server's event log: Process 0:0:0 (0x890) Worker 0x5C55A0D8 appears to be non-yielding on Scheduler ...
1
vote
1answer
644 views

SQLS Timeouts - High Reads in Profiler

I've audited a SQLS2008 server with Profiler for one day.. the overhead didn't seem to trouble this new client my company has. They are using a legacy VB6 application as a front-end. They're ...
0
votes
1answer
879 views

Time-out occurred while waiting for buffer latch in Sql server 2008 when executing large MERGE query

In our datawarehouse we execute a MERGE query in a storedprocedure in order to synchronize our datawarehouse every night. Our database server is running Sql-server 2008 During the execution of the ...
1
vote
2answers
2k views

Intermittent timeout when connecting to Sql Server, what do I look for?

Sql Server 2008 Standard 64bit on Windows Server 2008 R2 virtual machine hosted on a Hyper-V server. I'm getting intermittent timeouts when connecting to the server. This happens for both windows ...