Are you taking full and transaction log backups on a regular basis?

In a 2 node cluster you could get by most likely, I have done this without issue before. But why wouldn't you take the 20 seconds to eliminate the...

I used the latest version of HammerDB.

This is my go to place that lays out the updates pretty well, if you follow the links here everything looks correct. http://sqlserverbuilds.blogspot.com

You can do this using a linked server. I believe the only requirement is to load the Oracle driver on the server. And like the previous post use OPENQUERY....

Use SQL Configuration Manager is the only way to go.

I think I see your problem, when primary is myreplica then the route needs to have myreplica2 first, you originally posted the opposite so your primary settings should look like...

Have you tried using different ports in your routing table. I used the dynamic port assigned in Configuration Manager instead of 1433. Below is a link that auto...

Nemesis, did you get this resolved?

I agree, very easy once you learn the working parts. No un-installation or restart...

Ran a quick ad-hoc benchmark of each during the lunch hour today so it won't be as accurate. Since my...

I did not benchmark async as we were required to have automatic failover, but I might if I get some time. The drop occurs only after we add the...

PretendDBA (9/21/2015)

---

I have another new server that is to host our reporting DBs and am not sure whether to tell them to suck it up and stick with the...

Also is TCP/IP enabled on the protocol tab of the TCP/IP properties page? I think the info you sent were for the second tab and I don't believe those...

http://help.red-gate.com/help/SQLBackup5/2/en/Topics/SBU_Errors.html

That looks like the most generic error. Can you try looking through the application log and the SQL server logs for errors?