Commit Graph

57 Commits

Author SHA1 Message Date
Josh Soref f975b94404
Fix typos in sqlserver input (#7524) 2020-05-22 00:05:10 -07:00
denzilribeiro 5280023abe
Fix instance name resolution in performance counter query (#7526) 2020-05-20 16:55:37 -07:00
Giovanni Luisotto db0d950b3a
Add cpu query to sqlserver input (#7359) 2020-05-07 11:25:03 -07:00
Giovanni Luisotto 53c86890af
Rename measurement to sqlserver_volume_space (#7457) 2020-05-05 10:56:03 -07:00
Giovanni Luisotto 82c9f0f7f8
Trim instance tag in the sqlserver performance counters query (#7351) 2020-04-21 13:42:35 -07:00
Giovanni Luisotto c56596dec2
Sql Server - Disk Space Measurement (#7214) 2020-04-06 11:53:54 -04:00
denzilribeiro ccefc42711
Add OPTION RECOMPILE for perf reasons due to temp table (#7242) 2020-03-31 12:54:22 -07:00
Harshit Bansal a612a4d85f
Add option for explicitly including queries in sqlserver input plugin (#7150) 2020-03-16 13:46:42 -07:00
Giovanni Luisotto 20d45d651c
Fix schedulers query compatibility with pre SQL-2016 (#7144) 2020-03-16 13:36:31 -07:00
denzilribeiro 0a75dea70d
Add Database IO Tempdb per Azure DB and fix PerfmonV2 collection for on-prem (#7163) 2020-03-16 13:32:30 -07:00
Giovanni Luisotto 1601a06915
Fix several issues with DatabaseIO query in sqlserver input (#7103) 2020-03-10 12:44:54 -07:00
Giovanni Luisotto 413ca898be
Fix perf counters collection on named instances in sqlserver input (#7060) 2020-02-21 11:11:50 -08:00
denzilribeiro 1df88dd22b Add RBPEX stats collection, DBName for perfmon, proper type for resource stats (#6869) 2020-01-08 17:55:37 -08:00
Giovanni Luisotto 3d8940e69b Encode query hash fields as hex strings in sqlserver input (#6818) 2019-12-30 11:45:46 -08:00
chuckbarkertech 94fc769e0b Fix ServerProperty query stops working on Azure after failover (#6794) 2019-12-12 13:16:41 -08:00
Daniel Nelson 0e6500669a
Add missing ServerProperties query to sqlserver input docs (#6625) 2019-11-07 16:29:45 -08:00
Giovanni Luisotto ba579819a0 Add missing character replacement to sql_instance tag (#6610) 2019-11-05 11:56:48 -08:00
GeorgeJahad c26aeb871d Remove package level vars from sqlserver and mysql input plugins (#6468) 2019-10-04 12:18:34 -07:00
Mark Wilkinson - m82labs 68d11e01ab Add more performance counter metrics to sqlserver input (#6465) 2019-09-30 16:50:33 -07:00
GeorgeJahad e553341879 Update sqlserver docs for TLS connections (#6409) 2019-09-17 15:48:08 -07:00
denzilribeiro 109d1e1e15 Add support for collecting SQL Requests to identify waits and blocking (#6144) 2019-07-22 15:04:15 -07:00
denzilribeiro 329179c0ff Fix sql_instance tag with sqlserver managed instance (#6116) 2019-07-15 11:46:52 -07:00
denzilribeiro 149be55c64 Add improved support for Azure SQL Database (#6111) 2019-07-12 11:37:00 -07:00
Arno den Uijl adc32002da Fix sqlserver connection closing on error (#5897) 2019-05-22 13:13:19 -07:00
Daniel Nelson 9e0248898f
Disable results by row in azuredb query (#5467) 2019-02-25 10:54:19 -08:00
Phil Schwartz c8832a28c4 Set deadlock priority in sqlserver input (#5301) 2019-02-11 17:10:42 -08:00
Phil Schwartz 1c3acafc8f Fix arithmetic overflow in sqlserver input (#5261) 2019-01-08 14:13:14 -08:00
BoheeChoi1 cb9bacfede Add forwarded records to sqlserver input (#5177) 2018-12-27 13:18:29 -08:00
Mark Wilkinson - m82labs 503f3ce0a6 Remove storage calculation for non Azure managed instances and add server version (#5135)
- Removed the storage calculation for SQL Server instances that are NOT Azure
  Managed Instances, this reduces the time it takes to get this data on an
  instance with a lot of databases and/or database files.
- Added the SQL Server version back to the server properties query.
2018-12-13 11:42:35 -08:00
Tracy Boggiano 69f6612c2a Fix hardware_type may be truncated in sqlserver input (#4750) 2018-09-26 19:02:29 -07:00
Tracy Boggiano adf2668c1d Fix forwarded records and offline state in sqlserver input (#4730) 2018-09-21 12:18:27 -07:00
Mark Wilkinson - m82labs b43165f2d8 Improve Azure Managed Instance support + more in sqlserver input (#4642) 2018-09-11 18:47:30 -07:00
Tracy Boggiano 0785821a80 Add forwarded records to sqlserver input (#4571) 2018-08-23 16:59:21 -07:00
Mark Wilkinson - m82labs ff40da6019 Use explicit casts to avoid datatype issues (#3980) 2018-04-06 14:58:33 -07:00
Mark Wilkinson - m82labs a971ffb880 Remove host tag from Database IO v2 Query (#3953) 2018-03-30 13:22:24 -07:00
Mark Wilkinson - m82labs d7f279e3d3 Fix SQL Server 2008 compatibility (#3916)
* Fixed a bug in the performance counter query when run against SQL Server 2016 SP1-CU2. The performance counter DMV contains duplicate entries which are not handled by the query.

* Adding more stats related to workload groups.

* Adding new RG stats, removing "host" tag

* Removed workload group query

* Fixing some 2008 compat issues, removed the host field from the result set.

* Adding fixes for SQL Server 2008 compat around RG columns. Also converted perf counter query to support named instances.
2018-03-22 10:38:40 -07:00
dilshatm a6d366fb84 Fix collation difference in sqlserver input (#3786) 2018-03-07 14:16:17 -08:00
Mark Wilkinson - m82labs 42ccc9f324 Added additional SQL Server performance counters (#3770)
* Included system databases in server properties, added backup/restore throughput counter, error counters, and user settable counters.

* Added more resource governor counters.

* Added Target and Total Server Memory counters.

* Removed the c_type tag from the performance counters query, added more documentation instead.
2018-02-09 12:45:22 -08:00
Daniel Nelson 8c8c9200e7
Update sqlserver readme; enable query_version = 2 in default config
If unset, query_version is still treated as version 1 for compatibility.
2018-02-01 12:13:49 -08:00
Mark Wilkinson - m82labs 426360d61f Add new sql server output data model (#3618) 2018-02-01 11:50:26 -08:00
erayaslan a06ee58785 Use MAX() instead of SUM() for latency measurements in sqlserver (#3471) 2017-11-16 16:49:51 -08:00
Daniel Nelson 1f348037b7 Fix case sensitivity issue in sqlserver query (#3336) 2017-10-16 11:26:16 -07:00
Daniel Nelson 8e3ed96d6f Fix case sensitivity error in sqlserver input (#3287) 2017-10-02 17:15:34 -07:00
Mark Wilkinson - m82labs 1c5ebd4be3 Fix duplicate keys in perf counters sqlserver query (#3175) 2017-09-14 15:04:13 -07:00
ceseuron e2983383e4 Fixed sqlserver input to work with case sensitive server collation. (#2749)
Fixed a problem with sqlserver input where database properties are not returned by Telegraf when SQL Server has been set up with a case sensitive server-level collation.

* Added bugfix entry to CHANGELOG.md for sqlserver collation input fix.
2017-05-04 10:47:03 -07:00
Patrick Hemmer 06baf7cf78 use AddError everywhere (#2372) 2017-04-24 11:13:26 -07:00
Kebus1 734988d732 Fixed Bug 2077 SQL Server (#2212) 2017-01-13 13:47:47 +00:00
zensqlmonitor 817d696628 SQL Server plugin: Fix WaitStats issue (#1859)
Issue #1854
2016-10-06 14:21:14 +01:00
zensqlmonitor 573628dbdd Fix collation issue 2016-09-28 16:11:00 +01:00
Cameron Sparr 6dbbe65897 Remove Add() function from accumulator 2016-09-02 16:35:27 +01:00