WhiteLotus

Let me understand your setup:

You have 3 servers (Server A, Server B, Server C) in which all db's are mirrored from Server A to Server B?

On Server A you had...

How are you accessing AlwaysOn server? by listener? or by primarynodename?

Did you try recreating the subscription?

BLandry474 (10/21/2016)

---

Alex,

Here is the basic code I used. This produces a nice temp table of information and of course, you can edit the query if you don't want all...

BLandry474 (10/21/2016)

---

Hanshi,

Thanks for your reply, but unfortunately its way over-complex. I found a way to do this that is simple and elegant.

1. Run SP_COLUMNS and direct output to a...

JarJar (10/6/2016)

---

We are doing a DRP test on a large database, which is hosted on an AlwaysOn availablilty group with 3 replicas (2 sync, 1 async). The plan is...

Under SQL Agent

1.Create an operator usually a dba group email or your own

2.Right click alerts New Alert

3.Name it and choose

Object: SQLServer:Databases

Counter Data File(s) Size (KB)

Instance: tempdb

Alert if counter: Rises...

Have you experienced same redo latency if you failover between nodes?

Bjarne

I would recommend upgrading to CU2.

https://support.microsoft.com/en-us/kb/3182270

Are you in async mode?

Can you describe your AlwaysOn setup

j21283 (5/25/2016)

---

I'm hoping some folks might be able to help out with a poor performance situation for our SQL server.

We recently did a major system upgrade from SQL 2008 and...

er.mayankshukla (5/3/2016)

---

Hi All,

I am using a data load via SSIS, and was expecting row locks on the destination table.

However when I see sys.dm_tran_locks I see resource_type as File locked in...

Perry Whittle (4/14/2016)

---

AlexSQLForums (4/14/2016)

---

Hi Everyone

I have a 2 TB Production db in AlwaysOn synchronous auto failover mode.

I have a 600GB(230 million rows) table which I would like to move to...

[/quote]

Do you have a link to the MS documentation for the bug?[/quote]

https://support.microsoft.com/en-us/kb/2699720

Prakash.Bhojegowda (10/6/2015)

---

SSIS package jobs in SQL 2012 failing with deadlocks. Execution Report of SSIS package has “ Created Execution” status

Issue: SQL Agent jobs running an SSIS packages failed with below...

Studdy05 (9/30/2015)

---

Today a vendor bluntly stated that VMWare provides the same failover and redundancy for SQL that would render "AlwaysOn" high availability unnecessary.

Essentially that VMWare would detect a problem and...