I just need your help in understanding of having SQL Server Standard 2012 and 2014 Enterprise version.
We do have CRM application on-prim. which runs based on SQL server. we do have right now 2012 standard version installed. We do have to runs 100's of reports which is based of SSRS and hitting every time to OLTP system.
We are thinking to get Enterprise 2014 which has "High Availability " or something like that option which is I guess live copy of the OLTP database.
If we do this, I believe it will be easier to run all SSRS report from copy as compared to direct OLTP DB.
Please let me know if this is viable option or there are other more practical approaches as compared to this!
Thanks.
Best Answer
It sounds like you are referring to Always On availability groups with a read only replica. 2012 EE as well as 2014 EE have this as an option and you can route reports to the replica without impacting the primary OLTP database.
Product Documentation