Configuring the Database Server

The Management group of settings located on the Management tab of the Database Monitoring and Maintenance snap-in allows you to change passwords for existing Microsoft SQL Server users and set Microsoft SQL Server memory usage.

To change the user password:

1. Click Change User Password.
2. Specify a new password in the “Change user password” window.

To modify the memory usage settings for Microsoft SQL Server:

1. Click Server Memory Usage.
2. Specify memory usage settings in the “Set SQL Server memory usage” window.

If dynamic usage is set, the database server will dynamically determine how much memory to allocate based on how much memory the operating system and other applications are currently using. The “Minimum” configuration option is used to ensure that the database server does not release memory below this value. The “Maximum” configuration option is used to specify the maximum amount of memory the database server can allocate when it starts and while it runs. Clicking on “Use a fixed memory size” will fix the amount of memory available to the database server.