August 10, 2012 at 1:53 am
Hi
In My project is university related.we are using sqlserver 2005.In my production server whenever hit 300000 students that time my database server performance is very worst.In this scenario my web server, we are using load balancer.
In my question what i will do in database server? please give me a idea how to load balance database server?
August 10, 2012 at 4:09 am
move it to active- active cluster.
this is not exact load balance google for more details i am not an expert in that.
what is the cpu usage of db server at that point of time.
Regards
Durai Nagarajan
August 10, 2012 at 4:53 am
SQL is none load balancable.
But you can get cleaver with transactional replication with updateable subscriptions, peer to peer replication to create a sort of load balanced environment.
What is the bottleneck? Reads? Writes? Both?
If reads, you could have multiple server with read only copies of the database and 1 server which handles all the writes and pushes them out.
If writes or both you would need multiple servers which sync with each other which is where the replication comes into place.
August 10, 2012 at 5:45 am
durai nagarajan (8/10/2012)
move it to active- active cluster.this is not exact load balance google for more details i am not an expert in that.
Active-active cluster (more correctly called a multi-instance cluster) is not load balancing. It's 2 SQL instances serving two sets of databases.
Scaling out SQL Server is difficult. The usual methods include peer-to-peer replication and service broker.
For full details: http://msdn.microsoft.com/en-US/library/cc917714.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply