processes blocked - mssql server wizard

[sneha.irali]

Hi Team,

We have a requirement to enable the processes blocked parameter for monitoring.

I did setup the same for monitoring, but my query is while I was using the wizard to enable the parameter and set the threshold it shows the value as ms, however when i completed the config and checked the service status it shows the o/p in kb.

I have attached all the SS in the attachment.

Threshold requested by client is as below, please helping in setting this up rightly.

Warning: 10 mins
Critical: 20 mins

[ssax]

Looks like a couple bugs, thanks for reporting this!

Please edit this file:

Code: Select all

/usr/local/nagios/libexec/check_mssql_server.php

Change this (around line 693):

Code: Select all

            'stdout' => 'Processes blocked is @result KB',

To this:

Code: Select all

            'stdout' => 'Processes blocked is @result',

Since the Processes blocked sysperfinfo counter is just a value of blocked processes the wizard would need to be updated to remove the ms.

[sneha.irali]

So basically, will this metric return me the number of processes that are blocked...?

[sneha.irali]

So basically, will this metric return me the number of processes that are blocked...? ( count only) - correct me if my understanding is wrong

How will I pass the threshold for this - can you please help me with it.

Because i was under the assumption that it was monitoring the period of processes blocked ( how long were the processes blocked).

[ssax]

This says it's the number of currently blocked processes:

https://docs.microsoft.com/en-us/sql/re ... rver-ver15

You can set the thresholds to anything, then wait for a few checks to come through to determine what it's currently at and that cause give you your estimated threshold range to use for the thresholds for what the system currently shows. Then go modify them in Configure > Core Config Manager Services to adjust the thresholds.

[sneha.irali]

as per the instruction I did do the changes however I still see ms showing up on the console.

Processes Blocked
Monitor the number of currently blocked processes.
Warning Threshold
0
ms Critical Threshold
3
ms

[ssax]

That's just in the wizard, correct?

If you go to Admin > Manage Config Wizards, what version is listed next to the MSSQL Server wizard? (mine is 2.0.4 and it doesn't show ms in the wizard)

You can also check for and install updates for the wizards from that page.

[sneha.irali]

Wizard version is : 2.0.3

Also I do not have internet on this server, if at all i Have to update wizard then how do i do it offiline.

[ssax]

You can upload the attached MSSQL Server 2.0.4 config wizard in Admin > Manage Config Wizards by clicking Browse, selecting the zip file, and then clicking the Upload & Install button.

configwizard-mssql_server.zip