DX Unified Infrastructure Management

 View Only
  • 1.  SQL Server probe time out alarms

    Posted Aug 20, 2019 07:29 AM
    We are having error like below on all the servers where we have deployed sql server probe :
    Profile SQL ECOM, failed to execute in scheduled time interval, delayed by 23 seconds SQL ECOM.delay_alarm sqlserver

    Not sure why we are seeing that and what is required to be fixed up ?

    ------------------------------
    System Analyst
    DXC Technology
    ------------------------------


  • 2.  RE: SQL Server probe time out alarms

    Posted Aug 20, 2019 07:59 AM
    In some cases this can be due to the interval you requested (it is too short)
    The probe cannot execute all sql statements (checkpoints in the time you gave to him/her.


  • 3.  RE: SQL Server probe time out alarms

    Posted Aug 20, 2019 08:08 AM
    Just want to understand which of the checkpoint it is checking from the below screen shot.


    ------------------------------
    System Analyst
    DXC Technology
    ------------------------------



  • 4.  RE: SQL Server probe time out alarms
    Best Answer

    Posted Aug 20, 2019 08:26 AM
    It is checking all profile checkpoints you activated + you ask the probe to check this every minute (check interval).
    Start by putting the "check interval" at 15 minutes and after some poll cycles check if all values/qos metrics are what you want.


  • 5.  RE: SQL Server probe time out alarms

    Posted Aug 20, 2019 11:56 AM
    ok , Thanks Luc
    I will try and get back if the problem persists  :)

    ------------------------------
    System Analyst
    DXC Technology
    ------------------------------



  • 6.  RE: SQL Server probe time out alarms

    Posted Aug 20, 2019 12:36 PM
    You may want to pick through https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?MessageKey=afa84a1b-2422-4a49-aa56-da6d30326934&CommunityKey=170eb4e5-a593-4af2-ad1d-f7655e31513b&tab=digestviewer#bmafa84a1b-2422-4a49-aa56-da6d30326934

    There is a bunch of interdependence on the various values on that config dialog.


  • 7.  RE: SQL Server probe time out alarms

    Posted Aug 21, 2019 02:46 AM
    Thanks a lot Garin, It was really much helpful.

    ------------------------------
    System Analyst
    DXC Technology
    ------------------------------