Since it wasn't mentioned in the original post I had assumed that temp object allocation wasn't an issue. I will also add that I have seen this only 3 times...

Brandie Tarvin (5/21/2015)

---

So we have new servers that are going to be installed with SQL 2012 and I'm debating the wisdom of splitting tempdb with multiple files.

I know it's...

Search SQLServerCentral for Perry Whittle Always On Staircase. Great series to get you pointed in the right direction.

PLEASE do be careful though! Always On is chock FULL of caveats, limitations,...

OP: you have been going at this for several days now, with the loss of your SQL Server functionality clearly affecting your business operations. Right from the very start on...

GilaMonster (5/18/2015)

---

Personally I can't even see where a merge join would be...

STAY AWAY FROM DTA!!!!!!!!!! I once had to spend over 200 man hours of my time unwinding the mess a client created with rampant use of it. They eventually made...

Quick review reveals Scalar UDFs, NOT INs and Functions Around Columns in WHERE clause. 2 of those 3 are BAD BAD BAD things todo in a query and the other...

Didn't read in close detail, but here is my take on some things:

Several others beat me to it but I will add my hat to the ring of "you need...

Zeal-DBA (5/18/2015)

---

but in my production environment i have 4 DBs ... in which 3 DBs are publisher and one is subscriber.. all 3 DBs are replicating some of their objects...

mdsantos (5/15/2015)

---

This is the QUERY constructed.

declare @Destinations table (Destination nvarchar(50))

insert into @Destinations (Destination)

Select Distinct 'K2SQL:' + CODE collate Latin1_General_CI_AS as destination from Claims.dbo.t_usersEntityRelation A

inner join (

...

Having HyperV in the mix just adds to the things that can be misconfigured or go sideways.

Can I ask why Always On was used without someone at the company that...

When I want to just measure server performance I put all outputs from a select directly into variables. Then no return to SSMS no matter how many rows affected.

Only a few things that can cause heartbeat to be missed I would think. Check and recheck your configuration. Obviously simplest thing is direct crossover cables on dedicated NICs. Have...

1) Don't need shared storage is the most prominent advantage for most I think.

2) Can set up readable-secondaries....

I think this is usually a Listener type issue. But AlwaysOn is COMPLEX and there is no telling what is messed up on your system. Did you test failover before...