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
General Activity
Memory
I/O
Disks
CPU
Full view
Documentation ¶
Index ¶
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
This section is empty.
Types ¶
type SQLServer ¶
type SQLServer struct {
Servers []string
}
SQLServer struct
func (*SQLServer) Description ¶
Description return plugin description
func (*SQLServer) Gather ¶
func (s *SQLServer) Gather(acc inputs.Accumulator) error
Gather collect data from SQL Server
func (*SQLServer) SampleConfig ¶
SampleConfig return the sample configuration
Click to show internal directories.
Click to hide internal directories.