Choosing SQL Versions

Another issue is the edition of SQL Server to use. For Operations Manager, which leverages the power of SQL Server heavily, there can be serious performance impacts in choosing the wrong edition of SQL Server. The current version of SQL Server 2008 R2 has significant performance improvements over previous versions, especially when combined with Windows Server 2008 R2. The R2 versions of Windows Server 2008 and SQL Server 2008 are really a better-together combination, which OpsMgr 2012 can really take advantage of.

Not only does the version make a difference, but the edition of SQL Server makes a difference as well. SQL Server Enterprise Edition is designed to scale to the largest of hardware platforms and handle large workloads, ...

Get Microsoft® System Center 2012 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.