# 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**:

<figure><img src="https://835168969-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F2FXoHyOBZPpJv3UALn4V%2Fuploads%2Fgit-blob-313f8b97ccb08be5a68e1cb37ec9dccd0902f072%2Fimage%20(16).png?alt=media" alt=""><figcaption></figcaption></figure>

Pick the desired version and edition:

<figure><img src="https://835168969-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F2FXoHyOBZPpJv3UALn4V%2Fuploads%2Fgit-blob-73d3510b34a27a6bdf51411611e9b1bab4b1d6c1%2F66897786-E491-45D0-A5DB-B69CB53CF50B.png?alt=media" alt=""><figcaption></figcaption></figure>

* **Name**: Specify the new name for the SQL Server virtual machine.
  * In Always On Cluster mode, specify the name of the **Availability Group**.
  * **Prefix**: Provide a prefix to initialize the virtual machines in the cluster.
* **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** <a href="#sqlserverhowtos-stepcustomization" id="sqlserverhowtos-stepcustomization"></a>

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

{% hint style="warning" %}
cegedim.cloud will **NOT** save this password so please save it somewhere safe in your vault.
{% endhint %}

* 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** <a href="#sqlserverhowtos-stepsynthesis" id="sqlserverhowtos-stepsynthesis"></a>

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 <a href="#sqlserverhowtos-notification" id="sqlserverhowtos-notification"></a>

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.

{% hint style="info" %}
Cluster startup starts all virtual machines attached to the cluster.
{% endhint %}

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**.

{% hint style="warning" %}
Shutting down a cluster will stop all virtual machines attached to the cluster, and monitoring will be disabled.
{% endhint %}

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).

{% hint style="info" %}
Each node will be resized and restarted sequentially.

Resizing will interrupt the SQL Server service !
{% endhint %}

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.

{% hint style="danger" %}
Please note that this action is not recoverable!
{% endhint %}

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

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