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

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.  
Who is Participating?
Daniel WilsonCommented:
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.
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.
Raja Jegan RSQL Server DBA & ArchitectCommented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.