Ford Fairlane (12/17/2013)

---

SQLSACT (12/16/2013)

---

Ford Fairlane (12/16/2013)

---

SQLSACT (12/12/2013)

---

Hi all

We are looking at implementing AlwaysOn AG combined with a Failover Clustered Instance of SQL Server. This is the setup:

>> 3 Nodes (A,...

Ford Fairlane (12/16/2013)

---

SQLSACT (12/12/2013)

---

Hi all

We are looking at implementing AlwaysOn AG combined with a Failover Clustered Instance of SQL Server. This is the setup:

>> 3 Nodes (A, B, C) joined...

The connection will drop because the secondary replica database will go into a resolving state

So all page splits cause a page allocation but not all page allocations stem from a page split?

Thanks for the link, it doesn't help however.

I'm looking for the difference between the 2 counters.

See http://technet.microsoft.com/en-us/library/ms189134.aspx

Going with Synchronous

You can't have automatic failover in this type of configuration

What further information do you need?

I think that everything you need is in those DMV's

Perry Whittle (12/11/2013)

---

Only if you have removed the voting...

Thanks Grant and Gail

Ok - my wording was wrong

Clean pages can be removed dropped from memory by the lazy writer, based on LRU.

My question is, I use the lazy writes/sec counter as one...

Thanks

The Lazy Writes/Sec counter monitors the amount of dirty pages are moved from to disk. Which counter, if any, measures the total amount of pages, including clean pages moved to...

I think you're confusing failover with quorum voting.

The quorum setup determines how many nodes need to be up in order for the entire cluster to stay up.

I would recommend that...

I've always maintained that if it's not broken, don't fix it. This is obviously besides routine maintenance.

However, as Grant said - Turn in on, monitor it and take it from...

OFAHW creates a plan-stub the first time an ad-hoc query is issued, the next time that same query is issued, SQL creates a full execution plan and removes the stub.

Are...