Microsoft Dynamics CRM 2011-2013 Statistics

Version 1

    This template assesses the status and overall performance of a Microsoft Dynamics CRM server by retrieving statistics from performance counters.


    Prerequisites: WMI access to the target server.

    Credentials: Windows Administrator on the target server.


    Monitored Components

    Service: Microsoft Dynamics CRM Asynchronous Processing

    This monitor returns CPU and memory usage of Dynamics CRM Asynchronous Processing service. This service handles the processing of queued Asynchronous Events.

     

    Service: Microsoft Dynamics CRM Sandbox Processing

    This monitor returns CPU and memory usage of Dynamics CRM Sandbox Processing service. This service handles the processing of isolated plugins.

     

    Service: Microsoft Dynamics CRM Unzip

    This monitor returns CPU and memory usage of Dynamics CRM Unzip service. This service handles requests to unzip files for data import.

     

    Server: Failed Internal Organization Service Requests

    This monitor returns the total number of failed web service requests to Microsoft Dynamics CRM InProc calls that are made by applications that use the methods described in the Microsoft Dynamics CRM SDK.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Server: Failed Organization Service Metadata Requests

    This monitor returns the total number of metadata requests received by the Microsoft Dynamics CRM Organization Web Service that failed because of a time-out or other SOAP failure.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Server: Failed Organization Service Requests

    This monitor returns the total number of requests to the Microsoft Dynamics CRM Organization Web Service that failed because of a time-out or other SOAP failure.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Server: Failed Report Render Requests

    This monitor returns the number of requests to render Microsoft SQL Server Reporting Services reports that failed because of a time-out or error.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Server: Script Error Reports

    This monitor returns the total number of error reports generated by the web client and Microsoft Dynamics CRM for Outlook. This counter is reset weekly to zero. This counter is an indicator of high script error frequency. If a large number of error reports are received in a short time, the operations team should investigate to determine which pages are producing errors. We recommend that you set a monitoring alert to notify you if there are more than 500 error reports in a 10-minute period.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Server: Internal Organization Service Requests

    This monitor returns the total number of requests received by Microsoft Dynamics CRM InProc calls that are made by applications that use the methods described in the Microsoft Dynamics CRM SDK. This includes both successful and unsuccessful requests.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Server: Organization Service Metadata Requests

    This monitor returns the total number of metadata requests received by the Microsoft Dynamics CRM Organization Web service. This includes both successful and unsuccessful requests.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Server: Organization Service Requests

    This monitor returns the total number of requests received by the Microsoft Dynamics CRM Organization Web Service. This includes both successful and unsuccessful requests.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Server: Report Render Requests

    This monitor returns the total number of requests to render Microsoft SQL Server Reporting Services reports.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Auth: Claims Authentication Failures In The Last Minute

    This monitor returns the total number of failed authentication requests processed per minute using claims. This counter measures the whole deployment including all organizations.

     

    Auth: Config DB Windows Authentication Failures In The Last Minute

    This monitor returns the number of unsuccessful authentication requests per minute that are processed by using Active Directory authentication credentials. This counter measures the entire Microsoft Dynamics CRM deployment including all organizations.

    A high count may indicate that the system is possibly under a Denial of Service attack, or there is some problem with the Authentication service configuration.

     

    Auth: Crm Post Authentication Failures In The Last Minute

    This monitor returns the number of unsuccessful authentication requests per minute that are processed by using Microsoft Dynamics CRM authentication credentials. This counter measures the entire deployment including all organizations.

    A high count may indicate that the system is possibly under a Denial of Service attack, or there is some problem with the Authentication service configuration.

     

    Auth: Passport Authentication Failures In The Last Minute

    This monitor returns the number of failed authentication requests per minute that are processed by using Microsoft account authentication credentials. This counter measures the entire Microsoft Dynamics CRM deployment including all organizations. This counter applies to pn_crm_online only. A high count may indicate that the system is possibly under a Denial of Service attack, or there is some problem with the Authentication service configuration.

     

    Auth: Windows Authentication Failures In The Last Minute

    This monitor returns the number of unsuccessful authentication requests per minute. There are several possible causes for authentication failure. For example, the user may have been authenticated successfully by  Active Directory but Microsoft Dynamics CRM authentication failed to communicate with the Kerberos servers, or a token expired, or the user's credentials are incorrect. This counter measures the entire Microsoft Dynamics CRM deployment including all organizations. A high count may indicate that the system is possibly under a Denial of Service attack, or there is some problem with the Authentication service configuration. We recommend that you set a monitoring alert to notify you if this value exceeds 30.

     

    Outlook Sync: ABP Sync Requests

    This monitor returns the total number of Address Book Provider (ABP) synchronization requests made from Microsoft Dynamics CRM for Outlook to a Microsoft Dynamics CRM Server. This counter is useful to indicate the client load on the Asynchronous Processing Service. A high count indicates a high client load on that service.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Outlook Sync: Offline Sync Requests

    This monitor returns the total number of offline synchronization requests made from Microsoft Dynamics CRM for Outlook to a Microsoft Dynamics CRM Server. This counter is useful to indicate the client load on the Asynchronous Processing service. A high count indicates a high client load on the service.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Outlook Sync: Outlook Sync Requests

    This monitor returns the total number of ABP Sync Requests and the Offline Sync Requests. This counter is useful to indicate the client load on the Asynchronous Processing Service. A high count indicates a high client load on that service.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Outlook Sync: Succeeded Offline Sync Requests

    This monitor returns the number of successful offline synchronization requests made from Microsoft Dynamics CRM for Outlook to a Microsoft Dynamics CRM Server. A count that is much lower than the total number of offline synchronization requests may indicate a problem with clients that try to synchronize with the server.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Discovery: Failed Discovery Service Requests

    This monitor returns the number of requests to the Microsoft Dynamics CRM Discovery service that are unsuccessful for any reason. For example, a request may fail because the requesting party is not recognized as a user in the organization. A high count may indicate that the system is possibly under a Denial of Service attack, or there is some problem with the Discovery service configuration.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Discovery: Discovery Service Requests

    This monitor returns the total number of requests received by the Microsoft Dynamics CRM Discovery service. This includes successful and unsuccessful requests. This counter can be used to track traffic patterns for Discovery service capacity planning.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Locator Service: Failed Cache Flush Requests

    This monitor returns the number of Locator Service cache flush requests that were unsuccessful for any reason. For example, a request may fail because it was for an invalid cache entry, or the cache may not flush because of an incorrect cache state. A high count may indicate a problem with the Locator Service cache, or a problem with the connection to CONFIG_DB. For information about the cause, review the event log for errors.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Locator Service: Cache Flush Requests

    This monitor returns the total number of successful Locator Service cache flush requests that have been received. A high count may indicate that the caching algorithm is not optimized, or that the data is changing too frequently.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Platform: Average time of import request

    This monitor returns the average time that is required to process Microsoft Dynamics CRM data import requests. Import requests are resource-intensive SQL operations. If the average time is too high and the number of concurrent imports is high, some organizations may have to be moved to a different deployment. Also, you may want to consider processing import jobs during a maintenance window to reduce the performance effect on users.

     

    Router Service: Router Request Faulted

    This monitor returns the number of requests made on the faulted channel to the router.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Sandbox Host: % Assembly Cache Usage

    This monitor returns the percentage of the total assembly cache disk space that is in use.

     

    Sandbox Host: % CPU Usage

    This monitor returns the total CPU percentage used by all Sandbox Worker processes.

     

    Sandbox Host: % Execute Failures

    This monitor returns the incoming Execute failure rate percentage.

     

    Sandbox Host: % SDK Failures

    This monitor returns the outgoing SDK Request failure rate percentage.

     

    Sandbox Host: % Worker Processes Crashed

    This monitor returns the percentage of Sandbox Worker processes that have crashed.

     

    Sandbox Host: Active Assemblies

    This monitor returns the number of plug-in assemblies currently in use.

     

    Sandbox Host: Active Organizations

    This monitor returns the number of organizations that currently have a Sandbox Worker process active.

     

    Sandbox Host: Memory Usage (MB)

    This monitor returns the total memory used by all Sandbox Worker processes, in MBytes.

     

    Async Service: Active Organizations

    This monitor returns the total number of organizations in the Microsoft Dynamics CRM deployment that are actively being polled by the Microsoft CRM Asynchronous Processing Service.

     

    Async Service: Threads in Use

    This monitor returns the number of threads currently employed in the processing of asynchronous operations for all organizations in the deployment.

     

    Async Service: Operations Failed

    This monitor returns the total number of asynchronous operations that failed for all organizations in the deployment.

    Note: This component has “Count statistic as difference” enabled. It will return the difference between two polling intervals.

     

    Async Service: Total Operations Executing

    This monitor returns the current number of operations being processed by asynchronous handlers for all organizations in the deployment.

     

    Dynamics CRM TCP Port

    This component monitor tests the ability of a Dynamics CRM service to accept incoming sessions.

    Note: By default, TCP port 80 is monitored.

     

    Portions of this document are courtesy of Microsoft, copyright 2013:
    http://www.microsoft.com/en-us/download/details.aspx?id=27119
    http://mpwiki.viacode.com/default.aspx?g=posts&t=105321

    Last updated 1/28/2015