> sqlserver_database_io,database_name=Maintanance,file_type=LOG,host=HOST_Name,logical_filename=Maintanance_log,physical_filename=G:\MSSQL\Data\Maintanance_log.ldf,sql_instance=HOST_Name read_bytes=1007616i,read_latency_ms=71i,reads=7i,write_bytes=14336i,write_latency_ms=13i,writes=5i 1573804186000000000
> sqlserver_schedulers,cpu_id=5,database_name=master,host=HOST_Name,scheduler_id=5,sql_instance=HOST_Name active_workers_count=6i,context_switches_count=36905696i,current_tasks_count=6i,current_workers_count=10i,is_idle=false,is_online=true,load_factor=9i,pending_disk_io_count=0i,preemptive_switches_count=10789833i,runnable_tasks_count=1i,total_cpu_usage_ms=0i,total_scheduler_delay_ms=393296i,work_queue_count=0i,yield_count=121106235i 1573804186000000000
> sqlserver_requests,command=SELECT,database_name=master,host=HOST_Name,host_name=HOST_Name,program_name=telegraf,session_db_name=master,sql_instance=HOST_Name,statement_text=SELECT\n'sqlserver_memory_clerks'\ As\ [measurement]\,\nREPLACE(@@SERVERNAME\,'\'\,':')\ AS\ [sql_instance]\,\nDB_NAME()\ as\ [database_name]\,\nISNULL(clerk_names.name\,mc.type)\ AS\ clerk_type\,\nSUM(mc.pages_kb)\ AS\ size_kb\nFROM\nsys.dm_os_memory_clerks\ AS\ mc\ WITH\ (NOLOCK)\nLEFT\ OUTER\ JOIN\ (\ VALUES\n('CACHESTORE_BROKERDSH'\,'Service\ Broker\ Dialog\ Security\ Header\ Cache')\,\n('CACHESTORE_BROKERKEK'\,'Service\ Broker\ Key\ Exchange\ Key\ Cache')\,\n('CACHESTORE_BROKERREADONLY'\,'Service\ Broker\ (Read-Only)')\,\n('CACHESTORE_BROKERRSB'\,'Service\ Broker\ Null\ Remote\ Service\ Binding\ Cache')\,\n('CACHESTORE_BROKERTBLACS'\,'Broker\ dormant\ rowsets')\,\n('CACHESTORE_BROKERTO'\,'Service\ Broker\ Transmission\ Object\ Cache')\,\n('CACHESTORE_BROKERUSERCERTLOOKUP'\,'Service\ Broker\ user\ certificates\ lookup\ result\ cache')\,\n('CACHESTORE_CLRPROC'\,'CLR\ Procedure\ Cache')\,\n('CACHESTORE_CLRUDTINFO'\,'CLR\ UDT\ Info')\,\n('CACHESTORE_COLUMNSTOREOBJECTPOOL'\,'Column\ Store\ Object\ Pool')\,\n('CACHESTORE_CONVPRI'\,'Conversation\ Priority\ Cache')\,\n('CACHESTORE_EVENTS'\,'Event\ Notification\ Cache')\,\n('CACHESTORE_FULLTEXTSTOPLIST'\,'Full\ Text\ Stoplist\ Cache')\,\n('CACHESTORE_NOTIF'\,'Notification\ Store')\,\n('CACHESTORE_OBJCP'\,'Object\ Plans')\,\n('CACHESTORE_PHDR'\,'Bound\ Trees')\,\n('CACHESTORE_SEARCHPROPERTYLIST'\,'Search\ Property\ List\ Cache')\,\n('CACHESTORE_SEHOBTCOLUMNATTRIBUTE'\,'SE\ Shared\ Column\ Metadata\ Cache')\,\n('CACHESTORE_SQLCP'\,'SQL\ Plans')\,\n('CACHESTORE_STACKFRAMES'\,'SOS_StackFramesStore')\,\n('CACHESTORE_SYSTEMROWSET'\,'System\ Rowset\ Store')\,\n('CACHESTORE_TEMPTABLES'\,'Temporary\ Tables\ &\ Table\ Variables')\,\n('CACHESTORE_VIEWDEFINITIONS'\,'View\ Definition\ Cache')\,\n('CACHESTORE_XML_SELECTIVE_DG'\,'XML\ DB\ Cache\ (Selective)')\,\n('CACHESTORE_XMLDBATTRIBUTE'\,'XML\ DB\ Cache\ (Attribute)')\,\n('CACHESTORE_XMLDBELEMENT'\,'XML\ DB\ Cache\ (Element)')\,\n('CACHESTORE_XMLDBTYPE'\,'XML\ DB\ Cache\ (Type)')\,\n('CACHESTORE_XPROC'\,'Extended\ Stored\ Procedures')\,\n('MEMORYCLERK_FILETABLE'\,'Memory\ Clerk\ (File\ Table)')\,\n('MEMORYCLERK_FSCHUNKER'\,'Memory\ Clerk\ (FS\ Chunker)')\,\n('MEMORYCLERK_FULLTEXT'\,'Full\ Text')\,\n('MEMORYCLERK_FULLTEXT_SHMEM'\,'Full-text\ IG')\,\n('MEMORYCLERK_HADR'\,'HADR')\,\n('MEMORYCLERK_HOST'\,'Host')\,\n('MEMORYCLERK_LANGSVC'\,'Language\ Service')\,\n('MEMORYCLERK_LWC'\,'Light\ Weight\ Cache')\,\n('MEMORYCLERK_QSRANGEPREFETCH'\,'QS\ Range\ Prefetch')\,\n('MEMORYCLERK_SERIALIZATION'\,'Serialization')\,\n('MEMORYCLERK_SNI'\,'SNI')\,\n('MEMORYCLERK_SOSMEMMANAGER'\,'SOS\ Memory\ Manager')\,\n('MEMORYCLERK_SOSNODE'\,'SOS\ Node')\,\n('MEMORYCLERK_SOSOS'\,'SOS\ Memory\ Clerk')\,\n('MEMORYCLERK_SQLBUFFERPOOL'\,'Buffer\ Pool')\,\n('MEMORYCLERK_SQLCLR'\,'CLR')\,\n('MEMORYCLERK_SQLCLRASSEMBLY'\,'CLR\ Assembly')\,\n('MEMORYCLERK_SQLCONNECTIONPOOL'\,'Connection\ Pool')\,\n('MEMORYCLERK_SQLGENERAL'\,'General')\,\n('MEMORYCLERK_SQLHTTP'\,'HTTP')\,\n('MEMORYCLERK_SQLLOGPOOL'\,'Log\ Pool')\,\n('MEMORYCLERK_SQLOPTIMIZER'\,'SQL\ Optimizer')\,\n('MEMORYCLERK_SQLQERESERVATIONS'\,'SQL\ Reservations')\,\n('MEMORYCLERK_SQLQUERYCOMPILE'\,'SQL\ Query\ Compile')\,\n('MEMORYCLERK_SQLQUERYEXEC'\,'SQL\ Query\ Exec')\,\n('MEMORYCLERK_SQLQUERYPLAN'\,'SQL\ Query\ Plan')\,\n('MEMORYCLERK_SQLSERVICEBROKER'\,'SQL\ Service\ Broker')\,\n('MEMORYCLERK_SQLSERVICEBROKERTRANSPORT'\,'Unified\ Communication\ Stack')\,\n('MEMORYCLERK_SQLSOAP'\,'SQL\ SOAP')\,\n('MEMORYCLERK_SQLSOAPSESSIONSTORE'\,'SQL\ SOAP\ (Session\ Store)')\,\n('MEMORYCLERK_SQLSTORENG'\,'SQL\ Storage\ Engine')\,\n('MEMORYCLERK_SQLUTILITIES'\,'SQL\ Utilities')\,\n('MEMORYCLERK_SQLXML'\,'SQL\ XML')\,\n('MEMORYCLERK_SQLXP'\,'SQL\ XP')\,\n('MEMORYCLERK_TRACE_EVTNOTIF'\,'Trace\ Event\ Notification')\,\n('MEMORYCLERK_XE'\,'XE\ Engine')\,\n('MEMORYCLERK_XE_BUFFER'\,'XE\ Buffer')\,\n('MEMORYCLERK_XTP'\,'In-Memory\ OLTP')\,\n('OBJECTSTORE_LBSS'\,'Lbss\ Cache\ (Object\ Store)')\,\n('OBJECTSTORE_LOCK_MANAGER'\,'Lock\ Manager\ (Object\ Store)')\,\n('OBJECTSTORE_SECAUDIT_EVENT_BUFFER'\,'Audit\ Event\ Buffer\ (Object\ Store)')\,\n('OBJECTSTORE_SERVICE_BROKER'\,'Service\ Broker\ (Object\ Store)')\,\n('OBJECTSTORE_SNI_PACKET'\,'SNI\ Packet\ (Object\ Store)')\,\n('OBJECTSTORE_XACT_CACHE'\,'Transactions\ Cache\ (Object\ Store)')\,\n('USERSTORE_DBMETADATA'\,'DB\ Metadata\ (User\ Store)')\,\n('USERSTORE_OBJPERM'\,'Object\ Permissions\ (User\ Store)')\,\n('USERSTORE_SCHEMAMGR'\,'Schema\ Manager\ (User\ Store)')\,\n('USERSTORE_SXC'\,'SXC\ (User\ Store)')\,\n('USERSTORE_TOKENPERM'\,'Token\ Permissions\ (User\ Store)')\,\n('USERSTORE_QDSSTMT'\,'QDS\ Statement\ Buffer\ (Pre-persist)')\,\n('CACHESTORE_QDSRUNTIMESTATS'\,'QDS\ Runtime\ Stats\ (Pre-persist)')\,\n('CACHESTORE_QDSCONTEXTSETTINGS'\,'QDS\ Unique\ Context\ Settings')\,\n('MEMORYCLERK_QUERYDISKSTORE'\,'QDS\ General')\,\n('MEMORYCLERK_QUERYDISKSTORE_HASHMAP'\,'QDS\ Query/Plan\ Hash\ Table')\n)\ AS\ clerk_names(system_name\,name)\nON\ mc.type\ \=\ clerk_names.system_name\nGROUP\ BY\ ISNULL(clerk_names.name\,mc.type)\nHAVING\ SUM(mc.pages_kb)\ >\=\ 1024\nOPTION(\ RECOMPILE\ ,status=running,transaction_isolation_level=2-Read\ Committed blocking_session_id=0i,cpu_time_ms=13i,granted_query_memory_pages=246i,logical_reads=4i,open_transaction=0i,percent_complete=0,query_hash="M#��U%",query_plan_hash="�cU�3�N",request_id=0i,session_id=56i,total_elasped_time_ms=13i,wait_time_ms=0i,writes=0i 1573804186000000000
> sqlserver_schedulers,cpu_id=6,database_name=master,host=HOST_Name,scheduler_id=6,sql_instance=HOST_Name active_workers_count=5i,context_switches_count=13239621i,current_tasks_count=5i,current_workers_count=9i,is_idle=true,is_online=true,load_factor=7i,pending_disk_io_count=0i,preemptive_switches_count=817153i,runnable_tasks_count=0i,total_cpu_usage_ms=0i,total_scheduler_delay_ms=103869i,work_queue_count=0i,yield_count=59810605i 1573804186000000000
> sqlserver_memory_clerks,clerk_type=Bound\ Trees,database_name=master,host=HOST_Name,sql_instance=HOST_Name size_kb=69448i 1573804186000000000
> sqlserver_requests,command=INSERT,database_name=master,host=HOST_Name,host_name=HOST_Name,program_name=telegraf,session_db_name=master,sql_instance=HOST_Name,statement_text=INSERT\tINTO\ @PCounters\nSELECT\tDISTINCT\n\t\tRTrim(spi.object_name)\ object_name\,\n\t\tRTrim(spi.counter_name)\ counter_name\,\n\t\tRTrim(spi.instance_name)\ instance_name\,\n\t\tCAST(spi.cntr_value\ AS\ BIGINT)\ AS\ cntr_value\,\n\t\tspi.cntr_type\nFROM\tsys.dm_os_performance_counters\ AS\ spi\nWHERE\t(\n\t\t\tcounter_name\ IN\ (\n\t\t\t\t'SQL\ Compilations/sec'\,\n\t\t\t\t'SQL\ Re-Compilations/sec'\,\n\t\t\t\t'User\ Connections'\,\n\t\t\t\t'Batch\ Requests/sec'\,\n\t\t\t\t'Logouts/sec'\,\n\t\t\t\t'Logins/sec'\,\n\t\t\t\t'Processes\ blocked'\,\n\t\t\t\t'Latch\ Waits/sec'\,\n\t\t\t\t'Full\ Scans/sec'\,\n\t\t\t\t'Index\ Searches/sec'\,\n\t\t\t\t'Page\ Splits/sec'\,\n\t\t\t\t'Page\ Lookups/sec'\,\n\t\t\t\t'Page\ Reads/sec'\,\n\t\t\t\t'Page\ Writes/sec'\,\n\t\t\t\t'Readahead\ Pages/sec'\,\n\t\t\t\t'Lazy\ Writes/sec'\,\n\t\t\t\t'Checkpoint\ Pages/sec'\,\n\t\t\t\t'Page\ life\ expectancy'\,\n\t\t\t\t'Log\ File(s)\ Size\ (KB)'\,\n\t\t\t\t'Log\ File(s)\ Used\ Size\ (KB)'\,\n\t\t\t\t'Data\ File(s)\ Size\ (KB)'\,\n\t\t\t\t'Transactions/sec'\,\n\t\t\t\t'Write\ Transactions/sec'\,\n\t\t\t\t'Active\ Temp\ Tables'\,\n\t\t\t\t'Temp\ Tables\ Creation\ Rate'\,\n\t\t\t\t'Temp\ Tables\ For\ Destruction'\,\n\t\t\t\t'Free\ Space\ in\ tempdb\ (KB)'\,\n\t\t\t\t'Version\ Store\ Size\ (KB)'\,\n\t\t\t\t'Memory\ Grants\ Pending'\,\n\t\t\t\t'Memory\ Grants\ Outstanding'\,\n\t\t\t\t'Free\ list\ stalls/sec'\,\n\t\t\t\t'Buffer\ cache\ hit\ ratio'\,\n\t\t\t\t'Buffer\ cache\ hit\ ratio\ base'\,\n\t\t\t\t'Backup/Restore\ Throughput/sec'\,\n\t\t\t\t'Total\ Server\ Memory\ (KB)'\,\n\t\t\t\t'Target\ Server\ Memory\ (KB)'\,\n\t\t\t\t'Log\ Flushes/sec'\,\n\t\t\t\t'Log\ Flush\ Wait\ Time'\,\n\t\t\t\t'Memory\ broker\ clerk\ size'\,\n\t\t\t\t'Log\ Bytes\ Flushed/sec'\,\n\t\t\t\t'Bytes\ Sent\ to\ Replica/sec'\,\n\t\t\t\t'Log\ Send\ Queue'\,\n\t\t\t\t'Bytes\ Sent\ to\ Transport/sec'\,\n\t\t\t\t'Sends\ to\ Replica/sec'\,\n\t\t\t\t'Bytes\ Sent\ to\ Transport/sec'\,\n\t\t\t\t'Sends\ to\ Transport/sec'\,\n\t\t\t\t'Bytes\ Received\ from\ Replica/sec'\,\n\t\t\t\t'Receives\ from\ Replica/sec'\,\n\t\t\t\t'Flow\ Control\ Time\ (ms/sec)'\,\n\t\t\t\t'Flow\ Control/sec'\,\n\t\t\t\t'Resent\ Messages/sec'\,\n\t\t\t\t'Redone\ Bytes/sec'\,\n\t\t\t\t'XTP\ Memory\ Used\ (KB)'\,\n\t\t\t\t'Transaction\ Delay'\,\n\t\t\t\t'Log\ Bytes\ Received/sec'\,\n\t\t\t\t'Log\ Apply\ Pending\ Queue'\,\n\t\t\t\t'Redone\ Bytes/sec'\,\n\t\t\t\t'Recovery\ Queue'\,\n\t\t\t\t'Log\ Apply\ Ready\ Queue'\,\n\t\t\t\t'CPU\ usage\ %'\,\n\t\t\t\t'CPU\ usage\ %\ base'\,\n\t\t\t\t'Queued\ requests'\,\n\t\t\t\t'Requests\ completed/sec'\,\n\t\t\t\t'Blocked\ tasks'\,\n\t\t\t\t'Active\ memory\ grant\ amount\ (KB)'\,\n\t\t\t\t'Disk\ Read\ Bytes/sec'\,\n\t\t\t\t'Disk\ Read\ IO\ Throttled/sec'\,\n\t\t\t\t'Disk\ Read\ IO/sec'\,\n\t\t\t\t'Disk\ Write\ Bytes/sec'\,\n\t\t\t\t'Disk\ Write\ IO\ Throttled/sec'\,\n\t\t\t\t'Disk\ Write\ IO/sec'\,\n\t\t\t\t'Used\ memory\ (KB)'\,\n\t\t\t\t'Forwarded\ Records/sec'\,\n\t\t\t\t'Background\ Writer\ pages/sec'\,\n\t\t\t\t'Percent\ Log\ Used'\,\n\t\t\t\t'Log\ Send\ Queue\ KB'\,\n\t\t\t\t'Redo\ Queue\ KB'\n\t\t\t)\n\t\t)\ OR\ (\n\t\t\tobject_name\ LIKE\ '%User\ Settable%'\n\t\t\tOR\ object_name\ LIKE\ '%SQL\ Errors%'\n\t\t)\ OR\ (\n\t\t\tinstance_name\ IN\ ('_Total')\n\t\t\tAND\ counter_name\ IN\ (\n\t\t\t\t'Lock\ Timeouts/sec'\,\n\t\t\t\t'Number\ of\ Deadlocks/sec'\,\n\t\t\t\t'Lock\ Waits/sec'\,\n\t\t\t\t'Latch\ Waits/sec'\n\t\t\t)\n\t\t,status=runnable,transaction_isolation_level=2-Read\ Committed blocking_session_id=0i,cpu_time_ms=5i,granted_query_memory_pages=128i,logical_reads=96i,open_transaction=0i,percent_complete=0,query_hash="9YٲC�:",query_plan_hash="I�l
M~E",request_id=0i,session_id=62i,total_elasped_time_ms=13i,wait_time_ms=0i,writes=0i 1573804186000000000
> sqlserver_schedulers,cpu_id=7,database_name=master,host=HOST_Name,scheduler_id=7,sql_instance=HOST_Name active_workers_count=7i,context_switches_count=12671072i,current_tasks_count=8i,current_workers_count=11i,is_idle=true,is_online=true,load_factor=8i,pending_disk_io_count=0i,preemptive_switches_count=797841i,runnable_tasks_count=0i,total_cpu_usage_ms=0i,total_scheduler_delay_ms=94479i,work_queue_count=0i,yield_count=62913121i 1573804186000000000
> sqlserver_memory_clerks,clerk_type=Buffer\ Pool,database_name=master,host=HOST_Name,sql_instance=HOST_Name size_kb=23309032i 1573804186000000000
> sqlserver_requests,command=SELECT,database_name=master,host=HOST_Name,host_name=HOST_Name,program_name=telegraf,session_db_name=master,sql_instance=HOST_Name,statement_text=SELECT\t\n\ \ \ 'sqlserver_requests'\ AS\ [measurement]\,\n\ \ \ \ @@servername\ AS\ [sql_instance]\,\n\ \ \ \ DB_NAME()\ as\ [database_name]\,\n\tr.session_id\n\t\,\ r.request_id\n\t\,\ DB_NAME(s.database_id)\ as\ session_db_name\n\t\,\ r.status\n\t\,\ r.cpu_time\ as\ cpu_time_ms\n\t\,\ r.total_elapsed_time\ as\ total_elasped_time_ms\n\t\,\ r.logical_reads\n\t\,\ r.writes\n\t\,\ r.command\n\t\,\ wait_time\ as\ wait_time_ms\n\t\,\ wait_type\n\t\,\ wait_resource\n\t\,\ blocking_session_id\n\t\,\ s.program_name\n\t\,\ s.host_name\n\t\,\ s.nt_user_name\n\t\ \,\ r.open_transaction_count\ \ AS\ open_transaction\n\t\ \,\ \tLEFT\ (CASE\ COALESCE(r.transaction_isolation_level\,\ s.transaction_isolation_level)\n\t\tWHEN\ 0\ THEN\ '0-Read\ Committed'\ \n\t\tWHEN\ 1\ THEN\ '1-Read\ Uncommitted\ (NOLOCK)'\ \n\t\tWHEN\ 2\ THEN\ '2-Read\ Committed'\ \n\t\tWHEN\ 3\ THEN\ '3-Repeatable\ Read'\ \n\t\tWHEN\ 4\ THEN\ '4-Serializable'\ \n\t\tWHEN\ 5\ THEN\ '5-Snapshot'\ \n\t\tELSE\ CONVERT\ (varchar(30)\,\ r.transaction_isolation_level)\ +\ '-UNKNOWN'\ \n\tEND\,\ 30)\ AS\ transaction_isolation_level\n\t\,r.granted_query_memory\ as\ granted_query_memory_pages\n\t\,\ r.percent_complete\n\t\,\ (SUBSTRING(qt.text\,\ r.statement_start_offset\ /\ 2\ +\ 1\,\n\t\t\t\t\t\t\t\t\t\t\t(CASE\ WHEN\ r.statement_end_offset\ \=\ -1\n\t\t\t\t\t\t\t\t\t\t\t\t\tTHEN\ LEN(CONVERT(NVARCHAR(MAX)\,\ qt.text))\ *\ 2\n\t\t\t\t\t\t\t\t\t\t\t\t\tELSE\ r.statement_end_offset\n\t\t\t\t\t\t\t\t\t\t\tEND\ -\ r.statement_start_offset)\ /\ 2)\n\t\t)\ AS\ statement_text\n\t\,\ qt.objectid\n\t\,\ QUOTENAME(OBJECT_SCHEMA_NAME(qt.objectid\,qt.dbid))\ +\ '.'\ +\ \ QUOTENAME(OBJECT_NAME(qt.objectid\,qt.dbid))\ as\ stmt_object_name\n\t\,\ DB_NAME(qt.dbid)\ stmt_db_name\n\t\,\ r.query_hash\n\t\,\ r.query_plan_hash\n\tFROM\tsys.dm_exec_requests\ r\n\t\tLEFT\ OUTER\ JOIN\ sys.dm_exec_sessions\ s\ ON\ (s.session_id\ \=\ r.session_id)\n\t\tOUTER\ APPLY\ sys.dm_exec_sql_text(sql_handle)\ AS\ qt\n\t\t\n\tWHERE\t1\=1\n\t\ AND\ (r.session_id\ IS\ NOT\ NULL\ AND\ (s.is_user_process\ \=\ 1\ OR\ r.status\ COLLATE\ Latin1_General_BIN\ NOT\ IN\ ('background'\,\ 'sleeping')))\n\t\ OR\ (s.session_id\ IN\ (SELECT\ blocking_session_id\ FROM\ #blockingSessions))\n\t\ OPTION(MAXDOP\ 1,status=running,transaction_isolation_level=2-Read\ Committed blocking_session_id=0i,cpu_time_ms=8i,granted_query_memory_pages=0i,logical_reads=73i,open_transaction=0i,percent_complete=0,query_hash="7�����z",query_plan_hash="��\".ǵ",request_id=0i,session_id=63i,total_elasped_time_ms=13i,wait_time_ms=0i,writes=0i 1573804186000000000
> sqlserver_waitstats,database_name=master,host=HOST_Name,sql_instance=HOST_Name,wait_category=Other\ Disk\ IO,wait_type=ASYNC_IO_COMPLETION max_wait_time_ms=3042523i,resource_wait_ms=30032824i,signal_wait_time_ms=4i,wait_time_ms=30032828i,waiting_tasks_count=76i 1573804186000000000
> sqlserver_schedulers,cpu_id=0,database_name=master,host=HOST_Name,scheduler_id=*,sql_instance=HOST_Name active_workers_count=1i,context_switches_count=0i,current_tasks_count=1i,current_workers_count=1i,is_idle=false,is_online=true,load_factor=1i,pending_disk_io_count=0i,preemptive_switches_count=133i,runnable_tasks_count=0i,total_cpu_usage_ms=0i,total_scheduler_delay_ms=0i,work_queue_count=0i,yield_count=1323i 1573804186000000000
> sqlserver_memory_clerks,clerk_type=CLR,database_name=master,host=HOST_Name,sql_instance=HOST_Name size_kb=21800i 1573804186000000000