Post reply

HELP URgENT: Can you install sql on application server

  • September 3, 2010 at 9:17 am

    #223448

    Please help= Can you install sql on application server? is it safe to have the database on application server? what will be the pros and cons?

  • September 3, 2010 at 9:25 am

    #1216237

    run the msi and click next five or six times....

    seriously, an "application" server is just another server that is being used for a specific purpose.

    you would have to decide if the SQL instance you are planning on installing will overwhelm the servers resources, depending on whether you set SQL server min/max settings, and just how utilized the SQL server isntance would be.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • September 3, 2010 at 9:25 am

    #1216238

    If the app server is a windows based server then you will be able too.

    Safety of it depends on how you configure the security.

    The pros are you will have to buy one less server.

    The cons are that SQL server can hog resources and it will be competing directly with your app server. Also it does not give you any scope to have failover.

  • September 3, 2010 at 9:37 am

    #1216244

    What's the "app" on the app server?

    In addition to what's noted above, I'd be sure you set the max memory that SQL will use so that it doesn't starve the application.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply