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: 110

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

Related posts about sql-server-2008

Related posts about ASP.NET