Alert when Qos is missing

[amar kondraju]

Hi ,

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

Regards

Amar

[Stephen Danseglio]

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
------------------------------

[amar kondraju]

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

[Stephen Danseglio]

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
------------------------------

[Luc Christiaens]

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)

qos_watcher_cfx_sample.txt   615 B 1 version

Readme.pdf   71 KB 1 version

qos_watcher_1.5.zip   72 KB 1 version

[amar kondraju]

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

[Luc Christiaens]

This is an existing "custom" probe.
A probe zip file cannot be opened, you need to import it n your archive.

[amar kondraju]

Hi Luc ,

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

Regards
AMar

[amar kondraju]

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

[amar kondraju]

Hi Luc ,

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


Regards
AMar

[amar kondraju]

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>

[Luc Christiaens]

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

[amar kondraju]

Hi ,

Please share me the probe perl for windows .

Regards
AMar

[amar kondraju]

Hi ,

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

[amar kondraju]

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.

[amar kondraju]

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

[amar kondraju]

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

[amar kondraju]

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

[Luc Christiaens]

To update the probe execution path:
- in IM right click on the qos_watcher probe and select edit

- In the command field set the full path to perl.exe

[amar kondraju]

Hi Luc ,

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

[amar kondraju]

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

[amar kondraju]

Kindly share me this active state perl here to download .


Regards
AMar

[amar kondraju]

Hi ,

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

Regards
AMar

[amar kondraju]

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

[amar kondraju]

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

[Luc Christiaens]

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

[amar kondraju]

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

[amar kondraju]

Hi ,   

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


regards
AMAR

[amar kondraju]

Hi Luc ,

Awaiting your response !!!

Regards
Amar

[Luc Christiaens]

There is nothing to add to my previous update, read it again

[amar kondraju]

Hi ,

Please share me webex session . 

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


Regards
AMar