| Author |
Topic |
|
kparacha
Starting Member
2 Posts |
 Posted - 2006-11-30 : 02:32:28
|
| Hi,We are in the midst of developing/upgrading an online store in ASP.net 2.0 that typically gets about 100,000+ hits per week and we are considering MS SQL 2005 Express as its free to use. My question is how will MS SQL 2005 Express support so many concurrent visitors and will MS SQL 2005 Standard / MS SQL 2005 Workgroup be a better option as far as performance?Thanks,Kamran |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-30 : 03:53:19
|
| Yes, Standard or Workgroup will perform better.However, there is a restriction in using SQL Server with ASP and web.Read about SQL Server Express and Internet/Web access.You probably know that you can freely distribute SQL Server 2005 Express with your applications, but did you know that you must first obtain a SQL Server 2005 Express Edition redistribution license? The redistribution license is free; all you have to do is register for it. To register for SQL Server 2005 Express Redistribution rights, go to: http://www.microsoft.com/sql/editions/express/redistregister.mspxPeter LarssonHelsingborg, Sweden |
 |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-30 : 11:48:42
|
| "there is a restriction in using SQL Server with ASP and web"Peter can you please provide a link to this?"Yes, Standard or Workgroup will perform better."I'm interested to know why you say that? Express has limitations in terms of how much hardware it will use, so if you have more hardware then Workgroup or Standard would perform better but given the same hardware they should be the same? |
|
|
|
ahallett
Starting Member
7 Posts |
Posted - 2006-12-01 : 04:51:03
|
| I had heard that SQL Server Express was OK upto about 3 or 4 concurrent users and performance4 degrades significantly after that. The Microsoft site is silent on the matter - but has anyone observed this/not observed it?Any solutions?ThanksAlan |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-02 : 01:33:35
|
| MSDE had something called the workload governor that limited processes, but Express is full blown SQL Server with the 1 CPU, 1GB of RAM, 4GB database size limit. Can you give any specific details about performance issues that can be demonstrated to occur only on Express vs Standard on the same hardware?I'd be happy to run tests on both if you can give any examples of data and queries that are supposed to exhibit these problems. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
hizuka
Starting Member
7 Posts |
Posted - 2006-12-19 : 01:00:08
|
| Workload Governor does not exist in SQL Server Express anymore. http://msdn2.microsoft.com/en-us/library/ms165672.aspxI think the 4GB database size limit is still a problem to a lot of applications. If you are considering a free Database, maybe, IBM DB2 Express can be an alternative. DB2 Express is also free but do not have limitation on DB size and number of users. Sorry to mention other database in this forum. Just my opinion. I just get to know that DB2 Express also a free database and now considering it because there is no database size limit.Cyber-Girl http://www.sqlref.com |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-12-19 : 02:13:06
|
| Standard or workgroup will potentially perform better because of their lack of memory restrictions as well as 64bit support. Aside from that, the other difference in the various SQL 2K5 editions is pricing and licensing. With SQL Express you do not have to worry about db licensing and the product is free even for internet facing apps. With standard edition (or any other non-free SQL2K5 edition) you do need to worry about it. Since you are talking about an internet facing application, you would need to purchase processor licensing if you chose to use any edition other than SQL Express - which can be quite expensive.here is the page that details the different licensing scenarios you may need to consider http://www.microsoft.com/sql/howtobuy/default.mspxhere is the link to the SQL 2005 (including sql express) product feature comparison matrix http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx previously posted by jezemine.-ecNOTE:Edited for clarity |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2006-12-19 : 04:59:59
|
quote:
Since you are talking about an internet facing application, you would need to purchase processor licensing, which can be quite expensive.
Is this really true? Where is the legalese that stops me from exposing SQL Express to the web/net/etc.. Anybody got any hard evidence of this?I have no problems with the hardware/size restrictions.But this "depends what is using it" stuff is utter bullshit.DavidMProduction is just another testing cycle |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-12-19 : 12:25:22
|
quote:
Originally posted by byrmolIs this really true? Where is the legalese that stops me from exposing SQL Express to the web/net/etc.. Anybody got any hard evidence of this?I have no problems with the hardware/size restrictions.But this "depends what is using it" stuff is utter bullshit.
i guess my post was poorly worded. I was referring to the non-free editions of SQL Server. SQL Server express is free and can be used for internet facing applications.If you want the features that workgroup, standard or enterprise edition bring to the table, then you will need to purchase a processor license for the internet facing apps.sorry for the confusion.-ec |
|
|
|
SHyriLL
Starting Member
1 Post |
Posted - 2009-10-20 : 11:58:33
|
| Hi Guys Please help me with this one,Why Standard Edition as opposed to Workgroup Edition? The Workgroup Edition more than cover the limits of our physical server. Does the Standard Edition do something that Workgroup doesn't? Thanks |
|
|
|
|
MS SQL Express vs MS SQL Standard