Share via

Receiving Ops manager Data base having low space alerts in SCOM

shankar431 476 Reputation points
2021-10-27T16:19:06.05+00:00

Hi All,

We are getting below alerts in SCOM related to Ops manager Data base having low space.

.Ops DB Free Space Low
.MSSQL on Windows: Could not allocate space for object in database because the Filegroup is full
.OperationsManager - MSSQL on Windows: Database ROWS Data is Out of Space.

In our environemnt
400s ervers
100 network devicces.

How ever tHis got filled up in 5 months,even though we have enough space in DB (90GB)
Can any one suggest any type of cleanup or groooming ?

Regards,
Ravi shankar

System Center Operations Manager
System Center Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,608 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. System Center guy 691 Reputation points
    2021-10-28T05:50:34.683+00:00
    1. Executed Large Table Query from link https://kevinholman.com/2016/11/11/scom-sql-queries/ and found which table consume a large space
    2. may try to use Reindex the database
      roger
    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.