Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feature Request - Make Invoke-IcingaCheckMSSQLPerfCounter usable with Raw Value Performance Counters #53

Open
audiocoach opened this issue Jan 30, 2024 · 0 comments

Comments

@audiocoach
Copy link

audiocoach commented Jan 30, 2024

There are a lot sql performance counters which are displayed in raw values by default. For example Batch Requests/sec. If you query them via Invoke-IcingaCheckMSSQLPerfCounter which infact uses the follwoing sql query the output is a raw value

SELECT
    RTRIM(object_name) as object_name,
    RTRIM(counter_name) as counter_name,
    RTRIM(instance_name) as instance_name,
    RTRIM(cntr_value) as cntr_value,
    RTRIM(cntr_type) as cntr_type
        FROM sys.dm_os_performance_counters
WHERE (object_name LIKE '%:SQL Statistics%' AND counter_name = 'Batch Requests/sec');

It would be greate to implement some logic to get the cooked value for those performance counters. Maybe it is possible to fetch the cntr_type and if it is 272696576 (=PERF_COUNTER_BULK_COUNT) calculate the cooked value.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant