Wednesday, March 7, 2012

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 ?
>

No comments:

Post a Comment