July 20, 2015 at 12:33 pm
I am trying to understand an environment and provide a solution to Banking system so that they can enter user data (transactions) online and at the same time we can provide users online reporting as well. Using same sql server or server/hardware on other machine.
There are so many branches/customers/ATM machines accessing online data as well as updating their balances. I want to understand how can we provide online reporting. Through replication, transaction log backup, log shipping or what other solution is available. I need to understand this and provide a solution that is already implemented running/successfully. Need some proposals and their pros and cons. cost and maintenance are the constraints with the real time reporting on live system/database.
Shamshad Ali
July 20, 2015 at 1:06 pm
If you are really on SQL Server 2014 or even 2012, I'd recommend an AlwaysOn Availability group with a synchronous read-only secondary.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 20, 2015 at 1:12 pm
Thanks, can you please explain a little more? with a diagram of infrastructure. We are on 2012 and can move on 2014 if beneficial?
Shamshad
July 20, 2015 at 1:21 pm
Please lookup AlwaysOn Availablity Groups using your favorite search engine. All of this is documented in multiple places including BOL. This site also has nice set of articles about it by Perry Whittle, which you can find here, http://www.sqlservercentral.com/Authors/Articles/Perry__Whittle/354339/
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 20, 2015 at 1:30 pm
OK, will study AlwaysOn feature. but what about those who are on 2008? How are they handling this situation? Do you think high availability will provide high performance on a cluster environment for fast real time reporting? Thanks for your help.
Shamshad
July 20, 2015 at 2:00 pm
Prior to 2012 the options for this were replication and log-shipping. As you read up on Availability Groups I think you'll find that they are probably the best way to go for offloading real-time reporting from the production server.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply