How to use SQL Server Always on technology

Source: Internet
Author: User
Tags how to use sql server how to use sql

Using SQL Server Always on technology, if the configuration is the default configuration, there will be a high primary server CPU, such as the default configuration is as follows:

Customization is needed to solve this problem.

Let's take a look at the meaning of these options in the above figure

Connections in the main role

Allow all connections

Primary instance allows all connections (such as read/write/admin) if the current server is the primary role

Allow read/write connections

If the current server is the primary role, primary instance only allow read/write connections (if the connection is through SSMS, the error will be an error, and SQLCMD is also a report)

Readable auxiliary Copy

Is

If the current server is a primary role, all secondary servers are visible (through SSMs can look at the structure, data, but not change)

Read Only Intent

If the current server is the primary role, all secondary servers only allow read connections (you need to add a key when establishing a connection to indicate a read-only connection: applicationintent=readonly)

Whether

If the current server is the primary role, all secondary servers can not see (through the SSMs can connect, but can't see, will error, such as the following)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.