Managing a Database Server
The database server enables one or more users to access a database. Each database may have one database server running against it and the server runs on the machine where the database resides.
The parameters which control a database server and which can be tuned to optimize performance are specified as part of the definition of a local database.
The MIMCONTROL functionality provides facilities for managing the operation of a database server (e.g. starting, controlled shutdown, etc.).
The MIMINFO functionality provides facilities for getting system management information from a Mimer SQL database server, such as:
- listing details for the users on the system
- monitoring performance parameters
- dumping data for trouble-shooting analysis by Mimer support personnel.
- listing SQLPOOL parameters
Operational and error messages generated by a database server are recorded in the database server log, see Database Server Log.
In a Mimer SQL system there are a number of system-wide parameters that have a major impact on the overall system performance.
The most important parameters are the bufferpool size and the number of request and background threads.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40