Details about this thread
  • State Not Answered
  • Replies 1 reply
  • Subscribers 322 subscribers
  • Views 85 views
  • Users 0 members are here
Related content from around SugarClub

On prem on MS Servers

Michael Huss
I do have a question about a procurement that involves a big chance for us with Sugar. It is a 2 million euro procurement and we have faced an issue since we only have experience in Linux/red hat. 
The requirement is that they want either Microsoft Server 2022 or as a second priority they can accept Red Hat. but they only accept Microsoft SQL servers.
My question is since we have low experience and competence in MS, is this possible to meet? Are there disadvantages connected to it? do anyone have experience in such solutions ?
Greatful for answers with someone with experience. Sugar claims that it is supported, but not how efficient it is. 
Michael Huss
Exsitec AB, Sweden
Parents
  • 0 Sugar Employee Badge

    It is certainly possible to deploy on MS technologies and obtain equivalent performance to that of LAMP implementations. However, it is important to stress that this requires a support team that has expertise with MS.

    Perhaps the most common issue that I have seen over the years is that of folks mixing technologies to host the various stack components. That is, they will host the web portion on Linux (Apache), while the database is hosted on MS-SQL. If you need to use MS-SQL, you must also use IIS for the web layer, which effectively means you will also be using Windows Server for your web layer. Any other combo is not recommended, nor supported, and will very likely lead to performance problems. Note that we also do not test such mixed configurations and cannot comment on potential oddities that may surface should one insist on using them.

    This brings me to my other observation....you'll need someone that is versed in tuning MS-SQL and IIS. WinCache is the equivalent to Opcache that one would use on IIS, but I believe you'll need to compile your own version for PHP 8.x, which requires some careful planning as well. 

    You should also be mindful that while properly tuning MS-SQL will take you a long way, I have encountered some queries in the past which cannot be fully optimized (at least not without touching core code). Usually they involve a translation or casting, such as querying a numeric value with a string value, i.e. deleted = '1' instead of deleted = 1. These are minor matters, but may trigger someone's curiosity at scale.

    I hope that helps. Let me know if you have any other questions.

Reply
  • 0 Sugar Employee Badge

    It is certainly possible to deploy on MS technologies and obtain equivalent performance to that of LAMP implementations. However, it is important to stress that this requires a support team that has expertise with MS.

    Perhaps the most common issue that I have seen over the years is that of folks mixing technologies to host the various stack components. That is, they will host the web portion on Linux (Apache), while the database is hosted on MS-SQL. If you need to use MS-SQL, you must also use IIS for the web layer, which effectively means you will also be using Windows Server for your web layer. Any other combo is not recommended, nor supported, and will very likely lead to performance problems. Note that we also do not test such mixed configurations and cannot comment on potential oddities that may surface should one insist on using them.

    This brings me to my other observation....you'll need someone that is versed in tuning MS-SQL and IIS. WinCache is the equivalent to Opcache that one would use on IIS, but I believe you'll need to compile your own version for PHP 8.x, which requires some careful planning as well. 

    You should also be mindful that while properly tuning MS-SQL will take you a long way, I have encountered some queries in the past which cannot be fully optimized (at least not without touching core code). Usually they involve a translation or casting, such as querying a numeric value with a string value, i.e. deleted = '1' instead of deleted = 1. These are minor matters, but may trigger someone's curiosity at scale.

    I hope that helps. Let me know if you have any other questions.

Children
No Data