Allow Data Center to support remotely installed multi-instanced MSSQL Server with SQL Farm cluster

Idea ID 2775776

Allow Data Center to support remotely installed multi-instanced MSSQL Server with SQL Farm cluster

0 Votes

Idea Description:

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

1 Comment
Micro Focus Contributor
Micro Focus Contributor
Status changed to: Waiting for Votes
 
Most "Liked" Contributors
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.