How do I modify the time zone in TencentDB for SQL Server?
The method for modifying the system time zone in TencentDB for SQL Server for different instance architectures is shown below.
Dual-node local disk instance:
Since modifying the system time zone requires a separate configuration of machine resources, if modification is needed, submit a ticket before purchasing to obtain a solution and specify the system time zone to be adjusted. Modification is supported only when you purchase instances with the specification of 90-core 720 GB. If you need to modify the system time zone, it is recommended to directly purchase cloud disk dual-node instances, which can be directly modified on the purchase page without specification limits. Single-node cloud disk/dual-node cloud disk/multi-node cloud disk instance:
When purchasing instances with a single-node cloud disk/dual-node cloud disk/multi-node cloud disk architecture, you can directly modify the system time zone on the purchase page.
Note:
For instances with adjusted system time zones, the actual data stored in the backend is the modified UTC time. After conversion, the time for backup and rollback, slow log file, and monitoring displayed in the console frontend is UTC+8.
For instances with adjusted system time zones, if subsequent scale-out involves data migration, submit a ticket to obtain a solution. How do I modify a character set collation in TencentDB for SQL Server?
TencentDB for SQL Server provides character set collations at instance and database levels.
Dual-node local disk instance:
Since modifying the instance-level collation requires a separate configuration of machine resources, if modification is needed, submit a ticket before purchasing to obtain a solution and specify the target character set to be adjusted. For instances with adjusted character set collations, if subsequent scale-out involves data migration, submit a ticket to obtain a solution. Single-node cloud disk/dual-node cloud disk/multi-node cloud disk instance:
You can directly modify the instance-level character set collation on the purchase page.
The character set collation for databases can be specified during database creation. For more information, see Creating Database. If it is not specified, Chinese_PRC_CI_AS will be used by default. How do I modify the configuration parameters of TencentDB for SQL Server?
Which parameters can I modify quickly in the TencentDB for SQL Server console?
Log in to the TencentDB for SQL Server console, click the ID of the target instance in the instance list, select Parameter Configuration > Parameter Settings, and you can modify the following instance parameters: 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?