Q: What version of Microsoft SQL Server rights do I get with System Center 2012 and are there any benefits to using Enterprise?

System Center 2012 includes some rights to use SQL Server. Here's what they are.

John Savill

June 13, 2012

1 Min Read
ITPro Today logo in a gray background | ITPro Today

A:System Center 2012 includes rights to use SQL Server Standard edition for use with the System Center 2012 server roles, but not SQL Enterprise or highereditions.

There are some benefits to using Enterprise beyond obvious features such as high availability for databases.

If you have licenses for SQL ServerEnterprise edition, you can use those licensed Enterprise SQL servers with System Center 2012.

System Center Service Manager 2012 behaves differently whenleveraging SQL Server Enterprise edition, as documented at "SQL Server Requirements for System Center 2012 - Service Manager." The differences in behavior include these:

  • Analysis Services Files--In SQL Server 2008 Enterprise edition, you can decide where Analysis Services database files will be stored. In the Standard edition, there is only one default location for the files.

  • Cube Processing--In SQL Server 2008 Enterprise edition, cubes are processed incrementally each night. In the Standard edition, the entire cube is processed each night and therefore, the amount of processing time required will increase as more data is accumulated. Cubes can still be queried when being processed however, reporting performance will be reduced.

  • Measure Group Partitions--In SQL Server 2008 Enterprise edition, measure groups are partitioned on a monthly basis, instead of as one large partition. This reduces the amount of time it takes to process the partition.

  • PowerPivot--In SQL Server 2008 Enterprise edition, you can use PowerPivot for SharePoint.

To see more answers about System Center 2012, Windows 8, virtualization, and all things IT,  click over to our FAQs page.

About the Author

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like