Implications of MSDE for website

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.

All Forums

SQL Server 2000 Forums

MSDE (2000)

Implications of MSDE for website

Author

Topic

Chainwhip
Starting Member

33 Posts

Posted - 2005-03-16 : 19:04:35

What are the implications of running a website using MSDE as the database. When it says maximum 5 users what does this mean? Could I still run a .NET website that will serve more than 5 simultaneous connections?

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-03-16 : 19:35:32

You will have the workload governor to contend with, as well as a 2GB limitation on databse size. The db size issue is probably not a big deal though.

here is info on the workload governor http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq.asp?frame=true

-ec

Kristen
Test

22859 Posts

Posted - 2005-03-17 : 04:51:35

Does it breach the license for MSDE?

Kristen

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-03-17 : 13:17:32

quote:
Originally posted by Kristen

Does it breach the license for MSDE?

Not according to the FAQ on the main MSDE 2000 page.

-ec

Kristen
Test

22859 Posts

Posted - 2005-03-17 : 14:39:30

Scratch that then!

Kristen

andy8979
Starting Member

36 Posts

Posted - 2005-04-05 : 06:36:37

I don't think so as I have successfully used msde with almost 12 connections to the server simultaneously but no one complained regarding the performace issue,
But yes the database size is really the main issue you should check this constraint and then decide.

Anuj

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources