| |

When do we need asymmetric storage with AlwaysON FCI and Availability Storage?

Before we start the discussion on SQL 2012 AlwaysON let me define the terminologies introduced with SQL 2012. As we all know with SQL 2012, we have AlwaysON solution which provides us with a HADR Solution. SQL 2012 AlwaysON can be configured in 2 modes viz AlwaysON      Failover Clustering Instance (FCI):  This is the…

| |

SQL Server: Does Parallel Plan for rebuild index impact the fragmentation of index?

The title for this post might sound ironical since rebuild of the index is used to remove the fragmentation of the index so how does rebuild of index affect the fragmentation of index? Well, this is what I would like to explain in this blog post. Generally, for rebuilding of indexes (alter index … rebuild)…

|

SQL Server 2012 AlwaysON Automatic Failover Set – Caveat

As I was going through the documentation of AlwaysON, I came across the following caveat with SQL Server AlwaysON Automatic Failover set. While we can have upto synchronous secondary replica,  we can have only one secondary replica to be part of Automatic Failover Set. Now, what that means is only of the synchronous secondary replica…

|

Performance Tuning with Columnstore index using Batch Processing

As we all are aware, SQL 2012 introduced columstore indexes which is based Microsoft’s xvelocity in-memory engine  and as you might have heard and read in numerous articles it is known to provide 5-50X improvement in performance of queries. Reading and Hearing 5-50X improvement in performance of queries causes many eyes to pop-out and they…

SQL 2012 Resources !!!

As we all are excited with the release of SQL 2012, it is important for all of us to quickly rampup and equip ourselves with SQL 2012. In this blog post, I am sharing some of the important SQL 2012 resources which are available which can help you in your readiness. SQL 2012 Product Guide ================== http://www.microsoft.com/en-us/download/details.aspx?id=29418 SQL 2012 Developer Training…

|

Failed to join the instance to the availability group while configuring AlwaysON

As SQL 2012 is in it’s RC0 phase, I was trying to configure AlwaysON on my 2-node WSFC with node and disk majority.Next I installed Default instance of SQL Server in parallel ( to save some time ) on both nodes of the WSFC.Next I enabled my instances for AlwaysON from SQL Configuration Manager for…