Solved

ms sql server with limited bandwidth

Posted on 2014-03-04
2
184 Views
Last Modified: 2014-03-28
I work in a office building that have t1 1.5 upload and download in internet connection.
And I want to develop an asp.net/c# intranet with MS SQL database 2012 for the internal office and allow website hosting in different location like goaddy.com to read/write the ms SQL Server, and I have the following worries.

1. Speed issue to load the database from the external website.
2. And with that slow speed it may even impact local office users.

And I am thinking to have co-location to host the database but I need to sync the data between two databases. and I think it is working but again speed is the issue.

Want to ask the experts we have any options in this case.

Thanks
0
Comment
Question by:CoolDev2014
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
Shaik M. Sajid earned 500 total points
ID: 39905612
Option1 :

try azure platform...

where u can sync your database to cloud ...

which will sync your SQL on cloud...  

with storage: SAN physical to cloud

which will do the block level replication which consumes very less bandwidth. and you can replicate database over lan

from there u can publish you site... it's a highly reliable solution...

http://oakleafblog.blogspot.com/2010/01/synchronizing-on-premises-and-sql-azure.html
0
 

Author Comment

by:CoolDev2014
ID: 39906942
Thank you very much for the information. It is very helpful.

Have below questions.

1. Is the data data sync is instant?  In my case, I will have intranet app.  in the office and website outside of the office. They both will instantly changes information.

2. Do you know any efficient way to test the bandwidth while it is syncing?
0

Featured Post

Get Actionable Data from Your Monitoring Solution

Your communication platform is only as good as the relevance of the information you send. Ensure your alerts get to the right people every time with actionable responses. Create escalation rules that ensure everyone follows the process and nothing is left to chance.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question