Showing posts with label licence. Show all posts
Showing posts with label licence. Show all posts

Monday, March 12, 2012

MSDE Licensing

The MSDE licence says that it can be used for up to 5 concurrent users. My app is an ASP.NET app, so won't I just be using one user - the ASP.NET account? I'm wondering whether we can get away with just buying a new server and sticking MSDE on it rather than shelling out for another £5000 SQL server licence...I do not believe what you say (5 concurrent users) is correct.

http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp.

From this page:

Q. Can I use MSDE as a database for Web applications?

A. Yes, MSDE is an ideal solution for basic Web applications with up to 25 concurrent users.

There is throttling of performance with 8 concurrent OPERATIONS (but three are normally used internally).

Fromthis page:

The Microsoft® SQL Server? 2000 workload governor is designed to limit the performance of an instance of the database engine any time more than eight operations are active at the same time. An instance of the SQL Server 2000 database engine is one copy of the database software that operates as an operating system service.

The operations counted by the workload governor are:

Processing a request to open an inbound connection and login.

Processing a batch of one or more Transact-SQL statements received over an inbound connection.

Processing a distributed transaction operation, such as a prepare-to-commit or rollback operation.

Processing a request to log off and close an inbound connection.

Periodic system-generated operations such as shrinking a database if the database has the AUTO_SHRINK option turned on, completing the deletion of rows from the base level of indexes, or populating the SQL Server performance counters in the System Monitor.

Instances of SQL Server 2000 Personal Edition will also periodically generate system operations to process any full-text indexes referenced by the databases managed by the instance. SQL Server 2000 Desktop Engine (MSDE 2000) does not support full-text indexes.|||Sorry - missed a "2" out there.... Thats answered the question great - thanks a lot!

msde licence

we get from a company installed at our customer sides an application using
msde in a win 2000 server (terminal) or higher network enwironment. We have a
lot of troubles because this application is going to let our application fail
often , and we get a lot of instability.
Hi rudolph,
Sorry, but dont' see a question here. Why do you think that the MSDE is
causing instability for your app?
Regards,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"rudolph" <rudolph@.discussions.microsoft.com> wrote in message
news:121817FD-B051-4D59-9690-BDD6DA952ADA@.microsoft.com...
> we get from a company installed at our customer sides an application using
> msde in a win 2000 server (terminal) or higher network enwironment. We
> have a
> lot of troubles because this application is going to let our application
> fail
> often , and we get a lot of instability.
|||Hi Greg!
My question is, that we have done out of a pervasive sql based application
an Interface to a small application. This small application is using msde in
a enviroment, we are using, win 2003 or winn200 Server with terminal clients.
The company, who has done the small aplication we are interfacing has
installed at our clients side either msde or MSSQL Server products, depending
on their stability.We have not been asked by them what they are going to
install I thought, that msde is a client product and not a server product. IS
msde a product which can run simitaniosly in our environment?
"Greg Low [MVP]" wrote:

> Hi rudolph,
> Sorry, but dont' see a question here. Why do you think that the MSDE is
> causing instability for your app?
> Regards,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "rudolph" <rudolph@.discussions.microsoft.com> wrote in message
> news:121817FD-B051-4D59-9690-BDD6DA952ADA@.microsoft.com...
>
>
|||hi Rudolph,
rudolph wrote:
> Hi Greg!
> My question is, that we have done out of a pervasive sql based
> application an Interface to a small application. This small
> application is using msde in a enviroment, we are using, win 2003 or
> winn200 Server with terminal clients. The company, who has done the
> small aplication we are interfacing has installed at our clients side
> either msde or MSSQL Server products, depending on their stability. We
> have not been asked by them what they are going to install I thought,
> that msde is a client product and not a server product. IS msde a
> product which can run simitaniosly in our environment?
I'm not Greg (hi Greg :D) but, again, I do not understand the "stability"
problems...
MSDE is one of the editions of SQL Server, limited some way, but shares the
same core functionnalities and features...
MSDE is not a client product as Access, it's a "scaled down" version of a
full blown "enterprise" DBMS, with built-in limitation for database size,
concurrent workloads, and so on...
as regard as your last question,
>IS msde a
> product which can run simitaniosly in our environment?
I should say yes, but your environment is not public , and of course it
all depends on your requirements..
regards
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Rudolph,
And to add to what Andrea said, we've used it in that sort of environment
many, many times without issue.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:35pbuqF4pmdlaU1@.individual.net...
> hi Rudolph,
> rudolph wrote:
> I'm not Greg (hi Greg :D) but, again, I do not understand the "stability"
> problems...
> MSDE is one of the editions of SQL Server, limited some way, but shares
> the
> same core functionnalities and features...
> MSDE is not a client product as Access, it's a "scaled down" version of a
> full blown "enterprise" DBMS, with built-in limitation for database size,
> concurrent workloads, and so on...
> as regard as your last question,
> I should say yes, but your environment is not public , and of course it
> all depends on your requirements..
> regards
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>