Results 1 to 9 of 9
  1. #1
    Join Date
    Oct 2003
    Location
    Hanoi
    Posts
    4,306

    MS SQL server on the same box with webserver

    Is there any idea about putting MS SQL Server Workgroup Edition on the same box with webserver? The box is P4 2.8 (w/HT), 1GB RAM, SATA HDD, running Windows 2003 server web edition and Helm. The current CPU usage is not much: 1% - 10%

    thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Tampa FL
    Posts
    2,378
    Should be ok as long as you keep an eye on the load.
    Ceridius Networks Sales
    Email/MSN [email protected]
    Ceridius Networks - Reseller of Hivelocity Hosting
    Network Speed Test

  3. #3
    Join Date
    Apr 2001
    Posts
    542
    You can't run SQL Server on Windows Web Edition.  It's a licensing restriction
    (and actively enforced by the installer).

    If you upgrade to Standard Edition you can easily run both SQL Server and IIS on the same box.
    Voicegateway.com Web Services - High-performance Hosting & Fully Managed Servers
    Specializing in Virtual Machine Hosting with Microsoft Virtual Server 2005 R2, Windows SharePoint Services, Microsoft SQL Server 2005, ASP.NET 2.0 hosting and Newsletter/Mailing list services

  4. #4
    Join Date
    Dec 2004
    Location
    Butler,TN
    Posts
    2,413
    Hi!
    This is one of the reasons that Windows Web Edition is so inexpensive compared to it's sisters/brothers in the family.

    That's why it is critical to understand the differences and limitations in the OS before spending dime one...to at least, at the start, have a pretty good idea on what you're going to put on a server and what you are going to use it for.

    This is another reason I recommend people starting out with VPSs..and not dedicated servers...before they fully understand what they're going to do with it.

    This is a nice comparision between the editions:

    http://www.microsoft.com/windowsserv...eeditions.mspx


    Bryon
    Last edited by bryonhost1; 07-16-2005 at 11:58 AM.

  5. #5
    Join Date
    Oct 2003
    Location
    Hanoi
    Posts
    4,306
    Bryon, I think our techs can understand what the server is thanks anyway

    thanks for ideas, Spiv and HiVelocity.

  6. #6
    Join Date
    Apr 2001
    Posts
    542
    You can run MSDE on Windows 2003 Web Edition and that might be sufficient for your needs for a while - that's another option.
    Voicegateway.com Web Services - High-performance Hosting & Fully Managed Servers
    Specializing in Virtual Machine Hosting with Microsoft Virtual Server 2005 R2, Windows SharePoint Services, Microsoft SQL Server 2005, ASP.NET 2.0 hosting and Newsletter/Mailing list services

  7. #7
    Join Date
    Apr 2001
    Posts
    542
    Actually, the price difference (SPLA pricing anyway) between Web Edition and Standard Edition is not very much at all.

     

    Originally posted by bryonhost1
    Hi!
    This is one of the reasons that Windows Web Edition is so inexpensive compared to it's sisters/brothers in the family.....
    Bryon
    Voicegateway.com Web Services - High-performance Hosting & Fully Managed Servers
    Specializing in Virtual Machine Hosting with Microsoft Virtual Server 2005 R2, Windows SharePoint Services, Microsoft SQL Server 2005, ASP.NET 2.0 hosting and Newsletter/Mailing list services

  8. #8
    Join Date
    Oct 2003
    Location
    Hanoi
    Posts
    4,306
    Originally posted by spiv
    You can run MSDE on Windows 2003 Web Edition and that might be sufficient for your needs for a while - that's another option.
    I have thought about it, but read somewhere that if you run it with very small DB, it should be ok, but if you are using more than 100MB, the SQL queries will run very slow. Not sure if it's true or not

  9. #9
    Join Date
    Apr 2001
    Posts
    542
    There is a limitation of 2GB database and max simultaneous query threads.  The short answer is the only way you will know is to try it yourself.  Just about every Microsoft product that needs SQL Server will often come with a bundled copy of MSDE to avoid deploying a dedicated SQL server - at least for initial testing and evaluation.

    Microsoft would not widely use MSDE with it's own products if there were severe limitations - it is not, afterall, Access/Jet engine but a derivation of SQL server with just a few limitations.

     

    Originally posted by gate2vn
    I have thought about it, but read somewhere that if you run it with very small DB, it should be ok, but if you are using more than 100MB, the SQL queries will run very slow. Not sure if it's true or not
    Voicegateway.com Web Services - High-performance Hosting & Fully Managed Servers
    Specializing in Virtual Machine Hosting with Microsoft Virtual Server 2005 R2, Windows SharePoint Services, Microsoft SQL Server 2005, ASP.NET 2.0 hosting and Newsletter/Mailing list services

Posting Permissions

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