This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

MSSQLServer

1 - Configurations

Important default values

max_connections

  • SQL Server has no direct “max connection per GB of RAM” rule. The actual number of user connections allowed depends on the version of SQL Server that you are using, and also the limits of your application(s), and hardware.
  • SQL Server allows a maximum of 32,767 user connections.
  • User connections is a dynamic (self-configuring) option, SQL Server adjusts the maximum number of user connections automatically as needed, up to the maximum value allowable.
  • In most cases, you do not have to change the value for this option. The default is 0, which means that the maximum (32,767) user connections are allowed.
  • To determine the maximum number of user connections that your system allows, you can execute sp_configure or query the sys.configuration catalog view.
  • For more info: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-user-connections-server-configuration-option?view=sql-server-ver16&viewFallbackFrom=sql-server-ver16.

2 - Limitations

Every product has limitations. Below is a list of Microsoft SQL Server limitations:

License

  • The standard license is applied.

Configurations

  • Single node (no High Availability)
  • Always On (2 nodes, asynchronous commit mode, High Availability)

Always On-specific limitations

  • Refer to the Microsoft standard license for a complete list of limitations.
  • Only asynchronous commit mode is currently supported.
  • The ccxdb is currently the only supported Always On enabled database.
  • Scaling is not supported as the standard license does not permit more than two nodes.

User-created databases (not Always On) are not transferred to the replica

  • In the Always On configuration, only the ccxdb is replicated.
  • Data loss may occur for other user-created databases, as they are not transferred to the replica during the add node process. Therefore, they may be lost if a failover, automatic repair, or any other life-cycle management event occurs.

3 - Overview

CCX supports two Microsoft SQLServer 2022 configurations:

  • Single-node (No high-availability)
  • Always-on, two nodes, async-commit mode (high-availability) in an primary-replica configuration.

The ‘standard’ license is applied.

Scaling

Scaling is not supported in SQLServer as of the standard license.

Storage

  • Maximum size depends on the service provider and instance size
  • Volume type cannot currently be changed

Further Reading

4 - User Management

CCX supports creating database users from the web interface.

The database user is created as follows:

CREATE LOGIN username WITH PASSWORD = 'SECRET',  DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF,  CHECK_POLICY=OFF
ALTER SERVER ROLE [sysadmin] ADD MEMBER [username]