Solved

Server Questions VM vs Single Server and more (SBS or standard) to many options :(

Posted on 2013-05-30
6
283 Views
Last Modified: 2013-06-06
Ok I have a newly developed web application that 20 users will have access to internally at the office. The app is heavily data intensive as it will use hand held scanners for entry and there are multiple check points at which this data will be accessed. Here is where I get confused.
1. The developers said originally that we needed two servers. One to host mssql and another to actually do the work of input and output to the sql server. However we talked to them and they said a single server would work if we had enough specs. That would be SBS2011 Standard. As I got to looking it seems I would still have to purchase MSSQL and additional licences to my understanding. we were looking to use office 365 vs exchange seeing as I have 2 other servers with exchange that in my opinion don't do as well as they should.

2. After reading all this information I contacted a server guy we have used for some time and handed him all the information I had been given. He then comes back to me with the recommendation that he would use a single server and run VM's to still wind up with 2 server os's running the setup.

3. Here is my quesitons

If I could run this on SBS 2011 Standard or 2012 Standard and had to purchase MSSQL 2008 + enough license for 20 users internally what happens when I have the possibility of 100 people accessing the website from an external facing part of the app? would I need additional licensing for that as well?

The server guy seems to think I really need to not allow the DC to be accessed easily from the web yet I have 2 other DC's at two other locations that are and I have no issues with them. What do you guys think?

I have dealt with another server that ran Exchange and a second data related application that ran SQL that server ran very very poorly until I had installed a second DATA only drive the the application. I don't want to wind up in that situation again. Which is the primary reason for going with office 365 in exchanges place.

The dilemma is I originally had roughly a 6K budget on this server and the developers talked like a single setup would work. Now with throwing MSSQL and 20 license + on it I am not sure I can do that. In the end I want a good strong setup not just over powered and Im willing to do what it takes to make it run right. Even it that means VM and larger scale hardware. I hope this explains the situation please ask more questions as needed.

Just looking for opinions and Advice at this point.
0
Comment
Question by:calvinclose
  • 4
  • 2
6 Comments
 
LVL 10

Expert Comment

by:JEaston
ID: 39207943
If the application developer states that 1 server should be sufficient then I would find out from them what spec they would require for this server.  After all only they will know their application.

Personally speaking one server to maintain and update is usually preferable to two (in my opinion anyway).  It should also be cheaper in terms of licensing, and even hardware (1 higher spec should be cheaper than 2 of half the equivalent spec).

As for SQL licensing, last time I looked you could licence per client or per processor.  If you therefore want to open this up to external users unless you can quantify how many users this will be, you may have to go down the per processor route.  This means for each physical process in your server you need a licence.  This limits the users count only to what your server can handle.

As for having two virtual machines, unless there is a compatibility issue this just adds extra overhead and complexity which I'm not sure is required from what you have said above.
0
 

Author Comment

by:calvinclose
ID: 39208866
Well microsoft says that because there is an external part of the application open to customers and vendors that we need a sql cal per person that uses the site. That makes no since to me considering it almost immediately forces the upgrade to the per core sql model they now employ. Most developers to my understanding using a single login and password in their connection string to access the database functions. Meaning a single cal should work from the technically speaking side of things. Now if the developer uses the actual login / password of the account holder and passes that along to SQL during data manipulation I can see the cal issue. But according to Microsoft I need to go with Server 2012 Standard + add MSSQL with $7200.00 worth of Core licenses to even get started. I am left to assume that all businesses with websites "should" be using basically the same model if they host there own application like we plan to.
0
 

Author Comment

by:calvinclose
ID: 39208872
I will also say that a single server seems like the way to go at this point no vm and no secondary server. Does the above post seem to make since? Does everyone else understand the Licensing to be the way I described it?
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 10

Accepted Solution

by:
JEaston earned 500 total points
ID: 39208985
Your post makes sense to me.  I'm not sure Microsoft would agree about the 'single login' meaning single CAL.  Many applications have a single login for the application which is used for hundreds of users.

I guess if you were giving access to each of your customers you could say I have 100 customers therefore I need 100 CALs.  If the site is open to the world however, I believe the Core Licenses are the only legal option.

A couple of other points you could look at.  First does the application need the full version of SQL?  If the SQL usage is fairly light then SQL Express (a free limited version of SQL) might be sufficient.

Secondly, could you host the SQL offsite using a database hosting provider?  The monthly cost could be much less than buying the core licenses.

I think this cost is one of the main reasons many people prefer open source databases like mySQL.
0
 

Author Comment

by:calvinclose
ID: 39209287
Thinking on this through tomorrow thanks for the help so far.
0
 

Author Closing Comment

by:calvinclose
ID: 39225563
Went back to the developers and put together a new plan using sql express. Thanks for the assistance.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

The reason that corporations and businesses use Windows servers is because it supports custom modifications to adapt to the business and what it needs. Most individual users won’t need such powerful options. Here I’ll explain how you can enable Wind…
A procedure for exporting installed hotfix details of remote computers using powershell
In this Micro Tutorial viewers will learn how to use Windows Server Backup to create full image of their system. Tutorial shows how to install Windows Server Backup Feature on Windows 2012R2 and how to configure scheduled Bare Metal Recovery backup.…
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…

743 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

13 Experts available now in Live!

Get 1:1 Help Now