SQL SERVER EXPRESS versus SQL SERVER

Would anyone really use ASPNET2 Membership Services with its built in Sql Server Express database for a major, heavy traffic website? How well would sql server express handle 1 million members? Can anyone point me to an article comparing performance of full blow Sql Server with (watered down?) Sql Server Express?
0
jonrwarren
12/25/2005 8:25:43 PM
asp.net.sql-datasource 29906 articles. 0 followers. Follow

2 Replies
738 Views

Similar Articles

[PageSpeed] 40

Seems to me you already know the answer to this question in the way you
ask the question.  SQL Server express is just for normal web
applications for learning/teaching and small time deployment. 
Obviously by logic heavy traffic ( esp in the 1 million range even in
the thousands) would require SQL Server 2005.  Simply by pointing
your browser to the microsoft website you can find this information out
and the differences in versions.

Eric Ramseur
Rainbow Portal 2.0 Admin
Download Rainbow 2.0!!
Rainbow Code
Rainbow Portal Community
C# 2005 Group
0
eramseur
12/26/2005 10:35:37 AM

I'm also curious what the performance would be like for SQL Server express. I want to deploy it on a site expecting probably around 50,000 to 200,000 hits a day to the database. Would this be too many for Sql Server Express?

 Thanks,

Paul
 

0
paul_mendoza
2/16/2008 8:56:01 AM
Reply:

Similar Artilces:

