How do I monitor SQL Data File Space using SCOM?

Pauciloquent 71 Reputation points
2020-09-01T11:25:04.51+00:00

Hi,

I am running SCOM 2016 and SQL 2017. Recently, I observed that SQL reserves the DB space while Indexing; hence, SQL run out of DB space. I have already gone through the following post and Kevin's article regarding DB space monitoring:

https://social.technet.microsoft.com/Forums/en-US/2c859ae0-c4fa-4301-8cf4-1cce70fe6fd4/sql-database-size-monitoring-using-scom?forum=operationsmanagerauthoring

https://kevinholman.com/2016/04/03/how-sql-database-free-space-monitoring-works-in-the-sql-management-pack/

So, is it still the case? Do I need to create two custom monitors for Warning and Error alerts?

Operations Manager
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,412 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,629 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. SChalakov 10,261 Reputation points MVP
    2020-09-02T07:27:57.523+00:00

    Hi @Paulciloquent,

    I think you should ignore those for now and check the updated situation (MP). Both the article of Kevin and the post of Graham are referring to the SQL free Space Monitoring, defined within the old management pack. Now there is a new MP, which has been re-written:

    Microsoft System Center Management Pack for SQL Server

    Please go through the guide and check what it exactly mentions.

    One more thing - it si recommended to create "Index Rebuild" Job, so that the Indexes can get rebuild overnight:

    What SQL maintenance should I perform on my SCOM 2016 databases?

    This will also be interesting to you:

    System Center Operations Manager (SCOM) Management Group Performance Optimizations

    and

    Possible increased unused disk space when running SCOM 2016 on SQL2016

    Hope I was able to help.

    ----------

    (If the reply was helpful please don't forget to upvote or accept as answer, thank you)
    Best regards,
    Stoyan

    1 person found this answer helpful.
    0 comments
  2. Crystal-MSFT 42,466 Reputation points Microsoft Vendor
    2020-09-02T03:22:13.15+00:00

    Based on my research, If a monitor sent an alert when the state changed to warning, it will only send a second alert when the stage changes from warning to critical if the first alert has been closed. If the alert that was sent when the state changed to warning remains open, no alert will be sent when the state changes from warning to critical. We can see more details in the following link:
    https://learn.microsoft.com/en-us/system-center/scom/manage-alert-generation-overview?view=sc-om-2019

    In above situation, I think we can consider Graham's suggestion in the link you provided to create two custom monitors for this. Or we can look into the affected SQL Data File when we see the warning and increase the space in advance.

    Hope it can help.

    If the response is helpful, please click "Accept Answer" and upvote it.