FAQ

1、What are the prices for SQL Server in the Cloud?

The SQL Server cloud database includes Microsoft-licensed authorization and offers annual, monthly, and hourly billing options. Pricing consists of three main factors: instance specifications (CPU cores and memory capacity) and storage space (disk capacity). For detailed pricing information, please refer to the Product Pricing section.

2、How to purchase SQL Server in the Cloud?

Login to the SQL Server console and create new instances or directly call the API to create and purchase instances.

3、Do I need to purchase a SQL Server license declaration myself?

UCloud offers a “license-included” model for cloud databases, where SQL Server software licenses, underlying hardware resources, and UCloud UDB management capabilities are bundled into the pricing. This means you don’t need to purchase a separate Microsoft SQL Server license. With this license-included cloud database model, you can pay based on instance specifications and usage time without needing to account for hardware and license costs separately. This model converts high fixed costs into manageable variable costs, reducing your IT expenses.

4、How to download and install SQL Server Management Studio?

First, get the installation package of SQL Server Management Studio, option 1: download via downloading link: http://udb-files.cn-bj.ufileos.com/setups/SSMS-Setup-CHS.exe

Option 2: visit the Microsoft website to download the SQL Server Management Studio installation package.

Then upload the installation package to the cloud server UHOST, double click on the installation package and follow the wizard to complete the installation.

5、How to view the parameter information of the database?

After connecting to UDB, execute the following SQL statement to view:

select * from sys.configurations

6、How to view the connection information of the current database?

After connecting to UDB, execute the following SQL statement to view:

select * from sys.dm_exec_connections

7、How to view the space usage of the current database?

After connecting to UDB, execute the following SQL statement to view the space usage of the database:

use Database Name; Exec sp_spaceused;

8、How to view the space usage of a table?

After connecting to UDB, execute the following SQL statement to view:

use Database Name Where the Table is Located; Exec sp_spaceused 'Table Name';