SQL Server 2000 Desktop Engine

The SQL Server version 2000 desktop engine is a run-time version of SQL Server that's used extensively by Application Center Event and Performance Logging and Application Center monitoring features. The SQL Server 2000 engine makes up the core of SQL Server technology. The following limitations and restrictions apply to the engine:

• It does not include its own user interface or tools. Users interact with the SQL Server data engine through the application in which it is embedded.
• It has a 2-GB database size limit.
• It doesn't support symmetric multiprocessing (SMP) on Microsoft Windows 95 or later.
• It is optimized for five concurrent users.
• The Online Analytical Processing (OLAP) server is not included.

This database stores and provides access to health and performance data for cluster members and the cluster as a whole. Chapter 7, "Monitoring," covers the role of this database in more detail. In Chapter 11, "Working with the Command Line Tool and Scripts," you'll see how you can use ASP scripts to access the database and build custom reports by using historical data.

NOTE

---

Installation of Application Center Event and Performance Logging is not mandatory. However, the Application Center-specific data that's collected will not be available to you if it isn't installed.