System Administration

SQL Server Enterprise Manager is a plug-in to Microsoft Management Console (MMC), the standard user interface for all Microsoft BackOffice family products. This provides consistency and usability with all other Microsoft server products.

SQL Server 7.0 provides more than 25 wizards that significantly simplify system administration. In addition, more than 100 prewritten scripts can be used to administer the database. Oracle does not offer either the wizards or the prewritten scripts. However, Oracle has many system tables that can provide the information required.

SQL Server 7.0 uses autotuning of parameters, thus reducing the number of parameters that the administrator must set to optimize the server.

SQL Server 7.0 handles memory management automatically. To increase the performance of an application in Oracle, the database administrator must alter the buffer cache and memory pool parameters in the Init.ora file. The amount of space allocated varies by system and is constrained by the amount of memory on the server and the resources required by the shared pool.