My only DCAM
(which is running Windows 2000 SP3 Server, MOM SP1 and SQL 2000 SP2) is
running extremely slowly. I’ve noticed that the SQLSRV process is taking up
more than 50% of the CPU’s time
Within a month I got an alert that my MOM database had under 40% of free
space so I have increased the size of the database to 20 GB so now I have
85% free space but I got loads errors from MOM such as the one below:
---------------------------------
Severity: Error
Status: New
Source: OnePoint Operations
Name: DB insertion error
Description: Unrecoverable database errors occurred during event or alert
insertion. Some data may have been lost. The system will attempt to continue
processing events and alerts.
Details: Error information has 1 rows and 6 columns.Err 0: op = 14, HRESULT
= 80004005, Description = Unspecified error, SQL native = 0, SQL description
= , Method name = SampledNumericDataSourceUpdateLastSampledNumericDataFound
1 errors, 0 were collisions.
Domain:
Agent: MOM
Time: 07/29/2003 08:23:21
--------------------------------------
Also:
--------------------------------------
Severity: Warning
Status: New
Source: MSSQLSERVER
Name: SQL Server started in single user mode. Updates allowed to system
catalogs.
Description: 17658:
SQL Server started in single user mode. Updates allowed to system catalogs.
Domain:
Agent:MOM
Time: 07/29/2003 08:23:19
-------------------------------
And finally:
---------------------------
Severity: Warning
Status: New
Source: OnePoint Operations
Name: Consolidator queue is full
Description: The Consolidator's incoming communications queue is full. The
Consolidator will now begin indicating to agents that it is busy until
sufficient space to process new events and alerts becomes available in the
queue.
Domain:
Agent: MOM
Time: 07/29/2003 09:56:37
------------------
From the microsoft.public.mom
newsgroup
You’re problem seems to be the fact that you have SQL running in Single User
Mode. You should be able to change this by right clicking the database in
SQL Enterprise Manager:
-
Right click the database and select 'Properties'
-
Click the 'Options'
Tab
-
Clear the 'Restrict
access' check box
-
Click 'OK'
|
