Click here to Skip to main content
13,191,400 members (83,077 online)
Rate this:
Please Sign up or sign in to vote.

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.

Posted 8-Jan-13 15:49pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You really can't do that, it makes no sense. You'd have to copy all the data from server 1 to server 2, so what you read, is what you wrote. Then they are the same, so why bother ?
cyanceenu 8-Jan-13 22:13pm
Actually we have 3 web applications and 3 internal VB projects, which are pointing to the same (one) database server which is having 7 databases.
Now the problem is, sometimes when huge count of users using the web applications, and at the same time while internal transactions are done. At this situations the server is not responding, hence getting hung.
Can you please give me the better solution for this case.
Christian Graus 8-Jan-13 22:14pm
Do your internal transactions at night. Get SQL Server running on a bigger machine, with more cores, or multiple machines.
Aha, they will do these internal transactions in U.S. during night, and at the same, time, you, from Australia... the same thing would happen if you advise them to do their internal transactions, say, in winter... :-)
Christian Graus 8-Jan-13 22:40pm
Assuming they have a site that has users worldwide, and htat the load is the same 24 hours a day. If so, they need bigger servers.
tiggerc 9-Jan-13 10:05am
you could look at setting up a Database server cluster, this would give you load balancing I believe. but also upgrading hardware may benefit you some what.

SQL server has clustering built in provided you are not running SQL express editions( to the best of my knowledge ) and clustering provides failover in case one goes belly up the other will continue, and also load balancing under many connections.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.171017.1 | Last Updated 8 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100