ramana3327 (10/20/2014)
We implementing always on mainly because of reporting server. We don't have OLAP source for the reports. Our current reports are running hours and hours and causing deadlocks on production database. So We are planning to have asynchronous replicas.
You're looking at Enterprise edition licenses for at least two servers (the primary and the async), does the budget support all that for reports that are probably still going to run for hours?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability