How do I modify the time zone in TencentDB for SQL Server?
TencentDB for SQL Server modifies the time zone strategy based on different architecture versions as follows. For more information on the system time zone and detailed modification methods, see Modifying System Time Zone.
Dual-node local disk instances:
Since modifying the system time zone requires separate configuration of machine resources, if you need to modify it, please submit a work order before purchase to get a solution and specify the system time zone to be adjusted. Modification is only supported for instances with 90 cores and 720GB specifications. If you need to modify the system time zone, it is recommended to directly purchase the Cloud Disk Version Dual-Node Instance, which allows modifications on the purchase page without specification limits.
Single-node cloud disk/Dual-node cloud disk instances:
When purchasing single-node cloud disk/dual-node cloud disk architecture instances, you can directly modify the system time zone on the purchase page.
Note:
For instances with the modified system time zone, the actual back-end data storage is in the modified UTC time. After conversion, backups, rollbacks, and slow log files are displayed in the console in Beijing time, and the monitoring time is Beijing time.
If you have modified the system time zone for your instance, and a subsequent scale-out involves data migration, please submit a work order to obtain a solution.
How do I modify a character set collation in TencentDB for SQL Server?
TencentDB for SQL Server has two dimensions of character set collation: instance dimension and database dimension
The default character set collation for the instance dimension is Chinese_PRC_CI_AS. TencentDB for SQL Server modifies the instance dimension character set collation strategy based on different architecture versions as follows. For more information on the character set, see Modifying Instance-Level Character Set Collation.
Dual-node local disk instances:
Since modifying instance-level collation rules requires separate machine resources configuration, if modification is needed, please submit a ticket for a solution and provide the target collation before purchasing.
If the collations have been modified for your instance and subsequent scale-out involves data migration, please submit a ticket for a solution.
Single-node cloud disk/Dual-node cloud disk instances:
You can modify the instance-level collation rules directly on the purchase page.
The character set collation for the database dimension can be specified when creating the database. For details, see Create a Database. If not specifically specified, the database character set defaults to Chinese_PRC_CI_AS.
How do I modify the configuration parameters of TencentDB for SQL Server?
You can log in to SQL Server console, in the instance list, click the instance ID, select Parameter Configuration > Parameter Settings page, and modify the instance parameters. For details, see Setting Instance Parameters.
Which parameters can I modify quickly in the TencentDB for SQL Server console?
You can log in to SQL Server console, in the instance list, click the instance ID, select Parameter Configuration > Parameter Settings page, and modify the instance parameters. Currently, the following parameters are supported for modification.
fill factor(%)
max worker threads
cost threshold for parallelism
max degree of parallelism
optimize for ad hoc workloads
min server memory(MB)
blocked process threshold(s)
How do I view parameter modification logs in TencentDB for SQL Server?
You can log in to SQL Server console, in the instance list, click the instance ID, select Parameter Configuration > Modification Log page, and view parameter modification logs. For details, see Viewing Parameter Modification Log.