![]() ![]() When your SQL Server instance runs on ECS that has more than one processor, it detects the best degree of parallelism, that is, the number of processors employed to run a single statement, for each parallel plan execution. We recommend you to configure the max degree of parallelism option to 8. If you want to choose Alibaba RDS for SQL server, please refer to Quick Start for SQL Server. It also presents a simplistic procedure to guide you for running your Microsoft SQL server. Please be aware this article used SQL server 2016 Enterprise Edition as the example, so not every option is appropriate for every version. This article provides you with the best practice for Microsoft SQL Server instance running on ECS instance. To learn what is ECS, please refer to the detail. ![]() ![]() It gives you complete control over every setting. Microsoft SQL server on Alibaba cloud Elastic Compute Service(ECS) just like when you installed on-premises, you are responsible for installation, administering the database, including backups and recovery, patching the operating system and the database, tuning of the operating system and database parameters, managing security, and configuring high availability or replication. Make use of Alibaba Cloud reliable and flexible cloud computing infrastructure and platform services can help you to run Microsoft SQL Server more stably and smoothly. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |