@alzdba - Thanks for the link. I searched on Brent's website but somehow missed this link 🙂 Will go through that and try to get more info.

I know this is an old question and hope this got resolved for you.
Usually this happens when namedpipes is not enabled. I had a similar issue and got it...

I suspect your last point to be the reason. Because we found that the replica was not synchronizing at the time of failure and hence log file might have become...

Yes we do.

Finally we have managed to find the answer !

The difference was caused due to the bad format of disks being used for the data file. We had few disks formatted...

Update to the topic.

Microsoft really did not suggest a great deal of improvements except to use OPTION (Force Order), changing MAXDOP settings, running the query in DTA and implementing index...

I had made sure that all the stats for tables being referenced are updated. i ran the below query to verify the same.

use <Database Name>

go

SELECT name AS index_name,

STATS_DATE(OBJECT_ID, index_id) AS...

Thanks you for a very detailed explanation @Grant.

There might be few differences in the number of rows from fast - slow instance. That is because Fast instance is currently LIVE...

While updating the stats i used FULL SCAN and also the MAXDOP settings are same on both the servers.

I enclosed the plans.

Thanks for all the replies.

I am planning to build a practice lab for SQL 2012 clustering and availability services. I wanted to try the trials that each of the big...

I think 1GB should be ideal for a base drive letter and then configure mountpoints for that drive letter with required sizes.

Those are some clear directions i can start from. I am sure the data is exactly the same because i restored it from source to destination. However fragmentation, updating statistics...

Actually applications have been migrated from old datacenter to a new one. We were not managing the old one and observed only after we migrated to new DC and starting...

Thanks for your answers.

We have decided to have "Enforce password Policy" on for all non-domain accounts.

Thank you for the answer.

Is there is a way through which I can force some restrictions on password being created without having to select "Enforce Password Policy". Like for...