Solved

SBS 2008 SQL Server 2008 Usage

Posted on 2011-03-14
1
476 Views
Last Modified: 2012-05-11
I'm currently working on a project for a client - there are approximately 35 users, which will be using a SBS 2008 Premium server. Dual-core processor, 8GB RAM.

They do have a line of business application which will ultimately run on SQL 2008 standard - it is currently in the process of being converted into a MS SQL database by another party.

The size of the current database is 25GB with predicted growth of approx. 8GB per year.

I've been advised that the database is too big to run on a SBS 2008 Premium server, and have been advised to run a second Windows Server 2008 with SQL 2008 to 'host' the line of business application.

I have a couple of questions on this;

1) If one were to attempt to run SQL 2008 on the SBS 2008 box - what would be the pitfalls of this, and is it advisable for a database of this size to even attempt this?

2) If we join another Windows Server 2008 box to the existing domain and then install SQL 2008 to that box - what specification is suggested in terms of hardware for this box in order to achieve decent performance assuming 20 users max ?

Thanks for your help, have been reading various technet articles etc - however, hard to get a definitive answer on hardware specs -v- real world usability.
0
Comment
Question by:foxpc123
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 6

Accepted Solution

by:
brb6708 earned 500 total points
ID: 35131083
I don't think the overall size of a database is a trigger for the server size. If you have a huge database without transactions, there's no need to use a high performance machine with a lot of memory.

The complexity of the database tables, the relations between them and the number of transactions make the difference. Many small transactions in a small database can cause much more load than few transactions in a big database. Propper index definitions help to keep the system fast.

If you  don't know about the ressources you really need I'd suppose to set up a system that's "medium sized". Actually the size of the machine that you have described is worth making a trial. If you encounter problems with the time for queries than you have to encrease memory and CPU power.

Hardware prices are still shrinking and so it's better to enlarge the machines according the real needs than establishing a over dimensioned machine - at least as long as money plays some kind of role in the game....
0

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

696 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