Discussion on:

Scaling your SQL Server system

No, clustering isn't available in SQL Server for load balancing, only failover. You can, of course, use all available machines in your cluster as an active-active env. and use replication to keep the other servers "in synch" with the master. There is a new feature in 2005 called peer-to-peer replication that removes the heirarchial nature of replication, but it isn't going to solve any real problems.

0 Votes

+ -

is it possible to do load balancing by actve/active clustering???????

rabisahu3@... 30th Apr 2008

Dear Chapman,

I like to add a comments with your statement that in active/active sql server clustering, each instances of slq server HOLDS a unique virtual sql server name for clients communication.
Yes,if we have putted the same database with difference instance names then, how clients will access the database as per availability of servers???

It means client will be connected to each instances with its Virtual sql server name only.
Now tell me am I wrong or there is a possibility that clients can access any instance with a single Virtual sql server name?

0 Votes

+ -

Question Scaling your SQL Server system

javareda 29th Apr 2008

What would be the best way to increase the number of concurrent users on a system
I am talking about a system that involves uploading and dowloading a large amount of data metadata and files such as the ones used in a PDM system for CAD documents.
Thanks

0 Votes

+ -

Thank you Mr. Javereda, but i need some more help on this SERVER CLUSTER..

rabisahu3@... 6th May 2008

Thanks a lot Mr. Javereda,

Sorry I am asking many, but I am new in DBA job, so could you post any documents or site address which will be help me to do "increase the number of concurrent users on a system". what is "PDM system for CAD documents"

Please spare some time from your scheduled period...

Thanks again
Rabinarayan