can we maintain 2 servers for database in .net applications.
so that our application can use one server for all the data writing,
and another server for data reading..
Our application is built in traditional 3 tier architecture
- Presentation Tier (Front end)
- Logical Tier (Middleware)
- Data Tier (Backend).
In data tier all the data connections are maintained in Web.config.
Please suggest me a good and better approach.
Thanks in anticipation.