Is it ok for SQL Server 2008 Express to run on a shared file server or should it have a dedicated server?

Posted on 2009-02-20
Last Modified: 2012-05-06
Is it ok for SQL Server 2008 Express to run on a shared file server or should it have a dedicated server?  If it should be dedicated, what specs do you recommend for the hardware?  We run a small docketing database with Access 07 front ends that has about 20 users updating at one time and up to 40 with view/reporting rights.  
Question by:LawGirl
    LVL 32

    Accepted Solution

    A dedicated server is always preferable, but whether it will  be necessary depends on load.

    User counts bear on load, but the intensity of the data access varies widely between applications.  Does you application vendor have any recommendations?

    You could always try it on the shared server and move it if it bogs down.  Alternatively, buy a server with some upgrade potential.  I would guess that the data operations aside from the reporting are fairly simple.  One CPU and a couple GB of RAM may do just fine ... but the potential to add a CPU and a few more GB of RAM would be worth some extra money.
    LVL 76

    Assisted Solution

    What are the specs of the server? In particular how much memory does this server have? 2, 4 GB?
    How big is the existing database?
    If you are migrating from an Access type of database to an SQL. And this is your transition evaluation process, you should be fine with installing sql express on the existing file server. After the transition, you would need to  retask/reprioritize the file server into an application server (properties of my computer\advanced\performance settings\advanced: processor and memory priority given to programs versus background and system cache).
    Once you are satisfied with the functionality of the database, you can dedicate a server for the SQL if its perfomance lags on the fileserver or affects the filesharing performance.
    LVL 57

    Assisted Solution

    by:Raja Jegan R
    One basic criteria to decide for your problem is how much resource will your server and the other applications in it require.

    If both of them are going to utilize the server resources fairly, then you can have it as a share server itself and in later if it grows you can add a new server and separate out the applications at that point of time..

    So kindly check for the worst case load for all applications in that server and decide your approach.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
    There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now