How to load balacing with SQL Server 2008?

[PlateT]

Hi all.

My Application is using a database running SQL Server 2008 in 1 Server.

Now, Performance of Database Server is higher because the transaction number which access to database is more than before.

So, I want to solve this problem by a solution as load balancing.

Please give me some advice and solution !

Thanks all and Best Regards.

[skhanal]

SQL Server supports load balancing on read only database only, where more than one instance access the same database.

However other ways to load balance will be

1. Add a new SQL Server and setup merge replication between two servers, you can then load balance the connection using any load balancer (Cisco, F5).

2. If merge replication is not an option then you have to consider splitting the application and database if possible.