munin-node.ini SQLServer Addtional

;==============================================================================
;Set for SQLServer
;
;\SQLServer:~\ は規定のインスタンスの場合 名前付きの場合は \MSSQL$名前:~\ に置換
;==============================================================================
;SQLServer

;-- disk
;\SQLServer:Buffer Manager\Page reads/sec
;------------------------------------------------------------------------------
[PerfCounterPlugin_SQLBufManPageReadsSec]
Object=SQLServer:Buffer Manager
Counter=Page reads/sec
GraphTitle=Page reads/sec
GraphCategory=SQLServer
GraphDraw=LINE
GraphArgs=--base 1000 --lower-limit 0
DropTotal=0
CounterFormat=int
CounterMultiply=1.000000

;\SQLServer:Buffer Manager\Page writes/sec
;------------------------------------------------------------------------------
[PerfCounterPlugin_SQLBufManPageWritesSec]
Object=SQLServer:Buffer Manager
Counter=Page writes/sec
GraphTitle=Page writes/sec
GraphCategory=SQLServer
GraphDraw=LINE
GraphArgs=--base 1000 --lower-limit 0
DropTotal=0
CounterFormat=int
CounterMultiply=1.000000

;-- proc
;\Processor(_Total)\% Privileged Time
;------------------------------------------------------------------------------
[PerfCounterPlugin_PrivilegedTime]
Object=Processor
Counter=% Privileged Time
GraphTitle=% Privileged Time
GraphCategory=SQLServer
GraphDraw=LINE
GraphArgs=--base 1000 --lower-limit 0
DropTotal=1
CounterFormat=int
CounterMultiply=1.000000

;\Processor(_Total)\% User Time
;------------------------------------------------------------------------------
[PerfCounterPlugin_UserTime]
Object=Processor
Counter=% User Time
GraphTitle=% User Time
GraphCategory=SQLServer
GraphDraw=LINE
GraphArgs=--base 1000 --lower-limit 0
DropTotal=1
CounterFormat=int
CounterMultiply=1.000000


;-- memory
;\SQLServer:Buffer Manager\Buffer cache hit ratio
;------------------------------------------------------------------------------
[PerfCounterPlugin_SQLBufManBufferCacheHitRatio]
Object=SQLServer:Buffer Manager
Counter=Buffer cache hit ratio
GraphTitle=Buffer cache hit ratio
GraphCategory=SQLServer
GraphDraw=LINE
GraphArgs=--base 1000 --lower-limit 0
DropTotal=0
CounterFormat=int
CounterMultiply=1.000000

;\SQLServer:Buffer Manager\Total Pages
;------------------------------------------------------------------------------
[PerfCounterPlugin_SQLBufManTotalPages]
Object=SQLServer:Buffer Manager
Counter=Total Pages
GraphTitle=Total Pages
GraphCategory=SQLServer
GraphDraw=LINE
GraphArgs=--base 1000 --lower-limit 0
DropTotal=0
CounterFormat=int
CounterMultiply=1.000000

;\SQLServer:Memory Manager\Total Server Memory (KB)
;------------------------------------------------------------------------------
[PerfCounterPlugin_SQLMemManTotalServerMemory]
Object=SQLServer:Memory Manager
Counter=Total Server Memory (KB)
GraphTitle=Total Server Memory (KB)
GraphCategory=SQLServer
GraphDraw=LINE
GraphArgs=--base 1000 --lower-limit 0
DropTotal=0
CounterFormat=int
CounterMultiply=1.000000

;\SQLServer:Cache Manager(_Total)\Cache Hit Ratio
;------------------------------------------------------------------------------
[PerfCounterPlugin_SQLCacManCacheHitRatio]
Object=SQLServer:Cache Manager
Counter=Cache Hit Ratio
GraphTitle=Cache Hit Ratio
GraphCategory=SQLServer
GraphDraw=LINE
GraphArgs=--base 1000 --lower-limit 0
DropTotal=1
CounterFormat=int
CounterMultiply=1.000000

;-- database
;\SQLServer:Databases(_Total)\Data File(s) Size (KB)
;------------------------------------------------------------------------------
[PerfCounterPlugin_SQLDBDataFileSize]
Object=SQLServer:Databases
Counter=Data File(s) Size (KB)
GraphTitle=Data File(s) Size (KB)
GraphCategory=SQLServer
GraphDraw=LINE
GraphArgs=--base 1000 --lower-limit 0
DropTotal=1
CounterFormat=int
CounterMultiply=1.000000

;\SQLServer:Databases(_Total)\Transactions/sec
;------------------------------------------------------------------------------
[PerfCounterPlugin_SQLDBTransactionsSec]
Object=SQLServer:Databases
Counter=Transactions/sec
GraphTitle=Transactions/sec
GraphCategory=SQLServer
GraphDraw=LINE
GraphArgs=--base 1000 --lower-limit 0
DropTotal=1
CounterFormat=int
CounterMultiply=1.000000