SQL 2008 Merge Replication

Hi Experts
my scenario like that
I have application with SQL 2008 database
we have 10 branches over country we working fine with Citrix Xenapp 6.5
due internet connection speed issue i planned to use SQL 2008 Merge Replication instead of Xenapp
my question is that
Is SQL 2008 Merge Replication save or leads to risks
and the replication time between servers every 1 minute will take a long time
i test merge Replication locally with 2 SQL servers it work fine delay 1 minute  to update each other

any idea
MASWORLDAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brian CTXSupportCitrix ConsultantCommented:
I'm not sure I understand the issue if is "working fine" as you stated.  It seems to me that the phrase "If it's not broken, don't fix it" applies in this case.
0
MASWORLDAuthor Commented:
@Brian CTXSupport thanks

Xenapp working fine but our users Growing rapidly so the internet connection 8 Mbps (with almost 50 Users on each site )seems like not enough any more so i thinking about SQL Replication
0
Brian CTXSupportCitrix ConsultantCommented:
Then upgrade the links.  Is Citrix the only traffic they are using the current links for?  I'm not sure how they can expect significant growth to not increase the costs to accommodate the additional needs.  I haven't worked in your specific scenario, but based off similar experience, you would likely create some serious issues if the replication fails, or there is data corruption.  The replication traffic would likely be greater than the Citrix traffic, so if the ability to handle the Citrix traffic is questionable, that wouldn't change with SQL replication.  I'm no expert on SQL, but I do know the ICA protocol is very lightweight by comparison, and specifically invented to do remote presentation so that the data would not need to be replicated across slower WAN links.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

MASWORLDAuthor Commented:
Then upgrade the links
i am working on that but due maintenance Issue in the ISP only 8 Mbps available right now

The replication traffic would likely be greater than the Citrix traffic
That's what I specifically ask ِabout

I have not measured the data transfer to the SQL Replication VS Xenapp
0
Brian CTXSupportCitrix ConsultantCommented:
What does the utilization look like currently over the links?  Is the Citrix traffic in contention with any other traffic on that link (mail, CIFS, etc)?  If the links are not saturated with other traffic (doesn't sound like they are from your first post), then you have some time to get the links upgraded.  Do you have any reporting options for the network utilization, hopefully broken down by service type?
0
MASWORLDAuthor Commented:
honestly, just email
but we didn't faced this issue with almost 30 users
0
Brian CTXSupportCitrix ConsultantCommented:
Do you have access to any reporting that would confirm for sure what's traversing the links?  You might be surprised, and I wouldn't just assume what you have there.  Are you certain there's no internet access traffic going over those links?  Can your ISP provide any reports, or do you have anything in-house?  Perhaps look at the ExtraHop demo appliance.

Do you have any QoS options available to prioritize traffic?

http://blogs.citrix.com/2010/05/20/how-much-bandwidth-do-i-need-for-my-virtual-desktop/  I know it's not XenApp, but the same principles apply.
0
MASWORLDAuthor Commented:
It seems to me that you think that the 8 Mbps sufficient for the number of users
Is it well
0
Brian CTXSupportCitrix ConsultantCommented:
The standard consulting answer is it depends on the use cases and what they are doing in the sessions, and what else it is having to compete with for network resources.  Without reporting everything is purely speculation.  Reporting will help you to know where you are at now, and potentially what you need to plan for.  It could also highlight something that you may be unaware of, which based off my experience, is very likely if you have no monitoring currently in place.
0
MASWORLDAuthor Commented:
OK
i got it
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Citrix

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.