DX Infrastructure Manager

Expand all | Collapse all

Alert when Qos is missing

Jump to Best Answer
  • 1.  Alert when Qos is missing

    Posted 02-07-2020 05:47 AM




    Hi ,


    Is there a way to monitor QOS continuously and send an alarm at that time when QOS is not getting created ?


    Regards

    Amar



  • 2.  RE: Alert when Qos is missing

    Posted 02-07-2020 07:55 AM

    How to determine if QOS data is being updated for all tables

    https://community.broadcom.com/communities/community-home/librarydocuments/viewdocument?DocumentKey=2cc9944f-55dd-46ca-af64-d444faf78132

    This link should help. You can adjust the query to your needs.

    Regards,
    Steve

    ------------------------------
    Support Engineer
    Broadcom
    US
    ------------------------------



  • 3.  RE: Alert when Qos is missing

    Posted 02-07-2020 08:20 AM
    Hi ,


    Is there a way to monitor QOS continuously and send an alarm at that time when QOS is not there for that particular time. Please elaborate of how to do that ?



    Regards
    Amar



  • 4.  RE: Alert when Qos is missing

    Posted 02-07-2020 08:52 AM
    You can use the sql_response probe for the connection and add the query:

    DECLARE @qos VARCHAR(255),
    @sampletime DATETIME = NULL,
    @source VARCHAR(255),
    @sql NVARCHAR(255),
    @table_id INT,
    @target VARCHAR(255),
    @v_table VARCHAR(255);

    DECLARE @qos_data TABLE (table_id INT,
    qos VARCHAR(255),
    source VARCHAR(255),
    target VARCHAR(255) );

    DECLARE CurQosList CURSOR READ_ONLY FAST_FORWARD
    FOR SELECT sqs.table_id, qos, source, target, v_table FROM S_QOS_SNAPSHOT sqs
    INNER JOIN S_QOS_DATA sqd ON sqs.table_id = sqd.table_id
    WHERE sqs.sampletime > DATEADD(hh, -24, GETDATE())
    OPEN CurQosList FETCH NEXT FROM CurQosList INTO @table_id, @qos, @source, @target, @v_table
    WHILE @@FETCH_STATUS = 0
    BEGIN SET @sql = 'SELECT TOP 1 @sampletime = sampletime FROM ' + @v_table + ' WHERE table_id = ' + CAST(@table_id AS VARCHAR(16)) + ' AND sampletime < DATEADD(hh, -24, GETDATE())';
    EXEC sp_executesql @sql, N'@sampletime DATETIME OUTPUT', @sampletime = @sampletime OUTPUT;
    IF @sampletime IS NULL BEGIN INSERT INTO @qos_data (table_id, qos, source, target) VALUES (@table_id, @qos, @source, @target);
    END SET @sampletime = NULL;
    FETCH NEXT FROM CurQosList INTO @table_id, @qos, @source, @target, @v_table END CLOSE CurQosList DEALLOCATE CurQosList SELECT * FROM @qos_data;

    Then configure the probe to alarm on row count and/or value.

    Alternatively, you can create and use a custom checkpoint within the sqlserver probe.

    Steve


    ------------------------------
    Support Engineer
    Broadcom
    US
    ------------------------------



  • 5.  RE: Alert when Qos is missing

    Posted 02-08-2020 05:29 AM
    In attachment an older probe: qos_watcher (that still works fine under 9.20) that monitors all or specific qos metrics and generates alarms when thresholds are breached.

    Attachment(s)

    pdf
    Readme.pdf   71K 1 version
    zip
    qos_watcher_1.5.zip   72K 1 version


  • 6.  RE: Alert when Qos is missing

    Posted 02-10-2020 01:44 AM

    Hi Luc Christiaens ,

    Zip file I am unable to open .

    And also when I am checking for that qos_watcher I did not find it in nimsoft downloads / archive from support.nimsoft.com

    Regards'
    AMar



  • 7.  RE: Alert when Qos is missing

    Posted 02-10-2020 02:00 AM
    This is an existing "custom" probe.
    A probe zip file cannot be opened, you need to import it n your archive.


  • 8.  RE: Alert when Qos is missing

    Posted 02-10-2020 02:17 AM
    Hi Luc ,

    To import this , I am unable to open it in my company as it is blocking this ZIP .

    Regards
    AMar


  • 9.  RE: Alert when Qos is missing

    Posted 02-18-2020 12:01 AM
    Hi all ,

    I am unable to download this qos_watcher Zip file that you have shared here as my company norms is not accepting this to open .

    Please share the  link where I can download this probe .


    Regards
    AMar


  • 10.  RE: Alert when Qos is missing

    Posted 02-18-2020 05:05 AM
    Hi Luc ,

    I have deployed this probe on a robot but I cannot see this probe there .


    Regards
    AMar


  • 11.  RE: Alert when Qos is missing

    Posted 02-18-2020 05:48 AM
    Edited by amar kondraju 02-18-2020 05:54 AM
    Hi Luc ,

    I have deployed this probe on a robot but I cannot see this probe there . We are using CA UIM 9.0.2 in our production .

    You have given this configuration and where should I provide this ?

    <setup>
    loglevel = 1
    logfile = qos_watcher.log
    interval = 30
    <watchers>
    <0>
    description = any QoS
    delay = 60
    </0>
    <1>
    description = any QoS from primary Hub
    robot = centos64int123
    delay = 90
    </1>
    <2>
    description = cdm CPU_USAGE from portal
    robot = centos64int125
    prid = cdm
    qos = CPU_USAGE
    delay = 120
    </2>
    <3>
    description = portal end-user experience
    prid = e2e_appmon
    target = Portal.*
    delay = 180
    </3>
    </watchers>
    </setup>


  • 12.  RE: Alert when Qos is missing

    Posted 02-18-2020 06:16 AM
    Just downloaded the probe, imported it in my archive and deployed it on my hub.
    This creates: \Nimsoft\probes\system\qos_watcher
    - Probably you will need to edit the installe dprobe to point to the perl path
    - Edit the cfg file to set a correct hostname
    - Start the probe
    - you will now receive every interval the alarm: hello from qos_watcher


  • 13.  RE: Alert when Qos is missing

    Posted 02-18-2020 06:39 AM
    Hi ,

    Please share me the probe perl for windows .

    Regards
    AMar


  • 14.  RE: Alert when Qos is missing

    Posted 02-18-2020 06:42 AM
    Hi ,

    I did not find the perl probe from support .nimsoft .com .




  • 15.  RE: Alert when Qos is missing

    Posted 02-18-2020 07:17 AM

    I am getting this error . Probably you will need to edit the installed probe to point to the perl path - How to do this ?

    Controller: Probe 'qos_watcher' FAILED to start (command = perl.exe qos_watcher.pl) error = (2) The system cannot find the file specified.


  • 16.  RE: Alert when Qos is missing

    Posted 02-18-2020 08:36 AM

    i have made both perl and qos_watcher to stay in same path but still the same error :

    Controller: Probe 'qos_watcher' FAILED to start (command = perl.exe qos_watcher.pl) error = (2) The system cannot find the file specified.

    Regards
    AMar



  • 17.  RE: Alert when Qos is missing

    Posted 02-18-2020 09:01 AM
    I am using the below qos_watcher.cfx  and qos_watcher.cfg  as well .

    <setup>
    loglevel = 1
    logfile = qos_watcher.log
    interval = 30
    <watchers>
    <0>
    description = any QoS
    delay = 60
    </0>
    <1>
    description = any QoS from primary hub name
    robot = hub robot
    delay = 90
    </1>
    <2>
    description = cdm CPU_USAGE
    robot = hub robot name
    prid = cdm
    qos = CPU_USAGE
    delay = 120
    </2>
    </watchers>
    </setup>



    i have made both perl and qos_watcher to stay in same path but still the same error :

    Controller: Probe 'qos_watcher' FAILED to start (command = perl.exe qos_watcher.pl) error = (2) The system cannot find the file specified.


    Regards
    AMar


  • 18.  RE: Alert when Qos is missing

    Posted 02-18-2020 09:20 AM
    Hi ,

    The perl is installed in this path as I have verified this in environment section of controller in the robot . So , I have copied qos_watcher also to this same path but still qos_watcher probe is not up and is showing red .

    qos_watcher Log : Controller: Probe 'qos_watcher' FAILED to start (command = perl.exe qos_watcher.pl) error = (2) The system cannot find the file specified.





    Regards
    AMar







  • 19.  RE: Alert when Qos is missing

    Posted 02-18-2020 10:24 AM
    To update the probe execution path:
    - in IM right click on the qos_watcher probe and select edit
    qos_watcher_edit- In the command field set the full path to perl.exe



  • 20.  RE: Alert when Qos is missing

    Posted 02-19-2020 12:26 AM


    Hi Luc ,

    I have downloaded this perl sdk - Is this the same one that you are talking about ?



  • 21.  RE: Alert when Qos is missing

    Posted 02-19-2020 12:40 AM


    Installation :

    Ensure SDK_Perl 5.04 or greater is deployed to the robot that will run cmd.
    Ensure ActiveState Perl version 5.14 is installed on the robot system if it is a Windows robot - My hub is a windows machine and may I know what is this ActiveState perl ?

    Regards
    AMar


  • 22.  RE: Alert when Qos is missing

    Posted 02-19-2020 12:46 AM
    Kindly share me this active state perl here to download .


    Regards
    AMar


  • 23.  RE: Alert when Qos is missing

    Posted 02-19-2020 02:43 AM
    Hi ,

     I did not get this ActiveState Perl version 5.14 . Please share me that probe .

    Regards
    AMar



  • 24.  RE: Alert when Qos is missing

    Posted 02-20-2020 12:03 AM
    Hi Luc ,

    Installation :

    Ensure SDK_Perl 5.04 or greater is deployed to the robot that will run cmd.
    Ensure ActiveState Perl version 5.14 is installed on the robot system if it is a Windows robot - My hub is a windows machine and may I know what is this ActiveState perl ? From where I can dowload this active state perl ? Kindly let me know as I am unable to get this .


    Regards
    AMar


  • 25.  RE: Alert when Qos is missing

    Posted 02-20-2020 01:48 AM
    Hi ,

    I have downloaded the perl and then edited the correct path in qos_watcher and after that changes the cfg file of qos_watcher to correct hostname of hub and then trid to activate the probe . But i am getting below error max restarts .

    Max. restarts reached for probe 'qos_watcher' (command = C:\perl\bin\perl.exe)

    Regards
    AMar


  • 26.  RE: Alert when Qos is missing
    Best Answer

    Posted 02-20-2020 03:45 AM
    If a custom probe fails to start, you always can try to:
    - open a command prompt
    - do a "cd" to the directory of the probe
    - start the probe manually, it will is most cases indicates where/what the error could be
       => c:\perl\bin\perl qos_watcher.pl


  • 27.  RE: Alert when Qos is missing

    Posted 02-20-2020 08:24 AM

    The below one is not working .  I have one doubt here - perl.exe  is there in this path c:\perl\bin and qos_watcher.pl is there in D:Programfiles/Nimsoft/probes/system .

     in command prompt I have tried below one and it is not working .

    cd c:\perl\bin\perl qos_watcher.pl

    Regards
    Amar



  • 28.  RE: Alert when Qos is missing

    Posted 02-20-2020 08:34 AM
    Hi ,

    Please let me know what exactly need to be done to make this probe up .


    regards
    AMAR


  • 29.  RE: Alert when Qos is missing

    Posted 02-21-2020 04:46 AM
    Hi Luc ,

    Awaiting your response !!!

    Regards
    Amar


  • 30.  RE: Alert when Qos is missing

    Posted 02-21-2020 04:54 AM
    There is nothing to add to my previous update, read it again


  • 31.  RE: Alert when Qos is missing

    Posted 02-21-2020 05:01 AM
    Edited by amar kondraju 02-21-2020 05:26 AM
    Hi ,

    Please share me webex session .

    Actually the probe is not up and so I need to make that up and fine  .


    Regards
    AMar