Idea ID 2775776
Right now it is necessary to install the MSSQL server on the same host as the Connected Backup application. It sometimes causes performance bottleneck and it’s hard to track or monitor the performance parameters responsible for DB memory hiccups resulting frozen instances in occasions. The idea is to separate the SQL Server from the Data Center and have a clustered database architecture that would yield better performance, tractability, data safety and fail-over. SQL Farm is one such solution that increases data availability, safety and scalability, simplifies license costs, and provides a platform which can grow as required.
How SQL Farm works?
SQL Farms allows database administrators to automate project releases, stop SQL services on all network instances and administer a farm of SQL Servers, instances and databases the same way they manage a single database today. The tool also offers command-line executions and deployment to support schedule deployment and execution of code and tasks, including scheduled password synchronization and scheduled rollouts of database objects and code.
Impact: Almost all the large customers would benefit with this enhancement.
JIRA reference: [CB-38379] Allow Data Center to work with Remote SQL Installs
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.