sqlserver

package
Version: v0.10.1 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Jan 27, 2016 License: MIT Imports: 5 Imported by: 0

README

SQL Server plugin

This sqlserver plugin provides metrics for your SQL Server instance. It currently works with SQL Server versions 2008+. Recorded metrics are lightweight and use Dynamic Management Views supplied by SQL Server:

Performance counters  : 1000+ metrics from sys.dm_os_performance_counters
Performance metrics   : special performance and ratio metrics
Wait stats 			  : wait tasks categorized from sys.dm_os_wait_stats
Memory clerk		  : memory breakdown from sys.dm_os_memory_clerks
Database size         : databases size trend from sys.dm_io_virtual_file_stats
Database IO			  : databases I/O from sys.dm_io_virtual_file_stats
Database latency	  : databases latency from sys.dm_io_virtual_file_stats
Database properties   : databases properties, state and recovery model, from sys.databases
OS Volume             : available, used and total space from sys.dm_os_volume_stats
CPU				      : cpu usage from sys.dm_os_ring_buffers

You must create a login on every instance you want to monitor, with following script:

USE master; 
GO
CREATE LOGIN [telegraf] WITH PASSWORD = N'mystrongpassword';
GO
GRANT VIEW SERVER STATE TO [telegraf]; 
GO
GRANT VIEW ANY DEFINITION TO [telegraf]; 
GO

Overview telegraf-sqlserver-0

General Activity telegraf-sqlserver-1

Memory telegraf-sqlserver-2

I/O telegraf-sqlserver-3

Disks telegraf-sqlserver-4

CPU telegraf-sqlserver-5

Full view telegraf-sqlserver-full

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type MapQuery

type MapQuery map[string]Query

MapQuery type

type Query

type Query struct {
	Script         string
	ResultByRow    bool
	OrderedColumns []string
}

Query struct

type SQLServer

type SQLServer struct {
	Servers []string
}

SQLServer struct

func (*SQLServer) Description

func (s *SQLServer) Description() string

Description return plugin description

func (*SQLServer) Gather

func (s *SQLServer) Gather(acc inputs.Accumulator) error

Gather collect data from SQL Server

func (*SQLServer) SampleConfig

func (s *SQLServer) SampleConfig() string

SampleConfig return the sample configuration

Source Files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL