我的客户有资源密集型的MSSQL数据库。 eUKhost服务器会支持吗？

Microsoft SQL Server is an enterprise-class database hosting platform constructed around SQL (Structured Query Language) for use with the range of Microsoft server products, such as Microsoft Exchange Server and ASP.NET websites. Unlike Microsoft’s other database product, Access, which is part of the Office suite of products, MSSQL is a highly scalable platform that can be utilised in even the most demanding of situations. Whilst Access is restricted to a single file on a single server, businesses have the option to build up their own cluster of Microsoft SQL servers so that in situations where a lot of power is required for the hosting of a database, multiple servers can be used to provide the resources that are needed as well as to add redundancy. When used in conjunction with a web scripting language such as ASP.NET, web developers have a powerful platform on which they can create dynamic websites that have the ability to serve millions of visitors without issue.

Microsoft SQL Server是围绕SQL( 结构化查询语言 )构建的企业级数据库托管平台，可与一系列Microsoft服务器产品一起使用，例如Microsoft Exchange Server和ASP.NET网站。 与Microsoft的其他数据库产品Access(属于Office产品套件的一部分)不同，MSSQL是一个高度可扩展的平台，即使在最苛刻的情况下也可以使用。 虽然访问仅限于单个服务器上的单个文件，但是企业可以选择建立自己的Microsoft SQL服务器群集，以便在托管数据库需要大量功能的情况下，可以使用多个服务器提供所需的资源以及增加冗余。 与ASP.NET之类的Web脚本语言结合使用时，Web开发人员将拥有一个强大的平台，他们可以在该平台上创建动态网站，该网站能够为数百万的访客提供服务而不会出现问题。

Resource usage The amount of resources that an MSSQL database is going to be using will be reliant on the size of the database and the frequency at which it is accessed. Estimating the resources needed to power a database can prove to be impossible when it is hard to calculate demand, but based on data collected during the testing phase of a project it is possible to roughly gauge the stress that a database is going to place on a server. Initially a single Windows dedicated server should be appropriate for the hosting of a new website and its MSSQL database.

资源使用情况 MSSQL数据库将要使用的资源量将取决于数据库的大小和访问它的频率。 在难以计算需求的情况下，无法估算为数据库提供动力所需的资源，但是根据项目测试阶段收集的数据，可以粗略估算出数据库将承受的压力。服务器。 最初，单个Windows专用服务器应适合于托管新网站及其MSSQL数据库。

MSSQL Server clusters eUKhost offers a range of dedicated servers that provide different resource allocations, allowing you to start off with a server that you believe will be fitting to your requirements. Whilst it is recommended that you choose a Windows dedicated server with additional resource to allow for room for scaling and load spikes, if you have a restricted budget to begin with then choosing something that fits your basic requirements shouldn’t be detrimental to the functionality of your web application. As the popularity of your web application increases, so will the load placed on your MSSQL database. It is at this stage that you may want to consider adding additional servers to form an MSSQL cluster. MSSQL hosting is also available in the eNlight Cloud with the use of Windows Cloud servers; with eNlight the scalability of your hosting environment is unlimited, although if you wish to create a distributed cluster within the Cloud then this is possible with Cloud vLANs as eNlight provides IaaS (Infrastructure as a Service).

MSSQL Server群集 eUKhost提供了一系列专用服务器，这些服务器提供了不同的资源分配，使您可以从一台认为自己可以满足要求的服务器开始。 虽然建议您选择带有附加资源的Windows专用服务器，以便为扩展和负载峰值留出空间，但是如果您的预算有限，那么选择适合您基本要求的内容不会对功能造成不利影响。您的Web应用程序。 随着Web应用程序的普及，MSSQL数据库上的负载也将增加。 在此阶段，您可能需要考虑添加其他服务器以形成MSSQL群集。 通过使用Windows Cloud服务器，eNlight Cloud中也可以使用MSSQL托管。 使用eNlight，托管环境的可扩展性是无限的，尽管如果您希望在Cloud内创建分布式集群，则可以通过Cloud vLAN来实现，因为eNlight提供了IaaS(基础设施即服务)。

Conclusion Any Cloud server or dedicated server from eUKhost is capable of supporting Microsoft SQL databases, so long as the Windows operating system is used. Whether a server is able to cope with the load a database places on it is going to depend on the database in question and the specifications of your chosen server. You should ensure that you fully evaluate your needs beforehand so that you are able to choose a server that you can be confident will be able to support your website.

结束语只要使用Windows操作系统，eUKhost的任何Cloud服务器或专用服务器都能够支持Microsoft SQL数据库。 服务器是否能够应付数据库所承受的负载将取决于所讨论的数据库以及所选服务器的规格。 您应该确保事先充分评估您的需求，以便能够选择可以确信能够支持您的网站的服务器。

翻译自: https://www.eukhost.com/blog/webhosting/my-customer-has-resource-intensive-mssql-databases-will-eukhost-servers-support-this/