Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET .NET SQL-Server VB.NET , +
Hi..
 
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.
 
-Sri
Posted 8-Jan-13 16:49pm

1 solution

Rate this: bad
good
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 ?
  Permalink  
Comments
cyanceenu at 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 at 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.
Sergey Alexandrovich Kryukov at 8-Jan-13 22:39pm
   
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... :-)
—SA
Christian Graus at 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 at 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
0 OriginalGriff 495
1 Maciej Los 340
2 Richard MacCutchan 265
3 BillWoodruff 225
4 Mathew Soji 200
0 OriginalGriff 8,804
1 Sergey Alexandrovich Kryukov 7,457
2 DamithSL 5,689
3 Maciej Los 5,279
4 Manas Bhardwaj 4,986


Advertise | Privacy | Mobile
Web02 | 2.8.1411028.1 | Last Updated 8 Jan 2013
Copyright © CodeProject, 1999-2014
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