# 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: ```SQL 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 