Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

FIM 2010 R2: Autostats equals ON

This topic is intended to address a specific issue identified by a Best Practices Analyzer scan. You should apply the information in this topic only to computers that have had the Forefront Identity Manager 2010 R2 Best Practices Analyzer run against them and are experiencing the issue addressed by this topic. For more information about best practices and scans, see Best Practices Analyzer (http://go.microsoft.com/fwlink/?LinkId=122786).

 

Product

Forefront Identity Manager 2010 R2

Feature

FIM Synchronization Service

Operating System

Windows Server 2008 R2

Severity

Error

Category

Configuration

Issue

FIMSyncServiceDB - Automatic statistics update is not enabled for the FIM Synchronization server database.

Scanning

Impact

FIMSyncServiceDB - FIM Synchronization service performance may be affected.

Resolution

FIMSyncServiceDB - Please enable Automatic statistics update for the FIM Synchronization server database.

To enable Auto Update Statistics use the following procedure

To enable Auto Update Statistics

  1. Open the Microsoft SQL Server Management Studio.

  2. In the Object Explorer, expand and right-click the FIMSynchronizationService database, and then click Properties in the context menu. This will open the Database Properties dialog.

  3. In the Select a page pane, click Options.

  4. In the main pane, double-click Auto Update Statistics.

  5. Close the Microsoft SQL Server Management Studio.

Additional references

For more information, see the FIM 2010 R2 Deployment Guide (http://technet.microsoft.com/en-us/library/jj134310(v=ws.10))

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.