System Center Cube

 Limit each SQL Instance memory where the SQL total memory setting allows a minimum of 1 GB and preferably 2 GB of free memory after all services are running.

• SQL Server will need to be Standard or Enterprise edition (Data center in some situations)
• Install dual gigabit network adapters teamed with full duplex
• Disks should be formatted to a 64K allocation unit size
• Disks should be configured to allow 20% free space after all calculations for monitoring and set growth upper limits to not exceed this space limit.
• The SQL Cluster should be running Active-Passive unless resources are proved to be insufficient
• Common objections to sharing databases is contention for resources resulting in bottlenecks – processors, memory, and especially disk spindles. Use Operations Manager to identify these potential bottlenecks.
• Ops Mgr will not support SQL dynamic ports which is the default SQL setting, change each SQL instance dynamic port to a TCP port.
• If OpsMgr will be providing monitoring for network devices, increase the size of the SQL temp in that instance.
• Set the SQL Database Engine Domain Account(s) to auto register the SQL SPN values which occurs every time the service starts up
• If you are using heart beat and iSCSI connections – make sure to remove all connection options except IPv4 and remove any DNS and Gateway entries as well.

 The SystemCenterCube element defines the OLAP cube to a varying degree of detail, depending on your specific needs. This element contains the following sub elements:

• Measure Group
• Substitution
• CustomMDX
• NamedCalculation
• Measure
• KPI
• Action (however, only drill-through actions are supported currently)
• ManyToManyRelationship