solving sql server problems for millions of dbas and developers since 2006

SQL Product Highlight

Idera - SQL compliance manager

SQL compliance manager is a comprehensive auditing solution that tells you who did what, when and how on your SQL Servers. SQL compliance manager helps you ensure compliance with regulatory and data security requirements.

Learn more!

Load sharing on a different server

Asked 2/18/2012 4:19:38 AM by Vahid

Dear frinds:

Consider a large site with many users.

I want the project database on the server for 3 to speed up distribution.

How do I make the connection between these three databases?

Which way should I insert in the database?

Please friends to express their opinions.

Thank's.

Answered 2/18/2012 6:37:05 AM by Jeremy Kadlec

(0)

Vahid,

I am not exactly sure what you are asking. Are you asking about a multi-node cluster or a distributed database infrastructure with some sort of replication?

Can you provide some clarification?

Thank you,
Jeremy Kadlec

Answered 2/18/2012 11:32:10 PM by Vahid

(0)

Jeremy

1-Thank you..

2-My goal is distributed database .

In fact, I want your database on multiple servers to distribute

Now i dont know what algorithm???beacause i have to insert in database now if i have a databaes on multiple server ,when that i want insert in database i should Which server should I go to do the operation

Insert or update or ....???

Sponsor Information

Try the free performance monitoring tool from Idera!

Write, edit, and explore SQL effortlessly with SQL Prompt.

SQL Servers keeping you up at night? Contact the Edgewood SQL Server DBAs for a Health Check. Prices start at $995.

Get SQL Server Tips Straight from Kevin Kline.

Join the over million SQL Server Professionals who get their issues resolved daily.

Demystify TempDB Performance and Manageability