Using SQL Server 2008 Standard to initially start out a .com

tags:

sql-server

views:

answers:

+1 Q:

Using SQL Server 2008 Standard to initially start out a .com

I know Enterprise is what I really want but when you have NO budget practically and want to start a .com then I wonder if standard would be a good choice to go with initially until you're pushed by sheer volume to go to Enterprise later with SQL Server 2008.

Thoughts?

I can't afford Enterprise but want to start a .com where I'll be getting around 2 million hits. So anyone using Standard out there for a situation like this who is strapped and knows they'll be eventually getting a lot of hits but at first figures they can just get by with the minimum SQL Server edition until that threshold becomes unmaintainable from a basic standpoint? For example, I don't need to be clustering until later I don't think.

+3 A:

You could go with Sql Express if cost is an issue. OR you can join the WebSpark or BizSpark programs.

Chuck Conway 2009-11-25 16:58:26

Both of programs; 'webspark' and 'bizspark' are very good at getting you the necessary Microsoft software to get started with an asp.net .com business.

Chris 2009-11-25 17:00:47

I just wonder how scalable express is. I mean I don't know lets say we get 1 million inserts in a year or 2. I guess I would not need clustering yet. I am not a guru on SQL Maintenance or extensibility.

CoffeeAddict 2009-11-25 17:01:22

thanks...for the info on webspark, very much needed.

CoffeeAddict 2009-11-25 17:01:53

SQL Express has a 4GB size limit and a 1GB RAM limit - I doubt it's appropriate for the scale you're intending.

CodeByMoonlight 2009-11-25 17:09:52

The scalability of Express comes in the fact that you can upgrade directly to Standard or Enterprise once you start getting a million inserts. Presumably by that point you'll have a business model that permits a budget for such things.

StriplingWarrior 2009-11-25 17:31:00

Yea, I wouldn't even consider SQL Express. It's not meant for a heavy site like a .com.

CoffeeAddict 2009-11-27 15:17:11

However, if I can deal with 4 Gigs with Express then upgrade, that's not a bad way to start out a .com...free.

CoffeeAddict 2009-11-27 15:17:41

It looks to me like that WebSpark is only for Website development services type of businesses. Not for a .com

CoffeeAddict 2009-11-27 16:24:51

My .com is not going to be one that builds out websites or applications for others, it's a social site.

CoffeeAddict 2009-11-27 16:25:23

ah there's a tab called startup http://www.microsoftstartupzone.com/pages/home.aspx

CoffeeAddict 2009-11-28 02:08:23

That BizSpark to me looks like you don't get anything different for SQL Server. They just show you a link to their compare page when you look at the list here: http://www.microsoftstartupzone.com/Software/Pages/Products_at_a_glance.aspx

CoffeeAddict 2009-11-29 04:45:44

What's the value of BizSpark if I still have to pay a crapload for SQL 2008 Standard or Enterprise when I'm just starting up and definitely do not have capital to buy such a high license. I don't see the value at all in BizSpark.

CoffeeAddict 2009-11-29 04:46:25

I don't know, all I see on the BizSpark site is you can "sign up free" big fing deal. And "you have access to software". Ok so where's this great savings? there are none?

CoffeeAddict 2009-11-29 04:49:28

+1 A:

If you're using it as the backend for a website, you may want to look at the SQL Server Web Edition as a cheaper option.

CodeByMoonlight 2009-11-25 16:58:59

Thought about that. I just wonder if indexing or other speed issues will come up in these lower editions.

CoffeeAddict 2009-11-25 17:02:43

+1 A:

I'm sorry, I don't know if you are talking about a standard timeframe with your 2-million-hit benchmark, but here at work we are right at that count monthly runnning on Standard. No issues.

Chris Simmons 2009-11-25 17:03:59

thanks a lot. Are you guys a .com?

CoffeeAddict 2009-11-27 15:12:48

No, this is an intranet site, but we have lots of traffic.

Chris Simmons 2009-11-27 19:25:34

+1 A:

If you trust the cloud, you might also consider SQL Azure. It can scale on demand, so you pay based on how much you actually need.

StriplingWarrior 2009-11-25 17:34:44

ansaurus

tags:

views:

answers:

Using SQL Server 2008 Standard to initially start out a .com

related questions