Export (0) Print
Expand All
13 out of 24 rated this helpful - Rate this topic

System Requirements: VMM Database

Updated: March 11, 2014

Applies To: System Center 2012 - Virtual Machine Manager, System Center 2012 R2 Virtual Machine Manager, System Center 2012 SP1 - Virtual Machine Manager

This topic provides information about the system requirements for the SQL Server-based database for VMM in System Center 2012 R2.

If you are using Software Defined Networking (SDN) in VMM, all networking information is stored on the VMM database. As such, there are a couple of best practices to consider for this database:

Database hardware requirements

The following tables provide the minimum and recommended hardware requirements for the System Center 2012 – Virtual Machine Manager (VMM) database. These requirements are based on the number of hosts that you manage. For best performance, we recommend that you store the VMM database on a disk other than the disk on which the operating system is installed.

Managing up to 150 hosts

 

Hardware component Minimum Recommended

Processor

Pentium 4, 2.8 gigahertz (GHz)

Dual-core 64-bit, 2 GHz

RAM

2 gigabytes (GB)

4 GB

Hard disk (on which the operating system is installed)

80 GB

150 GB

Hard disk free space (on which the database is stored)

20 GB

50 GB

Managing more than 150 hosts

 

Hardware component Minimum Recommended

Processor

Dual-core 64-bit, 2 GHz

Dual-core 64-bit, 2.8 GHz

RAM

4 GB

8 GB

Hard disk (on which the operating system is installed)

150 GB

200 GB

Hard disk free space (on which the database is stored)

50 GB

75 GB

Supported versions of SQL Server

To host the VMM database, VMM supports the following versions of Microsoft SQL Server software.

 

SQL Server for System Center 2012 – Virtual Machine Manager Service pack Editions

SQL Server 2008 R2 (64-bit)

Service Pack 2 or earlier

Standard, Enterprise, and Datacenter

SQL Server 2008 (64-bit)

Service Pack 2 or Service Pack 3

Standard and Enterprise

 

SQL Server for VMM in System Center 2012 SP1 Service pack Editions

SQL Server 2008 R2

Service Pack 1 or Service Pack 2

Standard, Enterprise, and Datacenter (64-bit)

SQL Server 2012

With or without Service Pack 1

Standard and Enterprise (64-bit)

 

SQL Server for VMM in System Center 2012 R2 Service pack Editions

SQL Server 2008 R2

Service Pack 2 or Service Pack 3

Standard, Enterprise, and Datacenter (64-bit)

SQL Server 2012

With or without Service Pack 1

Standard and Enterprise (64-bit)

Additional requirements and information

  • You must use an instance of SQL Server that allows case-insensitive database objects.

  • The name of the computer on which SQL Server runs cannot exceed 15 characters in length.

  • When you install SQL Server, select the Database Engine Services and Management Tools - Complete features.

  • If the VMM management server and the computer on which SQL Server runs are not members of the same Active Directory domain, a two-way trust must exist between the two domains.

  • As of System Center 2012 R2 you do not need to configure collation. During deployment, Setup automatically configures CI collation according to the language of the server operating system.

  • For more information about SQL Server and System Center R2, see SQL 2012 and System Center 2012 R2.

-----
For additional resources, see Information and Support for System Center 2012.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
-----
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.