Scaling web application with SQL Server 2008 database
Posted
by
John
on Server Fault
See other posts from Server Fault
or by John
Published on 2012-06-23T06:34:13Z
Indexed on
2012/06/23
9:19 UTC
Read the original article
Hit count: 132
I have a database which has 90% of read only tables. 10% of the tables has writable data. We need to scale the ASP.NET application.We need to add more users who will not be writing to the database. We are thinking of adding another server and routing the users who need read only access to that server. Is there a way to replicate just some tables to another database server. Since the 90% of data doesnt change, we don't want to setup any full database replication. Please advise.
© Server Fault or respective owner