tencent cloud

All product documents
TencentDB for SQL Server
DocumentationTencentDB for SQL ServerFAQsParameter Modification
Parameter Modification
Download PDF
Last updated: 2024-01-18 17:25:32
Parameter Modification
Last updated: 2024-01-18 17:25:32
Download PDF

How do I modify the time zone in TencentDB for SQL Server?

As TencentDB for SQL Server uses the China Standard Time by default and modifying the system time zone requires separately configuring physical machine resources, submit a ticket and specify the desired system time zone before you purchase an instance. For more information, see Modifying System Time Zone.

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.
The character set collation for instances is Chinese_PRC_CI_AS by default. To modify it, submit a ticket and specify the target character set to be modified. For more information, see Modifying Instance-Level Character Set Collation.
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?

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 modify instance parameters. For more information, see Setting Instance Parameters.

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?

Log in to the TencentDB for SQL Server console, click the ID of the target instance in the instance list, select Parameter Configuration > Modification Log, and view parameter modification logs. For more information, see Viewing Parameter Modification Log.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon