(0) exportieren Drucken
Alle erweitern
EN
Dieser Inhalt ist in Ihrer Sprache leider nicht verfügbar. Im Folgenden finden Sie die englische Version.

SQL Server Requirements for System Center 2012 R2

Updated: July 31, 2014

Applies To: System Center 2012 R2

Use this information to evaluate if your SQL Server environment is ready to support the installation of or upgrade to System Center 2012 R2. Use this information whether you are deploying one or multiple components of System Center.

 

System Center 2012 R2 component SQL Server 2008 R2 SP1 Standard, Datacenter SQL Server 2008 R2 SP2 Standard, Datacenter SQL Server 2012 Enterprise, Standard (64-bit) SQL Server 2012 SP1 Enterprise, Standard (64-bit) SQL Server 2012 SP2

App Controller Server

Data Protection Manager (DPM) Database Server

Operations Manager Data Warehouse

Operations Manager Operational Database

Operations Manager Reporting Server

Orchestrator Management Server

Service Manager Database or Data Warehouse Database

Service Provider Foundation

Virtual Machine Manager Database Server

This information describes general recommendations for SQL Server regardless of what System Center component you are deploying.

  • You will need a minimum of four computers to deploy all System Center components. Aside from performance reasons, not all system components can coexist on the same computer. For more information, see Component Coexistence for System Center 2012 R2.

  • For testing purposes only, one SQL Database Engine Services instance may be used for all components, but is not recommended in a production setting due to performance concerns.

  • Reporting Services instances cannot be shared between System Center components.

  • SQL_* collations are being deprecated for their Windows equivalents.

  • Limit the memory of each SQL Server instance such that the Total Memory setting allows a minimum of 1 GB (2GB preferred) of free memory after all services are running.

  • System Center components requiring the most disk resources are Service Manager, Operations Manager and Configuration Manager.

  • Disks used should be formatted to a 64K allocation unit size.

  • Disks used should be configured to allow 20% free space after all calculations for monitoring. Set growth upper limits to not exceed this space limit.

  • Pre-sizing is preferred - use auto-grow if needed as it uses more resources.

  • Set Pre-size to 8GB/2GB as a minimum. 20-30% of the database file size is a rule of thumb.

  • Set Auto-grow to 500/100 as a minimum.

This information does not apply to System Center 2012 Configuration Manager. For those system requirements, see Supported Configurations for Configuration Manager

 
Fanden Sie dies hilfreich?
(1500 verbleibende Zeichen)
Vielen Dank für Ihr Feedback.
Anzeigen:
© 2014 Microsoft