SQL Server 2005 Installation problems with SQL Server Express & SQL Server 2000
Hi Guys, I have had SQL Server Express and Sql Server Management Studio Express installed on my machine for some time and recently tried to install a trial of SQL Server 2005 as well.  (Yes, I'm migrating from Visual Studio Express to Visual Studio Professional, just as in tended!) Everything went fine except that nothing seemed to be installed.  I searched in all the obvious places - both on the Start/Programs menu and on the hard-drive: nothing. A check under Add/Remove Programs showed that Sql Server 2005 Express was installed, but called SQL Server 2005. So after a number o...

Converting MDF files (SQL Server Express) to SQL Server 2005 WITHOUT having to buy SQL Server 2005 (I have Express). Personal WebSite Starter Kit
Hi (and HELP!),   I downloaded the Personal WebSite Starter Kit and got it working no problem on my local machine.  But I've had nothing but frustration trying to get it up and running on a webhosting site.  I picked hostmysite.com which uses SQL Server 2005.  I was under the impression that it wouldn't be that big a deal to convert the .MDF files that Sql Server Express uses to a SQL Server 2005 database.  I tried using SQL Server Management Studio Express.  I was able to "see" my remote database on hostmysite.com, but I was not able to import the .mdf files ...

Converting MDF files (SQL Server Express) to SQL Server 2005 WITHOUT having to buy SQL Server 2005 (I have Express). Personal WebSite Starter Kit
Hi (and HELP!),   I downloaded the Personal WebSite Starter Kit and got it working no problem on my local machine.  But I've had nothing but frustration trying to get it up and running on a webhosting site.  I picked hostmysite.com which uses SQL Server 2005.  I was under the impression that it wouldn't be that big a deal to convert the .MDF files that Sql Server Express uses to a SQL Server 2005 database.  I tried using SQL Server Management Studio Express.  I was able to "see" my remote database on hostmysite.com, but I was not able to import the .mdf file...

Converting MDF files (SQL Server Express) to SQL Server 2005 WITHOUT having to buy SQL Server 2005 (I have Express). Personal WebSite Starter Kit
Hi,Basically i built a webpage with Login and it's working well from my local machine.Right now, i'm using Database Publishing Wizard. the problem is how do i convert.MDF files to .SQL 2005 to get my database publish in the internet? thanks  Place your .MDF file in the App_Data directory, change the connection string accordingly and then publish your web site. ----------------------------------------------------------Please click Mark As Answer if this helped in solving your problem.  Please click "Mark As Answer" if this hepled in solving your problem. ...

sql server and sql server express
ok i am puzzled right now....i have a web application connecting to a sql server database....i uninstalled sql server express and installed sql server 2005 full version...i changed the connection string in my application to be Data Source=SKYBANDR62;Initial Catalog=aspnetdb;Integrated Security=True and through the explorer bar i can access my database freely but when i run my application i get this error Server Error in '/' Application. -------------------------------------------------------------------------------- An error has occurred while establishing a...

Deploy Sql Server Express DB to Sql Server Express
I have developed by webite with Visual Studio 2005 and sql server express. I'm trying to deploy my website to a VPS with sql server express running on it I ftp'd the App_Data folder to the remote via the 'copy web site' Everything seemed okay until I started trying to run more complex database operations using stored procedures and transactions. It appears that the schema is messed up because when defining the parameters for a stored procedure, upon ExecuteNonQuery I get the error that I've assigned too many parameters which I have not (since it runs fine on...

sql server and sql server express conflict
hey all please help me ....i have been working on this issue for 2 days i created a web application with a automatically generated security database and added tables to it and it was working fine...i had to a linked server the linked server cannot be added from sql server express so i installed the full version...it was working fine until suddenly i got this error "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed" so i searched and searched then i found out that i cannot have the two ver...

Mixing SQL Server and SQL Server Express
VWD 2008 Express.  Visual Basic. I have some questions: 1.  If I create a web site that uses a local database (stored in a directory in my web site's root directory) handled by SQL Server 2008 Express, what happens when I move the site from VWD to my server?  My server has SQL Server 2005 Standard running on it.  Will my site run even if SQL Server 2008 Express is not installed on the server?  Do I need to install SQL Server 2008 Express on my server? 2.  Can my Windows 2003 Server run both SQL Server 2005 Standard and SQL Server 2008 Expre...

SQL Server Express file to Sql Server
I would like to copy the schema and data of a sql server express database file to a SQL Server Database. How can this be done and what steps would I need to take?   Thanks for any helpTinyPond TinyPond:I would like to copy the schema and data of a sql server express database file to a SQL Server Database. How can this be done and what steps would I need to take? If you have Express Management Studio, you back backup your database, and them import it to SQL Server (or attach and reattach).Justs open SQL Server Express Management Studio, connect to your Express instanc...

SQL Server Express and SQL Server 2005
can any one tell me what the main differences are in the two editions? also can you use and express 2005 edition database on sql 2005? if not how would you do that? Tuppers Look here for a detailed comparison between the two.Yes, you can use Express databases on SQL Server 2005. Just attach it to an instance of SQL Server 2005.Is this enough information?DonDon Kiely, MCP, MCSDIn the Last Frontier, Interior AlaskaPlease post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem! cheers i was told by my host t...

SQL Server Express
I'm developing applications with VWD Beta1 and SQLServer Express, and when its possible I'll want to publish it on the INet. I'll probably publish it in a server with SQLServer (without Express), and I want to know if I will have to change something in my code for this change. Thanks!!subgurim.net: blog de ASP.NET 2.0 con C# en castellanoes-asp.net: el portal de ASP.NET en castellano If you don't use any specific SQl 2005 Features, you should probably not need to change your code (Maybe only the connection string so it will target the other Sql Server)./Fredrik Normén - fredrikn @ tw...

This version of Microsoft Sql Server Management Studio can only be used to connect to Sql Server 2000 and Sql Server 2005 servers
When I connect SQL Server 2005 to a remote database i get the error: "This version of Microsoft Sql Server Management Studio can only be used to connect to Sql Server 2000 and Sql Server 2005 servers". Can I confirm it is because: the remote db is of SQL Server 2008? There is a soln mentioned in http://forums.asp.net/t/1324047.aspx Did anybody try this (installing 2008 express: http://www.microsoft.com/express/sql/download/)? I am just checking again, whether it will disturb my existing SQL Server installation, in any means...? Though it is mentioned that it will g...

How to connect to my sql server express,also Pubs and northwind for sql server express
1, I have installed VWD express,sql server 2005 express.I also install management studio and adventureswork db.In the management studio I can able to connect and view adventurework db.But I can't manage to make a connection string to my db server when connecting to management studio server name is "KAMRANSHAHID\SQLEXPRESS".I wants a connection string with respect to this server.2,Is there new database for pubs and northwind for sql server 2005.Or they are of old sql server 2000.I have installed sample databases but can't find script for pubs and northwind nor it install automatically.I wan't...

SQL Server Express & SQL Server 2000
I'm currently developing my website using SQL Server Express which comes by default with the Visual Web Developer. My hosting is using SQL Server 2000. Is the database I created using sql server express compatible with sql server 2000? Other databases hy hosting supported includes MySQL, Access, SQL Server 2000. Among these three, which one I best use on my site? My site doesnt involved much database activity. Thank you  Shuf wrote: Is the database I created using sql server express compatible with sql server 2000?Not so that you could just take SQL2005 database file and ...

Web resources about - SQL SERVER EXPRESS versus SQL SERVER - asp.net.sql-datasource

The Indian Express: Latest News, Breaking News Live, Current Headlines, India News Online
Indian Express covers latest news from India, all exclusive current headlines and India news live, including latest breaking news on business, ...

Local news, sports, obituaries, classifieds and more - Tallmadge Express
NEWARK, N.J. (AP) Gov. Chris Christie, who once famously called himself "the healthiest fat...

Sussex Express
Search continues for boy swept out to sea at... The search has continued today (Monday October 28) for the 14-year-old local boy who was swept ...

PCI Express - Wikipedia, the free encyclopedia
... standard support hardware I/O virtualization. The PCIe electrical interface is also used in a variety of other standards, most notably ExpressCard ...

Express Scripts offers $1 alternative to $750 pill
After drug company's owner announced a 5,000-percent price hike earlier this year, a less expensive option will soon be available

American Express cuts back on perk for Small Business Saturday
Over the past five years, American Express has dangled a carrot to encourage cardholders to patronize independent stores on Small Business Saturday ...

Express Scripts To Offer $1 Version Of Drug That Skyrocketed To $750/Pill Overnight
... of Daraprim skyrocketed to around $750/pill, resulting in angry doctors , and a Senate investigation . Today, pharmacy benefits giant Express ...

Special Operators Take Poll On Women In Combat, Express Three Particular Concerns
Special Operators Take Poll On Women In Combat, Express Three Particular Concerns

Consumers Express Interest in IoT, Concerns Over Privacy
Nearly one-third of those that browse shopping websites make an online purchase using their mobile phone, the survey found.

Martin Shkreli Questioned By Express Scripts' Chief Medical Officer
During his Q&A at the Forbes Healthcare Summit, Martin Shkreli shared an exchange with the Chief Medical Officer of Express Scripts.

Resources last updated: 12/17/2015 6:07:18 AM