Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bluem
Starting Member
3 Posts |
 Posted - 2009-09-01 : 09:48:39
|
| Hello,Currently we have 1 SQL Server 2005 Standard in our Company that being used for small business manufacturing application which...Currently I am doing research on SharePoint Server, and Mail Archiving Solutions. Both require SQL Server to run...and later there will be more application that will require SQL Server.I came to this forum to inquire about the best SQL Solution for our company...here are my questions:1) If I purchase a SQL Server Standard License is it suitable or recommended to run multiple databases for applications such as Microsoft SharePoint, Mail Archiving Application..or more applications? 2) Should I purchase a SQL Server Standard License for each application that requires SQL Server...the 1 license is $800...In this case I will have a SQL Server for each application.3) Or I should purchase SQL Server Enterprise and run multiple databases for different applications...I just want to make sure i pick a solution that will give me the best performance...I don't want to overload SQL Server and not sure if SQL Server Standard is up the job or Enterprise is better.I plan to run SQL Server as Virtual Server...Thanks for the help in advance.B |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-09-01 : 09:59:58
|
| You can run Standard with multiple databases. Unless you are working on OLTP databases, you probably will not have any need for the Enterprise Edition and it will simply be overkill. |
 |
|
|
ScottWhigham
Starting Member
49 Posts |
Posted - 2009-09-03 : 09:59:41
|
quote:
1) If I purchase a SQL Server Standard License is it suitable or recommended to run multiple databases for applications such as Microsoft SharePoint, Mail Archiving Application..or more applications?
Yes, in most cases. It depends on how many users, how big the database(s), how much the other apps use. It is obviously better to have standalone servers for each function but budgets don't always allow this. Question: Have you looked at Small Business Server?quote:
2) Should I purchase a SQL Server Standard License for each application that requires SQL Server...the 1 license is $800...In this case I will have a SQL Server for each application.
There are two ways to license SQL: "unlimited connections" (a.k.a. a CPU license) or "one license per user". For full details, check out the Pricing and Licensing FAQat [url]http://www.microsoft.com/sqlserver/2005/en/us/pricing-licensing-faq.aspx[/url]. Usually your MS product rep (or the company selling it to you) is good about advising the best option.quote:
3) Or I should purchase SQL Server Enterprise and run multiple databases for different applications...
Listen to RickD...quote:
I just want to make sure i pick a solution that will give me the best performance...I don't want to overload SQL Server and not sure if SQL Server Standard is up the job or Enterprise is better.
It's hard to justify the 5x cost of EE vs. SE for a lot of companies. "Best performance" could mean an extra $250,000 for licensing. "Such good performance that you wouldn't even know the difference" could save you that $250,000.Bottom line: unless you specifically need the features of EE, it's not likely something you would purchase purely for "performance" purposes. SE is awesome, fast, and runs 100GB databases with ease.Compare features: [url]http://www.microsoft.com/Sqlserver/2005/en/us/Compare-Features.aspx[/url]========================================================I have about 1,000 video tutorials on SQL Server 2008, 2005, and 2000 over at http://www.learnitfirst.com/Database-Professionals.aspx |
|
|
|
|
|
|
|
|
SQL Server Enterprise vs. Standard or More