tencent cloud

Feedback

Managing TencentDB for SQL Server Instance

Last updated: 2024-11-13 20:24:03

    Instance List Page

    Log in to the TencentDB for SQL Server console, and enter the instance list page to view the instance information and manage your instances.
    
    Feature
    Description
    Restart
    In the instance list, select an instance and click Restart at the top to restart it. You can also select multiple instances for batch restart.
    The instance will be inaccessible during the restart, and existing connections to it will be closed.
    If the number of business writes is high during the restart, the restart will fail. In this case, the instance will go back to the state before the restart and become accessible.
    Restart the instance during off-peak hours to ensure success and minimize the impact on your business.
    Renew
    In the instance list, select one or more target instances, click Renew to renew them by month or year.
    Set Auto-Renewal
    In the instance list, select one or more target instances, and click More > Set Auto-Renewal to set monthly auto-renewal for them. After you click OK, the instances will be automatically renewed monthly upon expiration if your Tencent Cloud account balance is sufficient.
    Disable Auto-Renewal
    In the instance list, select one or more target instances marked with Renew before their name, click More > Disable Auto-Renewal, and click OK.
    Edit Tag
    You can click More > Edit Tag above the instance list or in the Operation column of an instance to manage its tags. If you haven't created a tag, you can click Tag Management to create one.
    Adjust Configuration
    In the instance list, you can adjust the configuration of your database instance. Both instance upgrade and disaster recovery mode adjustment are supported. For more information, see Overview.
    Publish/Subscribe
    In the instance list, you can select More > Publish/Subscribe in the Operation column of an instance to perform publish/subscribe to meet the data replication and sync requirements of your business.
    Termination/Return
    In the instance list, you can select More > Terminate/Return to terminate/return a database instance. For more information, see Terminating Instance.
    Switch to Monthly Subscription
    You can switch the instances from pay-as-you-go to monthly subscription. In the instance list, click More > Switch to Monthly Subscription in the Operation column, select renewal period, and click OK after reading the rules.
    Read-Only Instance
    In the instance list, you can click More > Read-Only Instance in the Operation column of an instance to view its read-only instances and configure the RO group. If there are no read-only instances, you can click Create after redirection to add one or more read-only instances.

    Instance Management Page

    Log in to the TencentDB for SQL Server console. In the instance list, click the instance ID or Manage in the Operation column to access the instance management page, where you can view its details, monitor it, and manage databases.
    
    Feature
    Description
    Instance Details
    On the Instance Detail tab, you can view and manage various information of your databases, including setting maintenance information and adding read-only instances in the instance architecture diagram.
    System Monitoring
    On the Instance Monitor tab, you can view the monitoring data of various core metrics of the current database. For more information, please see Monitoring Feature and Alarming Feature.
    Backup and Restoration
    On the Backup and Restoration tab, you can query the backup and restoration records and create a backup and restoration task. Supported backup upload methods include uploading file and downloading file from COS, and supported restoration modes include full backup file, full backups + logs, and full backups + differential backups.
    Publish/Subscribe
    On the Publish/Subscribe tab, you can create or delete one or more publish/subscribe linkage services. For details, see Publish-Subscribe.
    Security Group
    On the Security Group tab, you can configure security groups for your databases. For more information, see Configuring Security Group.
    Account Management
    On the Account Management tab, you can manage the administrator account, such as modifying permissions and resetting password. You can also create and delete accounts. For more information, see Creating Account.
    Database Management
    On the Database Management tab, you can create, delete, and set permissions of databases. For more information, see Database Management.
    Read-Only Instances
    On the Read-Only Instance tab, you can create one or more read-only (RO) instances, which can be applied to read/write separation and one-primary-multiple-replica application scenarios to boost the read load capacity of your databases. For more information, see Read-Only Instance Overview.
    Backup Management
    On the Backup and Restoration tab, you can manually create, download, and restore backups. You can also set scheduled backups, and perform rollbacks. For more information, see Backup Management.
    Operation Log
    On the Operation Log tab, you can download the slow logs, enable blocking and deadlock event collection, and query blocking and deadlock event records.
    Parameter Configuration
    On the Parameter Configuration tab, you can view and modify certain parameters and query the parameter modification logs. For more information, see Parameter Configuration.
    Data Security
    On the Data Security tab, you can enable transparent data encryption and set up encrypted databases, or enable SSL encryption. For details, see Transparent Data Encryption and Setting SSL Encryption.

    Instance Details Page

    In the instance list, click the instance ID or Manage in the Operation column to enter the instance management page, and then select the Instance Details page. On the Instance Details page, you can view and manage the instance information such as the instance architecture diagram, corresponding node addresses, storage and backup status, etc.
    Two-node Instance
    Single-Node Instance
    The Instance Details page of a two-node instance is shown below:
    
    Feature Area
    Illustration
    Feature
    Description
    Top information
    
    Renaming instances
    Instance names are primarily used to differentiate and manage SQL Server instances. For details, see Renaming Instance.
    
    Migrating across AZs
    Migrate the instance to another AZ within the same region. For details, see Migrating Across AZs.
    
    Switching to monthly subscription
    Switch the instance billing mode from pay-as-you-go to monthly subscription. For details, see From Pay-as-You-Go to Monthly Subscription.
    
    Renewal management
    Renew instances in the billing mode of monthly subscription. For details, see Renewal Instructions.
    
    Tag
    You can use the tags to perform classified management on the TencentDB for SQL Server resources. For details, see Setting Instance Tag.
    
    Switching to another project
    Assign instances to different projects for management. For details, seeSetting Instance Project.
    
    Instance remarks
    Set or modify the instance remarks for easier distinction and management of instances. For details, see Setting Instance Remarks.
    
    Maintenance cycle and time
    Set the maintenance cycle and maintenance time for the instance. For details, see Setting Instance Maintenance Information.
    Topology diagram (architecture diagram)
    
    Primary node read-write address
    You can hover the mouse over the primary node read-write address in the topology diagram to quickly view the private or public network address of the primary node. If the public network address is not enabled, you can click Enable. For details, see Enabling Public Network Address.
    
    Replica node read-only address
    If the replica node read-only feature is not enabled, you can click the + icon on the replica node read-only address in the topology diagram to enable it.
    If the replica node read-only feature is enabled, you can hover the mouse over the replica node read-only address in the topology diagram to quickly view the replica node read-only address. For details, see Replica Node Read-Only.
    
    Read-only group address
    If a read-only instance is created, the read-only group address section will be displayed. You can hover the mouse over the read-only group address in the topology diagram to quickly view the read-only group address and configure the read-only group. For details, see Read-Only Group.
    
    Primary node
    You can hover the mouse over the primary node in the topology diagram to quickly view the instance name and private or public network address of the primary node. If the public network address is not enabled, you can click Enable. For details, see Enabling Public Network Address.
    
    Replica node
    If the replica node read-only feature is not enabled, information will not be displayed when you hover the mouse over the replica node in the topology diagram. At this time, the replica node is used for disaster recovery purposes.
    If the replica node read-only feature is enabled, the read-only address of the replica node will be displayed when you hover the mouse over the replica node in the topology diagram. At this time, the replica node is used for read-only and disaster recovery purposes.
    No matter whether the replica node read-only feature is enabled, you can click the switching icon on the replica node to perform manual switching between primary and replica nodes. For details, see Manual Primary-Replica Switching.
    
    Read-only instance
    If a read-only instance has been created, the read-only instance section will be displayed. You can hover the mouse over the read-only instance in the topology diagram to quick view the private network address and public network address of the read-only instance. Click View Details to enter the corresponding read-only instance details page for viewing, or click the primary instance ID at the bottom right corner to return to the primary instance details page. You can also click the + icon on the read-only instance in the topology diagram to create a read-only instance.
    
    Primary node storage
    You can hover the mouse over the primary node storage in the topology diagram to view the storage space usage of the instance. The storage usage of the replica node is consistent with that of the primary node. Click Scale-out to enter the configuration adjustment page for setup.
    
    Read-only instance storage
    You can hover the mouse over the read-only instance storage in the topology diagram to view the storage space usage of the read-only instance. Click Scale-out to enter the configuration adjustment page for setup.
    
    Local backup
    You can hover the mouse over the local backup in the topology diagram to view the details of local backups, such as total backup, data backup, log backup, and actual occupied space/total free space quota.
    
    Cross-region backup
    If cross-region backup is not enabled, you can click the + icon on the cross-region backup in the topology diagram to enable it.
    If cross-region backup is enabled, you can hover the mouse over the cross-region backup in the topology diagram to view its detailed usage.
    
    
    
    Topology diagram view scale
    You can adjust the display scale of the topology diagram.
    Instance information (on the right side)
    
    Hiding/Showing instance information
    You can hide or show the instance information section.
    
    Primary node Information
    Under the primary node on the right side, you can view the private network address, public network address, network, configuration, instance status, edition, and architecture information of the primary node.
    
    Replica node information
    Under the replica node on the right side, you can enable the replica node read-only feature. Once enabled, you can view the replica node read-only address. You can also view the replica node information such as network, AZ, instance status, and primary-replica transmission mode.
    Operations that can be performed include enabling/disabling replica node read-only and changing network.
    
    Read-only instance information
    Under the read-only instance on the right side, you can view the read-only instance information such as private network address, public network address, network, instance status, AZ, edition, architecture, configuration, and weight.
    Operations that can be performed include switching to query information of other read-only instances,read-only group configuration, changing network, enabling public network address, and adjusting configuration.
    The Instance Details page of a single-node instance is shown below:
    
    Feature Area
    Illustration
    Feature
    Description
    Top information
    
    Renaming instances
    Instance names are primarily used to differentiate and manage SQL Server instances. For details, seeRenaming Instance.
    
    Migrating across AZs
    Migrate the instance to another AZ within the same region. For details, see Migrating Across AZs.
    
    Switching to monthly subscription
    Switch the instance billing mode from pay-as-you-go to monthly subscription. For details, see From Pay-as-You-Go to Monthly Subscription.
    
    Renewal management
    Renew instances in the billing mode of monthly subscription. For details, see Renewal Instructions.
    
    Tag
    You can use the tags to perform classified management on the TencentDB for SQL Server resources. For details, see Setting Instance Tag.
    
    Switching to another project
    Assign instances to different projects for management. For details, see Setting Instance Project.
    
    Instance remarks
    Set or modify instance remarks for easier distinction and management of instances. For details, see Setting Instance Remarks.
    
    Maintenance cycle and time
    Set the maintenance cycle and maintenance time for the instance. For details, see Setting Instance Maintenance Information.
    Topology diagram (architecture diagram)
    
    Primary node read-write address
    You can hover the mouse over the primary node read-write address in the topology diagram to quickly view the private or public network address of the primary node. If the public network address is not enabled, you can click Enable. For details, see Enabling Public Network Address.
    
    Primary node
    You can hover the mouse over the primary node in the topology diagram to quickly view the instance name and the private or public network address of the primary node. If the public network address is not enabled, you can click Enable. For details, seeEnabling Public Network Address.
    
    Primary node storage
    You can hover the mouse over the primary node storage in the topology diagram to view the storage space usage of the instance. Click Scale-out to enter the configuration adjustment page for setup.
    
    Local backup
    You can hover the mouse over the local backup in the topology diagram to view the details of local backups, such as total backup, data backup, log backup, and actual occupied space/total free space quota. Click Manage Backup to enter the backup space page for management. For details, see Viewing Backup Space.
    
    Cross-region backup
    If cross-region backup is not enabled, you can click the + icon on the cross-region backup in the topology diagram to enable it.
    If cross-region backup is enabled, you can hover the mouse over the cross-region backup in the topology diagram to view its detailed usage.
    
    Topology diagram view scale
    You can adjust the display scale of the topology diagram.
    Instance information (on the right side)
    
    Hiding/Showing instance information
    You can hide or show the instance information section.
    
    Primary node information
    Under the primary node on the right side, you can view the primary node information such as private network address, public network address, network, configuration, instance status, edition, and architecture.
    Operations that can be performed include changing network, enabling public network address, and adjusting configuration.
    Contact Us

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

    Technical Support

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

    7x24 Phone Support