Dear Tencent Cloud user,
To improve the experience of querying and downloading operational logs for TencentDB for SQL Server, Tencent Cloud will roll out an updated logging feature starting October 26, 2026 (UTC+8). This update optimizes three types of operational logs: slow query logs, blocking event logs, and deadlock event logs. Please review the details below.
Change Details
|
Log file generation policy | Generates one file per collection cycle (every 5 minutes) | Generates a new file each time log data reaches 10 MB |
Individual file size | Variable; determined by the volume of logs collected within each 5 minute cycle | Capped at a fixed maximum of 10 MB per file |
Time span per file | Fixed at 5 minutes | Variable; depends on the log generation rate |
Collection switch | Slow query logs: collection enabled by default; cannot be disabled Blocking and deadlock events: collection disabled by default; must be enabled manually | Slow query logs: unchanged (enabled by default; cannot be disabled) Blocking and deadlock events: changed to enabled by default; cannot be disabled |
Collection threshold | Slow query logs: default 1,000 ms; adjustable range 1,000 - 60,000 ms Blocking and deadlock events: default 1,000 ms; adjustable range 1,000 - 86,400,000 ms | Unchanged |
Log retention period | Default 7 days; logs are automatically deleted upon expiry | Unchanged |
Console path | Instance Management > Operation Log | Unchanged |
Time range search | Last 5 minutes, Last 15 minutes, Last 30 minutes, Last 1 hour, Last 3 hours, Last 24 hours, Today, Yesterday, Last 3 days, Last 7 days, Last 30 days, and Custom time range | Unchanged |
Log File Generation and Download Behavior After This Update
When accumulated log data reaches 10 MB, the system automatically rolls over and generates a new file. Files are available for download once their status changes to Completed.
Files that have not yet reached 10 MB are shown with the status Writing. If such a file already contains log records, you can click Download in the Operation Logs list on the console; the system will generate a downloadable file on demand without waiting for it to reach the 10 MB threshold.
If an instance has not generated any log data, no log file is created, and the download option is not available.
Impact Statement
Variable file time span: The time span of log files is no longer fixed at 5 minutes. On high-load instances, multiple files may be generated in rapid succession; on low-load instances, it may take considerably longer to produce a complete file. To view the latest logs, go to the Operation Logs page and click Download to export the current file in Writing status (available only when the file already contains log data).
Blocking and deadlock event collection is enabled automatically: For instances where collection was previously disabled, it will be turned on by default after the update, and the corresponding log files will start being generated. You can view them directly on the Operation Logs page in the console. For instances that already had collection enabled, existing threshold configurations remain unchanged. The collection switch can no longer be disabled; to reduce log volume, increase the collection threshold.
Log files generated before October 26, 2026 remain unchanged and continue to follow the 7-day retention policy, with automatic deletion upon expiry.
Effective Time and Scope
Effective time: Starting October 26, 2026 (UTC+8).
Scope: All TencentDB for SQL Server instances across all regions and all specifications.
Applicable versions: Slow query logs: supported on all database versions. Blocking and deadlock events: supported only on SQL Server 2012, 2014, 2016, 2017, 2019, 2022, and 2025 Enterprise editions (the SQL Server 2008 R2 Enterprise edition is not supported). The automatic enablement of the collection switch applies only to the editions listed above.
Related Documentation
If you have any questions, contact your Tencent Cloud solution architect or submit a ticket via the Tencent Cloud Ticket System. Thank you for your continued support of Tencent Cloud.