SQL Server 2012 Hardware Requirement

Microsoft SQL Server PowerPivot Planning and Deployment

This documentation is archived and is not being maintained.

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.

SQL Server 2012 SP2 is only supported as a database server for installations with Update Rollup 4 applied, except for Operations Manager which supports SQL Server 2012 SP2 without requiring any update rollups.

SQL Server 2014 is only supported as a database server for installations of Orchestrator, SPF and Virtual Machine Manager with Update Rollup 5 applied.

SQL Server 2014 is only supported as a database server for installations of Data Protection Manager (DPM), and Service Manager with Update Rollup 6 applied. A new installation of DPM 2012 R2 cannot work with SQL Server 2014. To use SQL Server 2014 with DPM 2012 R2, you must install DPM 2012 R2 with SQL Server 2012, and then upgrade to SQL Server 2014.

No Update Rollups are required to use SQL Server 2014 as the database Server for Operations Manager.

In the table below all entries for Operations Manager refer to both the Operations Manager database as well as the Audit Collection Services database.

Virtual Machine Manager supports the currently supported Service Pack of SQL Server. This support applies to VMM 2007, VMM 2008, VMM 2008 R2, VMM 2012, and VMM 2012 R2.

App Controller Server ● ● ● Data Protection Manager (DPM) Database ● ● ● ● ● ● ● ● ● Operations Manager Data Warehouse ● ● ● ● ● ● ● ● ● ● Operations Manager Operational Database ● ● ● ● ● ● ● ● ● ● Operations Manager Reporting Server ● ● ● ● ● ● ● ● ● ● Orchestrator Management Server ● ● ● ● ● ● (Since UR8) ● ● Service Management Automation Management Server ● ● ● ● (Since UR7) ● ● Service Manager Database or Data Warehouse Database ● ● ● ● ● ● (Since UR9) ● ● Service Provider Foundation ● ● ● ● Virtual Machine Manager Database Server ● ● ● ● ● ● ●
System Center 2012 R2 component SQL Server 2008 R2 SP1 Standard, Datacenter SQL Server 2008 R2 SP2 Standard, Datacenter SQL Server 2008 R2 SP3 Standard, Datacenter* SQL Server 2012 Enterprise, Standard (64-bit) SQL Server 2012 SP1 Enterprise, Standard (64-bit) SQL Server 2012 SP2 Enterprise, Standard (64 bit) SQL Server 2012 SP3 Enterprise, Standard (64 bit) SQL Server 2014 Enterprise, Standard (64-bit) SQL Server 2014 SP1 Enterprise, Standard (64-bit) SQL Server 2014 SP2 Enterprise, Standard (64-bit)

* If you plan to use SQL Server 2008 R2 SP3 to host your Operations Manager Operational, Reporting Server, or Data Warehouse databases for a new Operations Manager installation you must first install with SQL Server 2008 R2 SP2, and then upgrade SQL Server 2008 R2 to the SP3 version.

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 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.
ZYXEL Zyxel 24 Port Gigabit Switch, Easy Smart Managed, Rackmount, Fanless, w/2x SFP Fiber Uplinks (GS1900-24)
Personal Computer (ZYXEL)
  • Fast networking performance with 24 Gigabit Ethernet ports and non-blocking full bandwidth of 2, Mbps per port
  • Get up and running in minutes: The intuitive web-based set-up wizard enables simple and fast configuration and management, even for non-technical staff
  • Standard 19 rackmount size for server rack deployments in small offices fits most office spaces as our Fanless design ensures quiet operation and higher reliability...
  • Advanced features like VLAN, QoS, IGMP Snooping, Link Aggregation (LAG), IPv6, DoS prevention, and Zyxel ONE network enable better security and management while...
  • Lifetime hardware warranty, free firmware upgrade support and free technical support for long-term assurance
