Commit Graph
12 Commits
Author SHA1 Message Date
Mark Wilkinson - m82labs ff40da6019 Use explicit casts to avoid datatype issues (#3980) 2018-04-06 14:58:33 -07:00
Mark Wilkinson - m82labs cbaf8481c9 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 952b6763ff 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
Mark Wilkinson - m82labs cce1601a54 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
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
Mark Wilkinson - m82labs e14cf49f63 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
Mark Wilkinson - m82labs 426360d61f Add new sql server output data model (#3618) 2018-02-01 11:50:26 -08:00
Mark Wilkinson - m82labs 43c092d600 Add new sql server output data model (#3618) 2018-02-01 11:50:26 -08:00
Mark Wilkinson - m82labs 1c5ebd4be3 Fix duplicate keys in perf counters sqlserver query (#3175) 2017-09-14 15:04:13 -07:00
Mark Wilkinson - m82labs 53cb9ffb31 Fix duplicate keys in perf counters sqlserver query (#3175) 2017-09-14 15:04:13 -07:00