MS SQL Server - Possible SQL 2000 Performance Issue

Author

Possible SQL 2000 Performance Issue

georgejuggins

2006-02-06, 7:23 am

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 ?

Sassan Karai

2006-02-06, 11:23 am

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

Sponsored Links