Possible SQL 2000 Performance Issue

We have a SQL 2000 SP3 Server hosting the MOM 2000 application. We are
running the MSSQLSERVER service and SQLSERVERAGENT service using a Domain
service account.
Our audit level is set to All - this is in accordance with the customer's
requirements.
The application log is constantly being written to with mssqlserver events -
service account successful logon - we would expect this as we have the full
auditing enabled.
However, the MOM application is reporting the following is part of an error
in the application log;
"Not enough storage is available to process this command"
The server has 2GB RAM and the Sqlservr process runs at about 1.5Gb of this
- is it likely to be the amount of auditing that is causing the error or not
enough RAM or combination of the two ?Any problem observed in the SQL server error log? Is ounds more like you are
running low/out of disk space.
"georgejuggins" wrote:
> We have a SQL 2000 SP3 Server hosting the MOM 2000 application. We are
> running the MSSQLSERVER service and SQLSERVERAGENT service using a Domain
> service account.
> Our audit level is set to All - this is in accordance with the customer's
> requirements.
> The application log is constantly being written to with mssqlserver events -
> service account successful logon - we would expect this as we have the full
> auditing enabled.
> However, the MOM application is reporting the following is part of an error
> in the application log;
> "Not enough storage is available to process this command"
> The server has 2GB RAM and the Sqlservr process runs at about 1.5Gb of this
> - is it likely to be the amount of auditing that is causing the error or not
> enough RAM or combination of the two ?
>