none
Monitoring SQL; Database Status RRS feed

  • Question

  • Hi folks

    We are monitoring a 3rd party software, who is running with a local SQL-Database.

    this 3rd party software has set up the SQL-database-Status to "Normal, Autoclosed". so the database status - monitor in scom is flipping between "warning" and "healthy" all 5 minutes.

    the database status is given from the application, we can't change the status to "normal". are there any tweaks in the monitor to prevent this "flipping around" - thing?

    we can't override the monitor-health-status-settings. the only solution seems to disabling the whole monitor?

    cheers, sandro

    

    Tuesday, October 8, 2019 6:35 AM

All replies

  • Hi Sandro,

    You could higher the intervals for the database status monitor for this specific database:

    Other than that I don't think there's much you can do really, if a database is accessed frequently, the autoclose should be set to off for a SQL database, this is the best practice.

    You might want to check with your third party vendor.

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    Tuesday, October 8, 2019 6:53 AM
  • Hi Sandro,

     

    Agree with Leon, for our issue, we suggest to contact third party vendor to confirm if the Auto_Close can set to off. As when AUTO_CLOSE is set ON, this option can cause performance degradation on frequently accessed databases because of the increased overhead of opening and closing the database after each connection. AUTO_CLOSE also flushes the procedure cache after each connection. If the option is unable to set off, then I suggest to stop the availability monitor for the affected database.

     

    Hope it can help.

     

    Best regards.

    Crystal


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Tuesday, October 8, 2019 7:20 AM
  • Hi Sandro,

    How's everything going? Is there any update on our issue? If yes, please let us know.

    Thanks and have a nice day!

    Best regards.

    Crystal


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Thursday, October 10, 2019 9:42 AM
  • Hi

     

    Long time not heard from you. Here, please let me make a summary for our issue:

     

    Issue Definition:

    ===============================

    Monitoring a 3rd party software, who is running with a local SQL-Database. this 3rd party software has set up the SQL-database-Status to "Normal, Autoclosed". so the database status - monitor in SCOM is flipping between "warning" and "healthy" all 5 minutes.

     

    Suggestions provided by all:

    ==============================

    1. Higher the intervals for the database status monitor for this specific database:.

    2. We suggest to contact third party vendor to confirm if the Auto_Close can set to off. As when AUTO_CLOSE is set ON, this option can cause performance degradation on frequently accessed databases because of the increased overhead of opening and closing the database after each connection. AUTO_CLOSE also flushes the procedure cache after each connection. If the option is unable to set off, then I suggest to stop the availability monitor for the affected database.

     

    Thanks for posting in our forum. Have a nice day!

     

    Best regards.

    Crystal


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Tuesday, October 15, 2019 3:25 AM
  • Hi Sandro,

    did Leon and Crystal answer your quesion? We would appreciate your feedback and thnaks in advance for that!

    Regards,


    (Please take a moment to "Vote as Helpful" and/or "Mark as Answer" where applicable. This helps the community, keeps the forums tidy, and recognizes useful contributions. Thanks!) Blog: https://blog.pohn.ch/ Twitter: @StoyanChalakov

    Wednesday, October 23, 2019 8:09 AM
    Moderator