Useful WinPerf counters

Started by sodalist, November 14, 2008, 01:02:30 PM

Previous topic - Next topic

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."

Marco Incalcaterra

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

Marco Incalcaterra

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