but UPDATE STATISTICS with FULL SCAN will scan for the entire table everytime and unnecessary update stats even if its not needed. i ran a samle update stats with full...

I upgraded my SQL from 2008 R2 to SQL 2012. We had DB Mirroring earlier and now I have configured Alwayson which is pretty cool. I would advise to run...

Check the quorum configuration via always on dashboard. It will show you number of votes for each of the nodes and file share witness. All should have 1 vote.

Also you...

Yes, only the major build version, not SP's, unless those SP's have something very specific to that particular feature which will require both the partners onto the exact same version.

Well, I was able to configure with 2 different SP's - SP1 and SP2 on 2 Sql servers without any issues. All my user dbs are synchronized and working fine.

got it... thank you 🙂

ok, gotcha..

but after the failover has happened, the Mirroring should establish connection back with New Principal and get synchronised rite?

Yes multi instance cluster...

DB Mirroring is in Asynch mode and Manual failover...

Thanks PS.

I configured a file share witness to set a quorum. Now both my nodes and File share have 1 vote each and cluster will be running fine till majority...

Hi Grant - I am aware of the SQL AG part...

What I was looking for cluster quorum configuration with my kind of setup.

i.e. With 2 nodes under FCI, what kind...

Not at DB level.

All DBs get failed over within that AG.

However, if you have multiple AGs on the same instance, you can fail them over individually.

HTH

Kishore

Check this link : http://blogs.msdn.com/b/jtarquino/archive/2011/12/12/configuring-a-readable-secondary-routing-in-sql-server-2012-alwayson.aspx

You can configure the Routing URL and Routing List to re-direct your read queries to either Principal or other available secondaries.

HTH

Kishore

Thanks Grant. The link helped a lot. I had to configure the READ_ONLY_ROUTING_URL and READ_ONLY_ROUTING_LIST to make it work.

Cheers !!

Kishore

Any idea folks? 🙂

Is there any impact to mirroring if transactional replication is broken for instance?