RSS种子
新闻
Dec
3
Windows服务器定期维护通知 | Scheduled maintenance on our windows servers
发布人 John Hao 发表于 03 December 2018 03:37 PM

Maintenance Notice:

维护通知:

We are excited to announce that we will be upgrading MSSQL from SQL 2012 to SQL 2016.

我们很高兴的宣布,我们将把MSSQL从SQL2012升级到SQL2016。

Reason :

原因:

Upgrade MSSQL Version from SQL 2012 to SQL 2016. This will help us to improve the performance, enable new features and enhance the security of the server.

MSSQL从SQL2012升级到SQL2016可以提高服务器性能,增加新特性并且提升服务器的安全性。

The new features available are :

 

新特性如下: 

1.Query Store: The Query Store feature maintains a history of query execution plans with their performance data, and quickly identifies queries that have gotten slower recently, allowing administrators or developers to force the use of an older, better plan if needed.

1.Query Store:Query Store会保留之前执行查询的性能数据,并且快速识别最近变慢的查询,允许管理员或者开发人员在必要时强制使用较旧但是更好的计划。

2.Polybase: This feature will benefit you if your regular data processing involves dealing with a lot of large text files -- they can be stored in Azure Blob Storage or Hadoop, and queried as if they were database tables.

2.Polybase:如果您常规数据处理涉及到大量大型文本文件,那么这个功能对您有极大的帮助——文本文件将被存放在Azure Blob Storage 或者Hadoop中,并且可以像数据库表一样被查询。

3.Stretch Database: The basics of Stretch Database are that some part of your tables (configurable or automated) will be moved into an Azure SQL Database in the cloud in a secure fashion. When you query those tables, the query optimizer knows which rows are on your server and which rows are in Azure, and divides the workload accordingly.

3.Stretch Database:部分数据库表将被安全转移到云上的Azure SQL Database中。当你要查询数据库表时,查询优化器会识别出哪些行在服务器上,哪些行在Azure中,并进行相应的分工。

4.JSON Support: Providing the ability to quickly move JSON data into tables

4.JSON support:提供了将JSON数据快速转移到数据库表中的功能。

5.Row Level Security: This restricts which users can view what data in a table, based on a function. SQL Server 2016 introduces this feature, which is very useful in multi-tenant environments where you may want to limit data access based on customer ID.

5.Row Level Security:限制了特定用户只能访问数据库表中特定的数据,SQL Server 2016中引入的这个功能在多用户环境中非常有用,可以根据客户ID来限制数据访问。

6.Always Encrypted: Always Encrypted is new functionality through the use of an enhanced client library at the application so the data stays encrypted in transit, at rest and while it is alive in the database.

6.Always Encrypted:通过在应用程序中使用增强型客户端来实现数据在传输、静止以及在数据库中处于活跃状态时始终保持加密状态。

7.In-Memory Enhancements: Optimally designed for high-speed loading of data with no locking issues or high-volume session state issues.

7.In-Memory Enhancements:高速加载数据而不出现锁定或者大容量会话状态的问题。

 

维护列表:

Database Server Name

数据库服务器名称

Web Servers

Web服务器

Start & End time (BJ)

开始&结束时间(北京时间)

 

BHIN-PP-MSSQL1.webhostbox.net

BHIN-PP-WB1 
BHIN-PP-WB2 
BHIN-PP-WB3

Start Time: 05/Dec/18 10:300 PM
End Time: 06/Dec/18 3:30 AM

BHUK-PP-MSSQL1.webhostbox.net 

 BHUK-PP-WB1

Start Time: 06/Dec/18 10:30 PM 
End Time: 07/Dec/18 3:30 AM 

 

MDHK-PP-MSSQL1.webhostbox.net

MDHK-PP-WB1 
MDHK-PP-WB2 
MDHK-PP-WB3

Start Time: 07/Dec/18 10:30 PM 
End Time: 08/Dec/18 3:30 AM 

 

DD-Plesk-MSSQL1.webhostbox.net

 DD-Plesk-Web1 
DDBH-Plesk-Web1 
DDMD-Plesk-Web1 
DDMDUS-PP-WB2

 Start Time: 10/Dec/18 10:30 PM 
End Time: 11/Dec/18 3:30 AM

 

MSSQL-PK-1.webhostbox.net

BHUS-PP-WB9 
MDUS-PP-WB12 
MDUS-PP-WB13

 Start Time: 11/Dec/18 10:30 PM 
End Time: 12/Dec/18 3:30 AM

 

MDIN-PP-MSSQL1.webhostbox.net

 MDIN-PP-WB1 
MDIN-PP-WB2 
MDIN-PP-WB3 
MDIN-PP-WB4

 Start Time: 12/Dec/18 10:30 PM 
End Time: 13/Dec/18 3:30 AM

 MDUK-PP-MSSQL1.webhostbox.net

 MDUK-PP-WB1

Start Time: 13/Dec/18 10:30 PM 
End Time: 14/Dec/18 3:30 AM

 

SDHK-PP-MSSQL1.webhostbox.net

 SDHK-PP-WB1

 Start Time: 14/Dec/18 10:30 PM 
End Time: 15/Dec/18 3:30 AM

 

 

 

 

BH-Plesk-MSSQL1.webhostbox.net

 BH-Plesk-Web1 
BH-Plesk-Web2 
BH-Plesk-Web3 
BH-Plesk-Web4 
BH-Plesk-Web5 
BH-Plesk-Web6 
BHUS-PP-Web7 
BHUS-PP-Web8 
BHUS-PP-Web10

 Start Time: 18/Dec/18 10:30 PM 
End Time: 19/Dec/18 3:30 AM

 

Affected Services: 

受影响的服务:

Websites using MSSQL databases will be down during the maintenance window. No other services will be affected.

使用MSSQL数据库的网站在维护过程中会暂时无法访问,其他服务不受影响。

Please feel free to contact our Support Team in case you have any queries.

如有任何疑问,请随时联系我们的支持团队。


相关评论 (0)
发表新的评论
 
 
用户全名:
电子邮件:
评论内容: