I have a MS SQL Server 2014 database with large scale of data an lots of users;
and the RAID level is equal to 10. Now due to the rapid growth of data amount, I'm going to distribute this one database over two servers. What's the best solution for that?
Sql-server – What’s the best solution for distribution of one database over two servers
distributed-transactionssql server
Related Question
- Sql-server – Best solution to fixing database design with GUID as primary key
- Sql-server – Slow SQL Server Database (approx 2TB) – high CPU due to index fragmentation
- Sql-server – Best practices for configuring the Drive/Filegroup setup for Microsoft SQL 2008
- SQL Server – Transaction Log Full Due to ‘XTP_CHECKPOINT’
- SQL Server – Multiple Databases for One Web Solution Design Pattern
- SQL Server – Best Way to Archive All But Current Year and Partition Table
- Sql-server – COUNT(*) OVER ()
Best Answer
Try using sql server failover cluster