Information générale
Forum:
Microsoft SQL Server
>>Then how does MS get away with selling their SBS product? Exchange, SQL Server, Proxy Server, modem sharing, etc... all on one box. Licensed for up to 50 users...
>
>Microsoft can 'get away' with anything they want... when you go to implement it and have a multi gigabyte database with all 50 users hitting it at the same time and power email users who surf the internet continuously and download mpeg videos while people dial in to access the network, you will eventually have problems with this configuration. I have worked with Microsoft on a problem with a box where SQL and Exchange were running together - the only solution was to separate them.
>
>I'm not talking about an environment where you have a 100mb database and 10 users - sure that will probably be Ok. But you should not design your network like this if you have any intentions of growing. The first accounting person that runs a query against the server for some weired data requested by auditors will cause the server performance to degrade.
>
>The scenario given for this post indicated that IIS and SQL Server were having problems because of one or the other being overloaded. I don't know exactly what the problem was, but it was obvious that something was causing them to fight over resources. The best solution is to separate them. I know you can work on the systems to improve performance, but eventually you will end up back at this problem when the use of the system increases.
>
>Since you don't have any control over the OS and the server systems, putting them on separate boxes allows you take any of the unknowns out of the mix.
Oh, no argument from me. Separate boxes are the easier route. Just wanted to hear your take on THAT configuration. BTW, the MS SBS support newsgroup is a very busy place - as you can imagine.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement