Introduction

Monitors AvgDataAdapterQueryDuration, AvgDataConnectionSubmitDuration, AvgDiskQueueLength, AvgDiskReadQueueLength, AvgDiskWriteQueueLength, etc.

Discovery with the agent

Collector Type: Agent

Category: Application Monitors

Application Name: Sharepoint_2010

Global Template Name : Microsoft SharePoint 2010 - Performance Counters DotNet v4

Pre-requisites: For SharePoint 2010 monitors need Microsoft .Net Framework 4.

Collected Metrics

Metric NameDisplay NameDescription
AvgDiskQueueLengthAvgDiskQueueLengthAvg. Disk Queue Length is the average number of both read and write requests that were queued for the selected disk during the sample interval.
AvgDiskReadQueueLengthAvgDiskReadQueueLengthAvg. Disk Read Queue Length is the average number of read requests that were queued for the selected disk during the sample interval.
AvgDiskWriteQueueLengthAvgDiskWriteQueueLengthAvg. Disk Write Queue Length is the average number of write requests that were queued for the selected disk during the sample interval.
DiskReadsPersecDiskReadsPersecDisk Reads/sec is the rate of read operations on the disk.
DiskWritesPersecDiskWritesPersecNumber of times a worker process has restarted on the machine.
PercentIdleTimePercentIdleTime% Idle Time reports the percentage of time during the sample interval that the disk was idle.
PageFaultsPersecPageFaultsPersecPage Faults/sec is the average number of pages faulted per second. It is measured in number of pages faulted per second because only one page is faulted in each fault operation, hence this is also equal to the number of page fault operations.
PercentUsagePercentUsageThe amount of the Page File instance in use in percent.
RequestsQueuedRequestsQueuedThe number of requests waiting to be processed.
RequestWaitTimeRequestWaitTimeThe number of milliseconds the most recent request was waiting in the queue.
RequestsPerSecRequestsPerSecThe number of requests executed per second.
PercentTimeinGCPercentTimeinGC% Time in GC is the percentage of elapsed time that was spent in performing a garbage collection (GC) since the last GC cycle. This counter is usually an indicator of the work done by the Garbage Collector on behalf of the application to collect.
ContextSwitchesPersecContextSwitchesPersecA context switch occurs when the kernel switches the processor from one thread to anotherfor example, when a thread with a higher priority than the running thread becomes ready. The System Context Switches/sec counter in System Monitor reports systemwide.
ProcessorQueueLengthProcessorQueueLengthProcessor Queue Length is the number of threads in the processor queue. Unlike the disk counters, this counter counters, this counter shows ready threads only, not threads that are running.
BytesReceivedPersecBytesReceivedPersecBytes Received/sec is the rate that data bytes are received by the Web service.
BytesSentPersecBytesSentPersecBytes Sent/sec is the rate data bytes are being sent by the Web service.
TotalConnectionAttemptsallinstancesTotalConnectionAttemptsallinstancesTotal Connection Attempts is the number of connections that have been attempted using the Web service (since service startup). This counter is for all instances listed.
CurrentConnectionsCurrentConnectionsCurrent Connections is the current number of connections established with the Web service.
GetRequestsPersecGetRequestsPersecThe rate HTTP requests using the GET method are made. Get requests are the most common HTTP request.
DataConnectionQueryFailureRateDataConnectionQueryFailureRateThe rate of failures for data connection queries in form filling sessions.
DataConnectionQueryCompletedRateDataConnectionQueryCompletedRateThe rate at which data connection queries completed in form filling sessions.
AvgDataAdapterQueryDurationAvgDataAdapterQueryDurationThe average time to complete a data connection query in form filling sessions.
DataConnectionSubmitFailureRateDataConnectionSubmitFailureRateThe rate of failures for data connection submits in form filling sessions.
DataConnectionSubmitCompletedRateDataConnectionSubmitCompletedRateThe rate at which data connection submits completed in form filling sessions.
DataConnectionSubmitStartedRateDataConnectionSubmitStartedRateThe rate at which data connection submits started in form filling sessions.
AvgDataConnectionSubmitDurationAvgDataConnectionSubmitDurationThe average time to complete a data connection submit in form filling sessions.
SessionCompletedRateSessionCompletedRateThe average time to complete a data connection submit in form filling sessions.
SessionStartedRateSessionStartedRateThe rate at which form filling sessions started.
AvgSessionDurationAvgSessionDurationThe average time to complete a form filling session, summed up over all transactions in the session.
TransactionsCompletedRateTransactionsCompletedRateThe rate at which transactions completed in form filling sessions.
TransactionsStartedRateTransactionsStartedRateThe rate at which transactions started in form filling sessions.
AvgTransactionDurationAvgTransactionDurationThe average time to complete a transaction in form filling sessions.