LogoLogo
cegedim.cloudITCareAPIPrivacy
English
English
  • Documentation
  • ITCare
    • What is ITCare ?
      • Get started with ITCare
      • Demos
    • Enercare
      • Carbon footprint
    • Release notes
  • ITCare API
    • Overview
    • Authentication
    • Errors
    • Pagination
    • API Reference
      • Quick start
      • Analytics
        • Matomo
      • Changes
        • Changes
      • Compute
        • Application Servers
        • Backup Policies
        • Containers
        • Environments
        • Instances
        • Platform
        • Resource Filters
        • Resource Types
        • Resources
        • Services
        • Statuses
        • Tag Keys
        • Tag Values
        • Types
      • Databases
        • Databases
        • MariaDB
        • OpenSearch
        • PostgreSQL
        • Redis
        • SQL Server
      • Hardwares
        • Hardwares
      • Messaging
        • Apache Kafka
        • Message Brokers
        • RabbitMQ
      • Networking
        • Domains
        • Load Balancers
        • Network Clusters
        • Networks
      • Operations
        • Actions
        • Operations
      • Storage
        • Glusterfs
        • Overdrive
      • Topology
        • Topology
  • Services
    • Products
    • Support policy
    • Patch policy
    • RACI
  • Analytics
    • Matomo
      • Matomo - Features
      • Matomo - Get started
  • Compute
    • Virtual instances
      • Virtual instances - Features
        • Linux - Hardening
      • Virtual instances - Get started
    • Containers (K8s)
      • K8s - Features
        • Hardening
        • Persistent Storage
      • K8s - Get started
        • High Availability
  • Databases
    • MariaDB
      • MariaDB - Features
      • MariaDB - Get started
    • OpenSearch
      • OpenSearch - Features
        • v2 - Breaking changes
      • OpenSearch - Get started
    • PostgreSQL
      • PostgreSQL - Features
      • PostgreSQL - Get started
      • PostgreSQL - Upgrade
    • Redis
      • Redis - Features
      • Redis - Get started
      • Redis - Upgrade
    • SQL Server
      • SQL Server - Features
      • SQL Server - Get started
  • Messaging
    • Apache Kafka
      • Apache Kafka - Features
      • Apache Kafka - Get started
      • Apache Kafka - Upgrade
    • RabbitMQ
      • RabbitMQ - Features
      • RabbitMQ - Get started
    • SMS
      • SMS - Get started
  • Monitoring
    • ExtraHop
  • Security
    • Advanced Vulnerability Assessment
    • Bot Defense
      • Bot Defense - Features
    • Data Masking
      • Data Masking - Get started
    • Phishing Campaign
  • Storage
    • GlusterFS
      • GlusterFS - Features
      • GlusterFS - Get started
    • Object Storage
      • Object Storage - Features
        • S3 API compatibility
        • Limitation and Best Practices
        • Presigned URL
        • Bucket Policies
        • Bucket Lifecycle
        • Object Lock
      • Object Storage - Get started
        • Manage Object Users
        • Manage versioning in Bucket
        • Manage Bucket access
    • OverDrive
      • OverDrive - Features
      • OverDrive - Get started
Powered by GitBook
On this page
  • Create an instance
  • Customization
  • Start a deployment
  • Stop a deployment
  • Resize nodes
  • Delete a deployment
Export as PDF
  1. Databases
  2. SQL Server

SQL Server - Get started

PreviousSQL Server - FeaturesNextApache Kafka

Last updated 5 months ago

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

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.