Good thoughts, but it doesn't seem related at all. At least nothing in logs or that performance counters can demonstrate. It cleared up now, so I can't get any more...

Well, you can't change the instance name, but you can change the servername and then create the AG name with the old server name?

We had an existing SQL Failover Cluster Instance (FCI) that needed to replicate out to a read only reporting server. They wanted that highly available and real-time. They originally wanted...

You can connect to instanceA as you always do, as it is its own object and really a stand-alone instance. You can do the same to the second new instance....

Update: I tired to use CAUSALITY_TRACKING, but I am not familiar with it too much and I believe I would have had to add another event like sql_statement_starting and I...

Good idea Grant! I just recreated my event with this. We'll see what I find. Also, I track requests on a poling interval in a table and I am going...

Unfortunately, yes.

According to the xml it is read committed. In addition, I looked at my logging table for a snapshot of requests, and this one is coming in at read committed...

Hey Grant! I have a feeling that this Entity Framework is doing more than just the sql coming in from input buffer on the deadlock graph. I'm just curious why...

spaghettidba (3/10/2015)

---

So, I asked a few friends and turns out that if you don't set the transaction isolation level explicitly, it takes the default, which is read committed as far...

SQLKnowItAll (3/10/2015)

---

I set up a test, and I can't even get Serializable to work right:

Connection 1 on serverA:

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

BEGIN TRAN

SELECT * FROM serverB.database.schema.table WHERE idCol =...

I set up a test, and I can't even get Serializable to work right:

Connection 1 on serverA:

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

BEGIN TRAN

SELECT * FROM serverB.database.schema.table WHERE idCol = 1;

...

ken.trock (3/9/2015)

---

Perry Whittle (3/9/2015)

---

first thing I would ask is what is the recovery model in use on the DW database?

I'm sure you've heard a hundred times "don't shrink your transaction...

So, I just asked Paul at that same post you provided. He basically said that you won't see it, it just is serializable... Very interesting...

Grant Fritchey (2/19/2015)

---

It's usually very dangerous to compare cost to cost between different queries. Since the costs are just estimates, when the query changes, so do the calculations. Costs are...