locked
SQL Server Consolidation RRS feed

  • Question

  • Hi Experts,

    I want to consolidate 7 SQL Servers to ONE.Below are the details of servers:
    1) MSSQL 2005 E  >> 35 GB total DB size >> 23 Databases hosted >> Physical
    2) MS SQL  2000 E >> 1 GB total DB Size >> 2 Databases hosted >> Virtual
    3) MS SQL  2005 E >> 58 GB total DB size >> 6 Databases hosted >> Virtual
    4) MS SQL 2008 R2 SE >> 6 GB total DB size >> 1 Database hosted >> Virtual
    5) MS SQL  2005 E >> 55 GB total DB Size >> 2 Databases hosted >> Physical
    6) MS SQL  2008 SE >> 200 GB total DB Size >> 3 Databases hosted >> Virtual
    7) MS SQL  2005 E >> 6 GB total DB Size >> 8 Databases hosted >> Virtual

    I want to know in process of consolidation 

    a) which strategy should I follow with minimal downtime?
    b) What is best consolidation planning for this environment?
    c) how to figure out the hardware requirement to avoid performance issue?
    d) for which things I should care most?
    e) anymore suggestion which i can go through with.

    I will be very grateful to all DBAs....

    Thanks in Advance
    Yashwant
    SQLOcean.com


    Thanks & Regards, Yashwant Vishwakarma, SQLOcean.com

    Monday, March 16, 2015 12:53 PM

Answers

  • Hello,

    I am sorry for my delay to answer.


    No, you cannot migrate to Windows Azure just like that.

    • (1)   You may have to change the architecture of your applications to a Web application, including the user interface.
    • (2)   Normal Ethernet switches may add latency to your process and you may have to consider upgrading to Ethernet Fabrics.
    • (3)   Communication between clients and servers should be asynchronous.
    • (4)   Your applications may need to be modified to incorporate one or more of the following strategies: caching, pre-loading of data, data compression, reduce the size of requests.
    • (5)   If your applications rely on an Active Directory structure in your organization, you may have use one of the following to keep your applications connected to domain controllers on your organization: Azure Connect, AD Replication, AD FS, active directory via service bus.
    • (6)   They way your application work with printing may have to change.

    For more information, please consider the following document.

    https://msdn.microsoft.com/en-us/library/ff728592.aspx?f=255&MSPPError=-2147217396
     

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com





    Tuesday, March 17, 2015 8:37 PM

All replies

  • Monday, March 16, 2015 1:50 PM
  • Hi Alberto,

    I will take look on the links provided by you.

    Regards,
    Yashwant
    SQLOcean.com


    Thanks & Regards, Yashwant Vishwakarma, SQLOcean.com

    Tuesday, March 17, 2015 4:31 AM
  • Hi Alberto,

    is it possible for us to consolidate all SQL instances to Azure without affecting Applications & users with minimum downtime or complexity??

    will it reduce the licensing cost for us if we can do so??

    Regards,
    Yashwant
    SQLOcean.com


    Thanks & Regards, Yashwant Vishwakarma, SQLOcean.com

    Tuesday, March 17, 2015 8:36 AM
  • Hi Alberto,

    is it possible for us to consolidate all SQL instances to Azure without affecting Applications & users with minimum downtime or complexity??

    will it reduce the licensing cost for us if we can do so??

    Regards,
    Yashwant
    SQLOcean.com


    Thanks & Regards, Yashwant Vishwakarma, SQLOcean.com

    Tuesday, March 17, 2015 8:37 AM
  • Hi Alberto,

    is it possible for us to consolidate all SQL instances to Azure without affecting Applications & users with minimum downtime or complexity??

    will it reduce the licensing cost for us if we can do so??

    Regards,
    Yashwant
    SQLOcean.com


    Thanks & Regards, Yashwant Vishwakarma, SQLOcean.com



    Thanks & Regards, Yashwant Vishwakarma, SQLOcean.com

    Tuesday, March 17, 2015 8:37 AM
  • Hello,

    I am sorry for my delay to answer.


    No, you cannot migrate to Windows Azure just like that.

    • (1)   You may have to change the architecture of your applications to a Web application, including the user interface.
    • (2)   Normal Ethernet switches may add latency to your process and you may have to consider upgrading to Ethernet Fabrics.
    • (3)   Communication between clients and servers should be asynchronous.
    • (4)   Your applications may need to be modified to incorporate one or more of the following strategies: caching, pre-loading of data, data compression, reduce the size of requests.
    • (5)   If your applications rely on an Active Directory structure in your organization, you may have use one of the following to keep your applications connected to domain controllers on your organization: Azure Connect, AD Replication, AD FS, active directory via service bus.
    • (6)   They way your application work with printing may have to change.

    For more information, please consider the following document.

    https://msdn.microsoft.com/en-us/library/ff728592.aspx?f=255&MSPPError=-2147217396
     

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com





    Tuesday, March 17, 2015 8:37 PM
  • Not so easy Yashwant,

    1) ensure sql collation is the same otherwise you will get sql collation problems.

    2) sometimes tables use page compression turned on with enterprise edition - standard edition don't have this feature. so can't consolidate.

    Woon

    Wednesday, March 18, 2015 1:59 AM
  • Hi Woon,

    Thanks !!!

    I will consider your suggestions when implementing the things.

    Regards,
    Yashwant
    SQLOcean.com


    Thanks & Regards, Yashwant Vishwakarma, SQLOcean.com

    Wednesday, March 18, 2015 4:48 AM