Choosing SQL Versions
Another issue is the edition of SQL to use. For Configuration Manager, which leverages the power of SQL heavily, there can be serious performance impacts in choosing the wrong edition of SQL. SQL Server Enterprise Edition is designed to scale to the largest of hardware platforms and handle large workloads, but has an associated high cost. SQL Server Standard Edition has built-in technology scalability limitations, but a much lower cost.
SQL Server Enterprise Edition supports more parallel operations, allowing multiple databases to coexist. Both Enterprise and Standard Editions support parallel queries, but only Enterprise Edition supports parallel index and consistency check operations. Enterprise Edition has a host of other ...
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.
