Database Metrics

This resource contains performance counters specific to the status of database metrics. The icons of the listed performance counters in the Statistic Name column change colors to reflect the listed counter's current state. Clicking any performance counter in the Statistic Name column takes you to the Performance Counter Details page for that performance counter.

If the value of a listed performance counter crosses the Warning threshold, the chart for the listed counter displays a yellow background. If the value of a listed monitor crosses the Critical threshold, the chart for the listed counter displays a red background. Hovering over any time period within the chart displays detailed information about that time period in the tooltip. Hovering over a counter gives you detailed information about that performance counter.

The following table lists the default performance counters for this resource along with their respective definitions and troubleshooting information, including default Warning and Critical thresholds:

Counter Expert Knowledge Warn-
ing
Criti-
cal

Active Client Logons

(Only available in Exchange 2010)

Definition: 
The number of clients that performed any action within the last 10 minute interval.

Information:  
Active client logons can be high if users are logging on and logging off frequently.

Possible problems:
May cause memory bottlenecks on the server if the number is excessively high.

Remediation:
Determine if users are running applications not required for business use and request they do not run these applications which is causing an increase in server logons. If this does not help, or is not possible, reduce the number of server hosted on the server and move any public folders on the server to a different server.

N/A

N/A

Slow Findrow Rate

(Only available in Exchange 2010)

Definition:
Shows the rate at which the slower FindRow needs to be used in the mailbox store.

Information: 
Should be no more than 10 for any specific mailbox store.

Possible problems: 
Higher values indicate applications are crawling or searching mailboxes, which is affecting server performance. These include desktop search engines, customer relationship management (CRM), or other third-party applications.

Remediation:
Run the ResetSearchIndex.ps1 script which is located in the scripts directory at the root of the Exchange installation. Alternatively, you can perform the process manually:

1. Rebuild index catalog using Update-MailboxDatabaseCopy <DBName> -CatalogOnly command.
2. Stop the Microsoft Exchange Search Service.
3. Delete old catalog files.
4. Restart the Microsoft Exchange Search Service.

> 10

> 10 for 15 polls

Average Document Indexing Time

(At the database level, this is only available in Exchange 2010. At the application level, this is available for both Exchange 2010 and 2013.)

Definition: Shows the average, in ms, of how long it takes to index documents.

Information: Should be less than 30 seconds at all times.

Possible problems: Verify content index state of all database copies.

Remediation: For any database indexes not "healthy," update the content index on the server using the Update-MailboxDatabaseCopy <DBName> -CatalogOnly command.

> 30

> 30 for 15 polls

Mailboxes processed/sec

(Only available in Exchange 2013)

Definition: Shows the rate of mailboxes processed by time-based assistants per second.

Information: Determines current load statistics for this counter.

N/A

N/A

Zooming

You can have the chart show a predetermined time period of data by clicking on any one of the three Zoom buttons in the head of the Zoom column. Alternatively, you can have the chart show a specific date range by dragging the mouse over an area of the chart. The time and date displayed at the top of the resource shows the amount of data currently loaded into the chart. This can be changed by clicking Edit from within the resource.

The Value from Last Poll column shows the most recent data available for the listed statistic.

Additional components on certain resources may be available for addition and/or deletion on the Edit page.