ZYXEL Zyxel Next Generation Unified Security Gateway with WLAN Controller and 4 LAN/DMZ, 2 WAN, 1 OPT Ports [USG110]
Personal Computer (ZYXEL)
  • Includes 1 Year of Anti-Virus (AV), Intrusion Detection and Prevention (IDP), Anti-Spam (AS), and Content Filtering (CF) UTM Services.
  • 7 x GbE RJ-45, 2 x USB (multi-WAN and mobile broadband)
  • 1,600 Mbps firewall throughput
  • 400 Mbps VPN throughput (IPsec/L2TP: 100 Included, SSL: 5 Included Upgradable to 25 Max)
  • Comprehensive Anti-malware threat protection with firewall, Kaspersky anti-virus, content filtering,anti-spam,Intrusion detection and prevention, application intelligence...
  • Built in WLAN Controller for centralized management of ZyXEL access points
  • User-aware policy engine can set bandwith or network access based on user login or using Single Sign On
  • Comprehensive Anti-malware threat protection with firewall, Kaspersky anti-virus,content filtering,anti-spam,Intrusion detection & prevention, application intelligence...
Kuman Kuman SIMCOM SIM900 GSM GPRS Quad-Band Modules 2G Development Shield Board for Arduino UNO R3 Mega with antenna and Nano Sim Adapter
PC Accessory (Kuman)
  • Quad-Band 850/900/1800/1900 MHz - would work on GSM networks in all countries across the world, Work with Arduino Uno Mega; Only work for 2G network
  • Embedded TCP/UDP stack - allows you to upload data to a web server | RTC supported| Selectable serial port | Speaker and Headphone jac
  • Note: This is new version (version 64M), SMS MMS support:multimedia message and Short Message Service - so that you can send small amounts of data over the network...
  • The shield allows you to achieve SMS, MMS, GPRS and Audio via UART by sending AT commands (GSM 07.07 ,07.05 and SIMCOM enhanced AT Commands). The shield also has...
  • Application: M2M (Machine 2 Machine) Applications.Remote control of appliances.Remote Weather station or a Wireless Sensor Network.Vehicle Tracking System with a...
Jinan USR IOT Technology Limited USR-WIFI232-610 Serial RS232 RS485 to Wifi 802.11 b/g/n and Ethernet Converter
PC Accessory (Jinan USR IOT Technology Limited)
  • Can realize RS232/RS485 to RJ45 and RS232/RS485 to WIFI at the same time! Send data from serial port to RJ45 or WIFI,two way transmission. Support WIFI to Ethernet!
  • Unique Features: 1. Start time 6s. 2.Suport TCPB function.3.Support Hardware AP, HTTPD Client and WEB IO. 4.Module as Server, 32 Client can access to it. 5.Support...
  • Wifi Serial Server Feature:1.Support hardware flow control (RTS/CTS) RS232 interface, male mouth(needle) consistent with computer pin definition.2. RS232 RS485 automatic...
  • 4. Rich status indicator light: Power Ready Link RXD TXD. 5.Wifi Serial Server Support I802.11b/g/n Wireless Standards. 6.Support TCP/IP/UDP Network Protocols. 7.Support...
  • 9.Support Router/Bridge Mode Networking. 10.Support External Antenna. 11.Support Transparent Transmission Mode. 12.Wifi Serial Server Support AT+ Instruction Set...
Western Digital WD XE 900 GB Enterprise Hard Drive: 2.5 Inch, 10000 RPM, SAS, 32 MB Cache - WD9001BKHG
Personal Computer (Western Digital)
  • Ideal for demanding high-performance computing and mission-critical environments
  • Ultra-fast 6 Gb/s SAS storage, with low power consumption and the industry s highest reliability rating
  • Dual port, full duplex connectivity offers higher reliability, performance and data availability by eliminating single points of failure - optimal for high availability...
  • Works with Windows, Windows server, Linux, and Mac, Note: Compatibility may vary depending on user s hardware configuration and operating system
  • 5 year limited warranty

Related posts: