This document introduces query information and executable operations supported by the RDS console for SQL Server instances.
Log on to the instance management interface
- Log on to the RDS console.
- Select the region where the target instance is located.
- Click the ID of the target instance or Manage in the Operation column to enter the instance management interface.
Overview of the instance management interface
The following table lists the available information and actions that can be performed. The actual interface may vary slightly with the SQL Server version.
|Navigation pane||Block name||Description||Links of common operations|
|Operating area at the top||Allows you to migrate databases, restart, and back up an instance.|
|Basic Information||Basic Information||Allows you to view basic information about an instance. For example, the instance ID, region, and zone, instance type, intranet and Internet IP addresses, intranet and Internet ports, and perform migration across zones.||Instance migration across zones|
|Instance Distribution||Allows you to check the number of temporary instances under the master instance and add a temporary instance.|
|Operating Status||Allows you to view the running status, billing method, and creation time of an instance, release an instance, and renew a Subscription instance.|
|Configuration Information||Allows you to view the instance type, CPU, database type and version, database memory, and the maximum number of connections, and set the maintenance period.|
|Resource Information||Allows you to view the storage space and backup usage of an instance.|
|Account Management||Account List||Allows you to view all accounts under an instance, create common accounts, master accounts, or initial accounts, change account passwords, delete accounts, and modify account permissions.|
|Service Account Privileges||When an Alibaba Cloud engineer provides technical support, you must authorize the engineer’s service account to view or modify instance configurations and view the table structure, index, and SQL statements.||Authorize a service account|
|Database Management||Allows you to view the databases information under an instance, create, and delete a database.|
|Database Connection||Instance Connection||Allows you to view the network type, access mode, intranet and Internet IP addresses, intranet and Internet ports, and server name of an instance, change the network type, modify the connection address, and apply for and release an intranet/Internet IP address.|
|Monitoring and Alarms||Monitoring||Allows you to view monitoring information, such as the CPU and memory usage, disk space usage, and IOPS, and set the monitoring frequency.||Set monitoring frequency|
|Alarms||Allows you to view the status of monitoring items and cloud account alert contact, and set alarm rules.||Set alarm rules|
|Security Controls||Whitelist Settings||Allows you to view the whitelist of an instance, modify the whitelist, and add a whitelist group.||Set whitelist|
|SSL||Allows you to view an SSL certificate, set SSL, and download a certificate.||Set SSL encryption|
|TDE||Allows you to view the status of Transparent Data Encryption (TDE) and activate the TDE.||Set Transparent Data Encryption|
|Instance Availability||Availability Information||Allows you to view the instance zone type, instance availability, data replication mode, and number of master/slave databases, and switch over services between master and slave instances.||Switch master/slave instance|
|Zone Architecture Diagram||Allows you to view the structural diagrams of a single-zone instance or a multi-zone instance.|
|Log Management||Error Log||Allows you to view SQL statements that are incorrectly executed in the database within a month.||Log management|
|Slow SQL Log Summary||RDS collects SQL statements whose execution period exceeds one second in the database within a month and provides the analysis report for slow query logs, allowing you to download the statistics list.|
|Backup and Recovery||Backup List||Allows you to view the data backup list, and recover data to the master instance.|
|Temporary Instance||Allows you to create temporary instances.|
|Backup Settings||Allows you to view the backup policy, such as the data backup retention time, backup cycle, and backup time, and modify a backup policy.||Back up RDS data|
|Parameter Settings||Modifiable Parameters||Allows you to view the parameter values of an instance, modify the parameter values, and import and export the parameters.||Set parameters through RDS console|
|Modification History||Allows you to view parameter modification records.|