Useful WinPerf counters

[sodalist]

Use this topic to post WinPerf counters.

[sodalist]

Counter =  SQLServer.BufferManager.BufferCacheHitRatio:"\SQLServer:Buffer Manager\Buffer cache hit ratio":60:A:INT:"MSSQL: Percentage of pages that were found in the buffer pool without having to incur a read from disk."
Counter =  SQLServer.BufferManager.PageReads:"\SQLServer:Buffer Manager\Page Reads/sec":60:A:INT:"MSSQL: Number of physical database page reads issued."
Counter =  SQLServer.BufferManager.PageWrites:"\SQLServer:Buffer Manager\Page Writes/sec":60:A:INT:"MSSQL: Number of physical database page writes issued."
Counter =  SQLServer.Databases.ActiveTransactions:"\SQLServer:Databases(_Total)\Active Transactions":60:A:INT:"MSSQL: Number of active update transactions for the database."
Counter =  SQLServer.Databases.Transactions:"\SQLServer:Databases(_Total)\Transactions/sec":60:A:INT:"MSSQL: Number of transactions started for the database."
Counter =  SQLServer.GeneralStatistics.UserConnections:"\SQLServer:General Statistics\User Connections":60:A:INT:"MSSQL: Number of users connected to the system."
Counter =  SQLServer.GeneralStatistics.Logins:"\SQLServer:General Statistics\Logins/sec":60:A:INT:"MSSQL: Total number of logins started per second."
Counter =  SQLServer.GeneralStatistics.Logouts:"\SQLServer:General Statistics\Logouts/sec":60:A:INT:"MSSQL: Total number of logouts started per second."
Counter =  SQLServer.MemoryManager.TotalServerMemory:"\SQLServer:Memory Manager\Total Server Memory (KB)":60:A:INT:"MSSQL: Total amount of dynamic memory the server is currently consuming."
Counter =  SQLServer.MemoryManager.SQLCacheMemory:"\SQLServer:Memory Manager\SQL Cache Memory (KB)":60:A:INT:"MSSQL: Total amount of dynamic memory the server is using for the dynamic SQL cache."
Counter =  SQLServer.Locks.LockRequests:"\SQLServer:Locks(_Total)\Lock Requests/sec":60:A:INT:"MSSQL: Number of new locks and lock conversions requested from the lock manager."
Counter =  SQLServer.Locks.AverageWaitTime:"\SQLServer:Locks(_Total)\Average Wait Time (ms)":60:A:INT:"MSSQL: The average amount of wait time (milliseconds) for each lock request that resulted in a wait."
Counter =  SQLServer.SQLStatistics.BatchRequests:"\SQLServer:SQL Statistics\Batch Requests/sec":60:A:INT:"MSSQL: Number of SQL batch requests received by server."

[sodalist]

Counter = ASP.NET.Requests.Rejected:"\ASP.NET\Requests Rejected":60:A:INT:ASP.NET Requests Rejected total
Counter = ASP.NET.Applications.Running:"\ASP.NET\Applications Running":60:A:INT:ASP.NET Applications Running over past minute
Counter = ASP.NET.Request.Execution.Time:"\ASP.NET\Request Execution Time":60:A:INT:ASP.NET Request Execution Time over past minute
Counter = ASP.NET.Error.Events.Raised:"\ASP.NET\Error Events Raised":60:A:INT:ASP.NET Error Events Raised total
Counter = ASP.NET.Application.Restarts:"\ASP.NET\Application Restarts":60:A:INT:ASP.NET Application Restarts total

[toad]

Sorry but I am not aware of the syntax you have put this post in. Can you please explain how to use the items you have listed .... ie do we use the wmi agent or something else.

[sodalist]

This is agent side configuration. You should copy/paste definitions
under *WinPerf section of agent configuration . After agent restart
and refresh of configuration you should be able to find defined
counters betwen NetXMS Agent Parameters list when trying to
create DCI.

A

[Sympology]

Thought I'd add a couple. If they can be improved, feel free.
Database Size
Counter =  SQLServer.Databases.DataFileSize:"\SQLServer:Databases(Databasename)\Data File(s) Size (KB)":60:A:INT:"MSSQL: Your discription here."

Processor useage
Counter =  Process.%ProcessorTime(processname):"\Process(processname)\% Processor Time":60:A:INT:"The percentage of Processor Time The processname Service Is Using."

[Jmp_3f8h]

Here some WinPerf counters to monitor Hyper-V status:

Counter = Hyper-V Hypervisor Virtual Processor.%Total Run Time(_Total):"\Hyper-V Hypervisor Virtual Processor(_Total)\% Total Run Time":60:A:INT:"The percentage of Host CPU used by Hyper-V Guests."
Counter = Hyper-V Virtual Machine Summary.Running:"\Hyper-V Virtual Machine Summary\Running":60:A:INT:"The number of virtual machines in 'running' state."
Counter = Hyper-V Virtual Machine Summary.Saved:"\Hyper-V Virtual Machine Summary\Saved":60:A:INT:"The number of virtual machines in 'saved' state."
Counter = Hyper-V Virtual Machine Summary.Turned Off:"\Hyper-V Virtual Machine Summary\Turned Off":60:A:INT:"The number of virtual machines in 'turned off' state."

Best regards,
Marco

[Jmp_3f8h]

These three counters:

Counter = Hyper-V Virtual Machine Summary.Running:"\Hyper-V Virtual Machine Summary\Running":60:A:INT:"The number of virtual machines in 'running' state."
Counter = Hyper-V Virtual Machine Summary.Saved:"\Hyper-V Virtual Machine Summary\Saved":60:A:INT:"The number of virtual machines in 'saved' state."
Counter = Hyper-V Virtual Machine Summary.Turned Off:"\Hyper-V Virtual Machine Summary\Turned Off":60:A:INT:"The number of virtual machines in 'turned off' state."

have been removed from Hyper-V shipped with Windows Server 2012 (they are only available in 2008R2).

This one:

Counter = Hyper-V Hypervisor Virtual Processor.%Total Run Time(_Total):"\Hyper-V Hypervisor Virtual Processor(_Total)\% Total Run Time":60:A:INT:"The percentage of Host CPU used by Hyper-V Guests."

is still available.

Best regards,
Marco