Wednesday 20 April 2011

ASE : How to control Sybase process on OS level

In Sun Solaris 9 and newer versin, there is new feature that can be used for controlling resource usage for Unix process. It's defined in /etc/project. A project is a grouping of processes that are subject to a set of constraints.For example, we could limit a project to how many processes it could have, or how large of a file it could create.

The project file contains a series of one-line entries, one for each configured project. Each line takes the following form:
project-name:project-id:comment:user-list:group-list:attributes

Whith this feature, we can limit cpu/space/file size etc of Sybase processes. This is especially useful for the powerful server with multiple Sybase instances running. It can prevent one screwed process from taking over the whole box.

No comments:

Post a Comment