| Winserv - Faq - What is MSDE2000 |
| MSDE is a limited version of the Microsoft SQL Server.
In short, it is the Microsoft SQL Server 2000 database engine without
any of the fancy UI tools, and with some limitations in the database
size and the number of connections. The MSDE database is free, and
can be distributed embedded in your own applications or as a small
stand alone SQL server. It is ideal for small websites and small
businesses with less than 25 simultaneous users. The database is
limited to 2 GB of data storage space, but you can easily upgrade
it to a full Microsoft SQL Server without any limitations. Among
the choices are, a standard edition or an enterprise edition. An
MSDE database is a good and affordable starting point for any business,
organization or even home solutions. The database does not have
to be installed on the hard drive on the deployment computer, but
it could be running from a CD-ROM. |
| |
| Limitations |
There are some limitations to a MSDE database. You don’t get:
Failover clustering.
Log shipping.
Parallel DBCC.
Parallel create index.
Enhanced read ahead and scan.
Indexed views.
Federated database server.
System area network support (SAN).
Graphical DBA, and developer utilities and wizards.
Full-text search.
Analysis services.
OLAP partitions.
Partition wizard.
Linked OLAP cubes.
ROLAP dimension support.
HTTP Internet support.
Custom rollups.
Calculated Cells.
Write back to dimensions.
Very large dimension support.
Actions.
Real-time OLAP.
Distributed partition cubes.
Data mining.
English query.
|
| |
| What you get |
This is what you get:
Maximum number of processors: 2 in NT/Win2000/XP/2003, 1 in Win98/ME.
Maximum physical memory: 2 GB.
Maximum user connections: 5 before the work load governor will limit the performance.
Maximum data storage: 2 GB.
Desktop embedded or network access.
Leading SQL database performance.
It’s free. =:-)
|
| |
| [Back to Winserv] |
| |
|
