Performance FAQs

Last updated: 2019-10-25 12:20:15

PDF

What are the strengths of TencentDB for SQL Server?

  • 70% off for 3-year Commitments
    We cover Microsoft product license fees for your TencentDB for SQL Server instances, so you no longer need to purchase your own licenses. Your money is saved and you only need to pay as you go. Additionally, we give 70% discount for 3-year terms to reduce your Cloud cost.
  • Instant usage and on-demand upgrade
    You can customize TencentDB for SQL Server specifications on the Tencent Cloud console. After the order is placed, TencentDB for SQL Server can generate target instances in real time to avoid self-building SQL Server clusters to save time and effort. You can go for lower specifications to handle business needs at the startup stage. You can adjust instance specifications as database pressure and data volume change. Data link service will not be interrupted during upgrade.
  • Sophisticated, reliable, and high-availability architecture
    The one-master-one-mirror configuration is provided by default which can switch from a faulty instance to a healthy one in a matter of seconds, ensuring business continuity.
  • Quick data rewinding for easy rollback
    Automatic backup enables data roll back to any point in time within the past 7 days.

Where can TencentDB for SQL Server be used?

  • Cloud-based business system
    When you build a business system directly in the cloud, TencentDB for SQL Server can be used as the basic database, which not only provides a stable and high-performance database support solution, but also effectively improves the performance of the business system.
  • Remote (in-cloud) data disaster recovery
    Electronic data is the core asset of every company. Data loss by force majeure and man-made mistakes can have serious consequences. However, remote disaster recovery from self-building remote IDC is not cost-effective. Using TencentDB as a remote database for disaster recovery is a good solution.
    With Direct Connect, VPN and database synchronization tools, companies can sync data from self-built data centers or other cloud vendors to TencentDB for SQL Server in real time. Even if the data in the self-built data centers is completely lost, data will still be securely stored in TencentDB.
  • Mobile office
    TencentDB for SQL Sever supports quick deployment of your mobile office platforms such as OA, ERP and sales management. Data is stored in Tencent Cloud's secure subnets and the database is protected by multiple measures for security and reliability.
  • Data warehouse and data analytics platform
    TencentDB for SQL Sever helps you create a cloud-based data warehouse and data analytics platform with SQL Server's built-in business intelligence, IT dashboards and collaboration with SharePoint.
  • Business Elasticity
    Business promotion and major events result in high peaks, and self-built data centers are usually not optimized for cost considerations. In contrast, Cloud is scalable and an elastic IDC can be built in the cloud data center to be scaled at any time. With CVM and TencentDB for SQL Server, elastic business needs can be met.

What versions does TencentDB for SQL Server support?

  • Microsoft SQL Server 2008 R2 SP3
  • Microsoft SQL Server 2012 SP3
  • Microsoft SQL Server 2016 SP1

What are the usage limitations of TencentDB for SQL Server?

  • TencentDB for SQL Server do not allow the creation/deletion of databases and creating/deleting/modifying accounts via Microsoft SQL Server Management. If needed, please log in to the TencentDB for SQL Server Console to do so.
    When you try to manage databases in Microsoft SQL Server Management, the system may prompt "An exception occurred while executing a Transact-SQL statement or batch processing".
  • Tencent Cloud prohibits the sysadmin role. If you need to use this role, please submit a ticket.
    When you try to manage databases in Microsoft SQL Server Management, the system may prompt "You must be a member of the sysadmin role to perform this operation".
  • The use of SQL Server agent is supported.

In which regions and AZs can TencentDB for SQL Server be used?

Tencent Cloud currently offers a number of available regions: East China (Shanghai), South China (Guangzhou), South China (Hong Kong), and North America. For more information, see Regions and AZs.