Comments (4)
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.
@avalenti can you share your metrics.json
file?
SQL Server Version?
from mssql_exporter.
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.
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)
- invalid metric type "GAUGE" error for MSSQL exporter HOT 5
- invalid metric type " gauge" error for MSSQL exporter, also invalid metric type " counter" error for MSSQL exporter HOT 1
- Timeout per Query? HOT 3
- how can i get more query in prometheus HOT 2
- Return value of '1' for informational metric HOT 1
- metrics .json demo HOT 1
- Run query each X seconds
- how to get the query data correctly
- Change con prometheus 2.4
- mssql_deadlocks should be a counter
- connection timeout HOT 1
- Unable to fetch metrics which column consist "String with spaces in between"
- Collation Problem
- Customizing the label names and extracting the values for the same HOT 1
- Connection failing HOT 5
- Connect failed HOT 4
- How to expose timestamp in metrics HOT 1
- System.Globalization.Invariant and SqlClient issue HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mssql_exporter.