SQL Server - Get started

Create an instance

To get started, connect to ITCare and search your target Global Service where you will create your new SQL Server. Once inside your Global Service, click on the Create Resource button in the top right corner.

Go to Managed databases and select SQL Server:

Pick the desired version and edition:

• Name: Provide the new name of the SQL Server virtual machine.

• Sizing: Select a sizing for your instance. Default value and lowest sizing is 2 CPUs / 4 GB RAM.

• Storage: Select the storage capacity required for SQL Server. Five disks are required.

  • Default and minimum storage is 30 GB for root instance and user datas disks, 10 GB for user log and tempdb disks.

• Localization: Select the Region you want to deploy to. Pick an Area in this Region and finally select an Availability zone.

• Network: Select the VLAN you want to deploy into. Ideally your backend VLAN.

• Authentication: Select the authentication domain you want to deploy into.

• Management: Activate management options.

  • Enable or disable Monitoring

  • Enable of disable 24/7 Monitoring

  • Enable backup of your virtual machine

  • Enable Replication of your virtual machines (on Disaster recovery site)

Customization

Provide the administrator password that you will use for your SQL Server administrator user.

cegedim.cloud will NOT save this password so please save it somewhere safe in your vault.

• Confirm your password.

• Choose your SQL collation.

• Add key technologies available in SQL Server : SSIS, SSAS, SSRS

You can add a specific request before submission but it will delay the automated provisioning.

Click Next when done.

Synthesis

This page will resume your inputs, please check everything is correct before submitting. You can display and save your administrator password.

Once reviewed and verified, click Submit.

Notification

Once the deployment is ready, you will be notified by email. Provisioning can take up to 1 hours based on the current load on automation.

Start a deployment

At the top of the resource page, click on the Manage button, then on Start and confirm.

Cluster startup starts all virtual machines attached to the cluster.

An e-mail notification will be sent when the service is activated.

Stop a deployment

At the top of the resource page, click on the Manage button, then on Stop. Enter an RFC number for tracking (optional). Click on Submit.

Shutting down a cluster will stop all virtual machines attached to the cluster, and monitoring will be disabled.

An e-mail notification will be sent when the cluster is shut down.

Resize nodes

At the top of the resource page, click on the Manage button, then on Resize. Select the new size (CPU / RAM).

Each node will be resized and restarted sequentially.

Resizing will interrupt the SQL Server service !

An e-mail notification will be sent when all nodes have been resized.

Delete a deployment

At the top of the cluster page, click on the Manage button, then on Delete. This will stop and delete all virtual machines.

Please note that this action is not recoverable!

Enter an RFC number for tracking (optional), then click Submit.

An e-mail notification will be sent when the deployment is deleted.