MSDE and VisionFM
Microsoft SQL Desktop Engine
VisionFM StandAlone ships with the Microsoft® SQL Server 2000 Desktop Engine
MSDE 2000 is a version of the SQL Server data engine designed for redistribution with applications. MSDE provides the same performance as the full version but does not include an interface, instead VisionFM's Database Designer application (included with VisionFM Enterprise) provides the interface for database customization and security. The MSDE version provides the same performance as the full version but is meant for small groups of users, if more than five users are logged in at the same time a workload governor will slow the database.
Functional Differences Between Desktop Engine and SQL Server
Desktop Engine implements all of the basic functionality of SQL Server 2000, as well as most of the additional services. There are, however, a few differences to keep in mind while planning your installation:
- A concurrent workload governor limits the performance of the database engine. The performance of individual Transact-SQL batches is decreased when more than five batches (data sending and retrieving from the database) are executed concurrently. When more than five batches are run concurrently, the workload governor will insert no-ops in direct proportion to the number of excess batches submitted for processing, thereby reducing system performance. Therefore the amount each batch is slowed down depends on how many batches over the five-batch limit are executing concurrently, and the amount of data retrieved by the individual batches. As more batches are executed concurrently, and as more data is retrieved by each batch, the more the governor slows down the individual batches. You can use the DBCC CONCURRENCYVIOLATION statement to report how often the concurrent workload governor is activated.
- The size of Desktop Engine databases cannot exceed 2 gigabytes (GB). A typical VisionFM database is 250 Mb.
- Desktop Engine supports symmetric multiprocessing on a maximum of two processors.
- Desktop Engine participates in replication as:
- A Subscriber in transactional replication.
- Both Subscriber and Publisher in snapshot and merge replication.
- Desktop Engine does not support SQL Mail.
- Desktop Engine is not supported on Windows® Advanced Server, Limited Edition.