No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

OceanStor 2600 V3 Storage System V300R005 HyperMetro Feature Guide 06

"This document describes the implementation principles and application scenarios of theHyperMetro feature. Also, it explains how to configure and manage HyperMetro."
Rate and give feedback :
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
In the SQL Server database scenario, how can I adjust parameters to reduce the I/O latency and achieve the optimal performance?

In the SQL Server database scenario, how can I adjust parameters to reduce the I/O latency and achieve the optimal performance?

Question

In the SQL Server database scenario, how can I adjust parameters to reduce the I/O latency and achieve the optimal performance?

Answer

You can set target_recovery_time to 60 according to the SQL official suggestion. For details, seehttps://docs.microsoft.com/zh-cn/sql/relational-databases/logs/database-checkpoints-sql-server#IndirectChkpt.

Translation
Download
Updated: 2018-09-03

Document ID: EDOC1000106183

Views: 28414

Downloads: 271

Average rating:
This Document Applies to these Products
Related Documents
Related Version
Share
Previous Next