Giter Club home page Giter Club logo

Comments (4)

avalenti avatar avalenti commented on September 24, 2024

When I view the http://localhost/metrics URL, it looks like this:

# TYPE mssql_up GAUGE
mssql_up 0
# HELP mssql_timeouts Number of queries timing out.
# TYPE mssql_timeouts GAUGE
mssql_timeouts 0
# HELP mssql_exceptions Number of queries throwing exceptions.
# TYPE mssql_exceptions GAUGE
mssql_exceptions 3
# HELP mssql_process_status Counts the number of processes per status
# TYPE mssql_process_status GAUGE
# HELP mssql_deadlocks mssql_deadlocks
# TYPE mssql_deadlocks GAUGE
mssql_deadlocks 0```

So the "GAUGE"s are in all caps, while the example that you show on the main page for the project shows them in all lowercase.   How can I change that or how did it get that way?

from mssql_exporter.

Mario-Hofstaetter avatar Mario-Hofstaetter commented on September 24, 2024

@avalenti can you share your metrics.json file?
SQL Server Version?

from mssql_exporter.

avalenti avatar avalenti commented on September 24, 2024

The SQL version is 13.0.5698.0 (2016)

The metrics.json is:
{ "Queries": [ { "Name": "mssql_process_status", "Query": "SELECT status, COUNT(*) count FROM sys.sysprocesses GROUP BY status", "Description": "Counts the number of processes per status", "Usage": "GaugesWithLabels", "Columns": [ { "Name": "status", "Label": "status", "Usage": "GaugeLabel", "Order": 0 }, { "Name": "count", "Label": "count", "Usage": "Gauge" } ] }, { "Name": "mssql_deadlocks", "Query": "SELECT cntr_value FROM sys.dm_os_performance_counters where counter_name = 'Number of Deadlocks/sec' AND instance_name = '_Total'", "Description": "Number of lock requests per second that resulted in a deadlock since last restart", "Columns": [ { "Name": "cntr_value", "Label": "mssql_deadlocks", "Usage": "Gauge", "DefaultValue": 0 } ] } ], "MillisecondTimeout": 4000 }

from mssql_exporter.

Mario-Hofstaetter avatar Mario-Hofstaetter commented on September 24, 2024

This gives me gauge in lowercases:

# HELP mssql_deadlocks mssql_deadlocks
# TYPE mssql_deadlocks gauge
mssql_deadlocks 0
# HELP mssql_exceptions Number of queries throwing exceptions.
# TYPE mssql_exceptions gauge
mssql_exceptions 0
# HELP mssql_process_status Counts the number of processes per status
# TYPE mssql_process_status gauge
mssql_process_status{status="sleeping"} 38
mssql_process_status{status="background"} 24
mssql_process_status{status="runnable"} 2
# HELP mssql_up mssql_up
# TYPE mssql_up gauge
mssql_up 1
# HELP mssql_timeouts Number of queries timing out.
# TYPE mssql_timeouts gauge
mssql_timeouts 0

Running mssql_exporter v0.4.7 with .NET Core 3.1.201 with Microsoft SQL Server 2019 (RTM-GDR) (KB4517790) - 15.0.2070.41 (X64) Oct 28 2019 19:56:59 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 18363: ) (Hypervisor)

Do you use the latest version?
Googling the issue brougth up this:
prometheus-net/prometheus-net#96
Which should be long fixed.

from mssql_exporter.

Related Issues (19)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.