It has been really long time since I have blogged. However I will try to blog as often as I can. Very Recently, I performed a SSRS Performance Review to tune performance reports for one of our customers. While analyzing some long … Continue reading
Category Archives: SQL 2012
Gotcha – Listening SQL Server Availability Group Listener on non-default port
TweetWhile configuring SQL Server AlwaysON Availability Groups, as a part of security hardening practice it is recommended to configure Availability Group to listen on a non-default port other than 1433. However the moment you configure your Availability Group Listener on … Continue reading
When do we need asymmetric storage with AlwaysON FCI and Availability Storage?
TweetBefore 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 … Continue reading
SQL Server: Does Parallel Plan for rebuild index impact the fragmentation of index?
TweetThe 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 … Continue reading
SQL Server 2012 AlwaysON Automatic Failover Set – Caveat
TweetAs 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 … Continue reading
Performance Tuning with Columnstore index using Batch Processing
TweetAs 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 … Continue reading
SQL 2012 Resources !!!
TweetAs 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 … Continue reading
SQL 2012: Indirect Checkpoint Explained !!!
TweetRecently I got an opportunity to present at the SQL Server day organized by www.SQLServerGeeks.com on SQL 2012 Indirect Checkpoints.In this post I would like to explain the same for the benefit of wider audience. The focus of SQL 2012 … Continue reading
Failed to join the instance to the availability group while configuring AlwaysON
TweetAs 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 … Continue reading