MICROSOFT SQL DESKTOP ENGINE

VisionFM StandAlone ships with Microsoft® SQL Server 2000 Desktop Engine
MSDE 2000 is a version of the SQL Server date 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 Enterpise) 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 for 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 of 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 CONCURRENCY VIOLATION statement to report how often the concurrent workload governor is activated
• The size of Desktop Engine database cannot exceed 2GB. A typical VisionFM database is 250Mb.
• 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.