Results 1 to 3 of 3

Thread: Scheduled Maintenance on our Windows Servers

  1. #1

    Scheduled Maintenance on our Windows Servers

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

    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.


    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.

    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.

    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.

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

    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.

    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.

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

    Maintenance Schedule:

    1. Database Server Name
    BHIN-PP-MSSQL1.webhostbox.net

    Web Servers
    BHIN-PP-WB1
    BHIN-PP-WB2
    BHIN-PP-WB3

    Start Time: 05/Dec/18 8:00 PM
    End Time: : 06/Dec/18 1:00 AM

    ==

    2.Database Server Name
    BHUK-PP-MSSQL1.webhostbox.net

    Web Servers
    BHUK-PP-WB1

    Start Time: 06/Dec/18 8:00 PM
    End Time: 07/Dec/18 1:00 AM

    ==

    3.Database Server Name
    MDHK-PP-MSSQL1.webhostbox.net

    Web Servers
    MDHK-PP-WB1
    MDHK-PP-WB2
    MDHK-PP-WB3

    Start Time: 07/Dec/18 8:00 PM
    End Time: 08/Dec/18 1:00 AM

    ==

    4.Database Server Name
    DD-Plesk-MSSQL1.webhostbox.net

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

    Start Time: 10/Dec/18 8:00 PM
    End Time: 11/Dec/18 1:00 AM

    ==

    5.Database Server Name
    MSSQL-PK-1.webhostbox.net

    Web Servers
    BHUS-PP-WB9
    MDUS-PP-WB12
    MDUS-PP-WB13

    Start Time: 11/Dec/18 8:00 PM
    End Time: 12/Dec/18 1:00 AM

    ==

    6.Database Server Name
    MDIN-PP-MSSQL1.webhostbox.net

    Web Servers
    MDIN-PP-WB1
    MDIN-PP-WB2
    MDIN-PP-WB3
    MDIN-PP-WB4

    Start Time: 12/Dec/18 8:00 PM
    End Time: 13/Dec/18 1:00 AM

    ==

    7.Database Server Name
    MDUK-PP-MSSQL1.webhostbox.net

    Web Servers
    MDUK-PP-WB1

    Start Time: 13/Dec/18 8:00 PM
    End Time: 14/Dec/18 1:00 AM

    ==

    8.Database Server Name
    SDHK-PP-MSSQL1.webhostbox.net

    Web Servers
    SDHK-PP-WB1


    Start Time:
    14/Dec/18 8:00 PM
    End Time: 15/Dec/18 1:00 AM

    ==


    9.Database Server Name
    BH-Plesk-MSSQL1.webhostbox.net

    Web Servers
    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 8:00 PM
    End Time: 19/Dec/18 1:00 AM

    Affected Services:

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


    Please feel free to contact our Support Team in case you have any queries.
    Sonu Singh
    HostGator India

  2. #2
    Update : Due to unforeseen reasons we have to extend the maintenance of BH-Plesk-MSSQL1.webhostbox.net for 1 more hour.

    We appreciate your patience.

    Please feel free to contact our Support Team in case you have any queries.
    Ashish Shetty
    HostGator India

  3. #3
    Update: Maintenance of server BH-Plesk-MSSQL1.webhostbox.net is completed.
    Ashish Shetty
    HostGator India

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •