Framework Equivalent in MSSQL?

Introduction:
I want to put database based asp.net web site on a windows server.
For the asp.net files there is a free framework that will run the asp.net
files on the server.
The Question:
Is there any free PROGRAM that can run the .mdf and .ldf files on the
server?
And what is the name of that program?
Bishoy George
bishoy@.bishoy.com"Bishoy George" <bishoy@.bishoy.com> wrote in message
news:%23OPKnGAVGHA.5900@.tk2msftngp13.phx.gbl...
> Introduction:
> I want to put database based asp.net web site on a windows server.
> For the asp.net files there is a free framework that will run the asp.net
> files on the server.
> The Question:
> Is there any free PROGRAM that can run the .mdf and .ldf files on the
> server?
> And what is the name of that program?
SQL Server 2005 Express Edtion.
David|||it's name is MSDE (now SQL server express) if you're not planning on
more than a few concurrent connections. Otherwise you have to pay - or
SQL server would be free.|||Are you saying that there's a limit to the number of concurrent users in MSD
E
and SQL Server 2005 Express?
ML
http://milambda.blogspot.com/|||"ML" <ML@.discussions.microsoft.com> wrote in message
news:B8808488-053B-4525-9546-7C67A32A6F22@.microsoft.com...
> Are you saying that there's a limit to the number of concurrent users in
> MSDE
> and SQL Server 2005 Express?
>
There is no user limit in either product, but both products have baked-in
performance limitations.
In MSDE there is a workload throttle that slows down performance beyond 5
concurrent workloads. In SQL Server 2005 Express Edition you can only use 1
CPU and 1 GB of memory.
David|||There's no such limit in either of them. MSDE has a performance throttling f
unctionality which added
a wait for each I/O when you had more than 8 concurrently executing queries.
No such in Express. But
there are limits on db size, number of processors and memory, of course.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ML" <ML@.discussions.microsoft.com> wrote in message
news:B8808488-053B-4525-9546-7C67A32A6F22@.microsoft.com...
> Are you saying that there's a limit to the number of concurrent users in M
SDE
> and SQL Server 2005 Express?
>
> ML
> --
> http://milambda.blogspot.com/|||Yes. Of course there's a limit. Otherwise everyone could just run sql
servers for free. I believe that they've slackened it a bit from the 5
for MSDE, but it's still limited. Last thing I read on it said that as
connections go above 5 MSDE massively throttles the performance of the
SQL server, so it's not an error thrown kind of limit, but your SQL
server becomes rubbish.|||The workload governor is said to be removed in the SQL 2005 Ecpress version.
Not trying to argue, just want clear facts. :)
ML
http://milambda.blogspot.com/|||Ecpress = Express
(in this particular case ;)|||> Yes. Of course there's a limit. Otherwise everyone could just run sql
> servers for free. I believe that they've slackened it a bit from the 5
> for MSDE, but it's still limited.
There is no longer any limitation that has aything to do with the number of
users, number of connections, or number of concurrent queries. The limit is
that Express will only be able to use 1 GB of memory, a single CPU, and the
database size is limited to 4GB. So, if one or more of those criteria do
not meet the requirements of your app, look elsewhere. I imagine there are
pleny of apps out there that could have 1000 concurrent users on Express and
work fine. On the flip side, if I tried real hard, I could design an
application that would completely suck wind with more than 1 concurrent
user, even if deployed to Enterprise edition with 32 GB of RAM. So the
question is more about design and requirements than any artificial
limitation.

> connections go above 5 MSDE massively throttles the performance of the
> SQL server,
[It's actually 8, not 5/]

> so it's not an error thrown kind of limit, but your SQL
> server becomes rubbish.
Have you actually experienced performance throttling THAT BAD on MSDE? Or
is it just hearsay? Granted, I would not personally deploy MSDE or Express
to a production application (because I want to sleep at night), but I have
not been able to reproduce this "rubbish" in some pretty serious testing.
A