FIX: SSAS uses only 20 cores in SQL Server 2012 Business Intelligence

Article translations Article translations
Article ID: 2685308 - View products that this article applies to.
Expand all | Collapse all

On This Page

Symptoms

Assume that you have a system that has more than 20 cores. When you run an instance of Microsoft SQL Server Analysis Services (SSAS) in Microsoft SQL Server 2012 Business Intelligence on the system, SQL Server Analysis Services uses only the first 20 cores.

Resolution

To resolve this issue, contact Microsoft Customer Support Services to obtain the hotfix that is described in this article. After you apply the hotfix, SQL Server Analysis Services is supported to use the maximum number of cores for an operating system. For more information, visit the following MSDN website:
Compute Capacity Limits by Edition of SQL Server

Cumulative update information

SQL Server 2012

The fix for this issue was first released in Cumulative Update 1 for SQL Server 2012. For more information about how to obtain this cumulative update package for SQL Server, click the following article number to view the article in the Microsoft Knowledge Base:
2679368 Cumulative update 1 for SQL Server 2012
Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2692828 The SQL Server 2012 builds that were released after SQL Server 2012 was released

Hotfix information

A supported hotfix is now available from Microsoft. However, it is intended to correct only the problem that this article describes. Apply it only to systems that are experiencing this specific problem.

To resolve this problem, contact Microsoft Customer Support Services to obtain the hotfix. For a complete list of Microsoft Customer Support Services telephone numbers and information about support costs, visit the following Microsoft website:
http://support.microsoft.com/contactus/?ws=support
Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

Prerequisites

To apply this hotfix, you must have the Microsoft SQL Server 2012 installed.

Restart requirement

You do not have to restart the computer after you apply the hotfix. However, you do have to restart the services that are affected by the hotfix.

Hotfix replacement information

This hotfix does not replace a previously released hotfix.

File information

The global version of this update has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

x86 version

Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Addnode.xmlNot Applicable7,70311-Feb-201200:01Not Applicable
Completeclusterwizard.xmlNot Applicable10,27111-Feb-201200:01Not Applicable
Componentupdate.xmlNot Applicable3,53011-Feb-201200:01Not Applicable
Configuration.uicfgNot Applicable6,92711-Feb-201200:01Not Applicable
Editionupgradewizard.xmlNot Applicable5,28611-Feb-201200:01Not Applicable
Fixsqlregistrykey_x64.exe11.0.2100.6056,40811-Feb-201215:54x64
Fixsqlregistrykey_x64.exe.configNot Applicable32910-Feb-201223:29Not Applicable
Fixsqlregistrykey_x86.exe11.0.2100.6060,50411-Feb-201217:11x86
Fixsqlregistrykey_x86.exe.configNot Applicable32910-Feb-201223:29Not Applicable
Fusioncheck.dll2009.100.2500.014,17610-Feb-201223:33x86
Installclusterwizard.xmlNot Applicable16,54311-Feb-201200:01Not Applicable
Installwizard.xmlNot Applicable16,57411-Feb-201200:01Not Applicable
Landingpage.exe11.0.2214.0453,52803-Apr-201211:06x86
Landingpage.exe.configNot Applicable32910-Feb-201223:29Not Applicable
Microsoft.analysisservices.sharepoint.integration.dll11.0.2100.60908,37611-Feb-201217:08x86
Microsoft.datawarehouse.sqm.dll11.0.2100.6080,98411-Feb-201217:07x86
Microsoft.netenterpriseservers.exceptionmessagebox.dll11.0.2100.60146,52011-Feb-201217:07x86
Microsoft.sql.chainer.package.dll11.0.2100.6060,50411-Feb-201217:06x86
Microsoft.sql.chainer.packagedata.dll11.0.2214.0146,32803-Apr-201211:05x86
Microsoft.sql.chainer.product.dll11.0.2214.0277,40003-Apr-201211:05x86
Microsoft.sqlserver.chainer.extensioncommon.dll11.0.2214.0121,75203-Apr-201211:04x86
Microsoft.sqlserver.chainer.infrastructure.dll11.0.2214.0404,37603-Apr-201211:04x86
Microsoft.sqlserver.chainer.workflowdata.dll11.0.2214.0695,19203-Apr-201211:04x86
Microsoft.sqlserver.configuration.agentextension.dll11.0.2214.0142,23203-Apr-201211:04x86
Microsoft.sqlserver.configuration.asextension.dll11.0.2214.0437,14403-Apr-201211:04x86
Microsoft.sqlserver.configuration.bootstrapextension.dll11.0.2214.093,08003-Apr-201211:04x86
Microsoft.sqlserver.configuration.cluster.dll11.0.2214.0715,67203-Apr-201211:04x86
Microsoft.sqlserver.configuration.configextension.dll11.0.2214.097,17603-Apr-201211:04x86
Microsoft.sqlserver.configuration.connectioninfo.dll11.0.2100.60171,09611-Feb-201217:06x86
Microsoft.sqlserver.configuration.distributedreplayextension.dll11.0.2100.6085,08011-Feb-201217:06x86
Microsoft.sqlserver.configuration.dll11.0.2214.0228,24803-Apr-201211:04x86
Microsoft.sqlserver.configuration.dmf.dll11.0.2100.60359,51211-Feb-201217:06x86
Microsoft.sqlserver.configuration.fulltext_configextension.dll11.0.2214.093,08003-Apr-201211:04x86
Microsoft.sqlserver.configuration.installwizard.dll11.0.2214.01,616,79203-Apr-201211:04x86
Microsoft.sqlserver.configuration.installwizardframework.dll11.0.2214.080,79203-Apr-201211:04x86
Microsoft.sqlserver.configuration.managementtoolsextension.dll11.0.2214.056,21603-Apr-201211:04x86
Microsoft.sqlserver.configuration.msiextension.dll11.0.2214.0338,84003-Apr-201211:04x86
Microsoft.sqlserver.configuration.packagechainerextension.dll11.0.2214.0162,71203-Apr-201211:04x86
Microsoft.sqlserver.configuration.powershellextension.dll11.0.2214.064,40803-Apr-201211:04x86
Microsoft.sqlserver.configuration.repl_configextension.dll11.0.2214.060,31203-Apr-201211:04x86
Microsoft.sqlserver.configuration.rsextension.dll11.0.2214.0408,47203-Apr-201211:04x86
Microsoft.sqlserver.configuration.rsshpextension.dll11.0.2100.60371,80011-Feb-201217:06x86
Microsoft.sqlserver.configuration.rulesengineextension.dll11.0.2214.0109,46403-Apr-201211:04x86
Microsoft.sqlserver.configuration.sco.dll11.0.2214.02,018,20003-Apr-201211:04x86
Microsoft.sqlserver.configuration.scoextension.dll11.0.2214.0244,63203-Apr-201211:04x86
Microsoft.sqlserver.configuration.setupextension.dll11.0.2214.01,153,94403-Apr-201211:04x86
Microsoft.sqlserver.configuration.sfc.dll11.0.2100.60506,96811-Feb-201217:05x86
Microsoft.sqlserver.configuration.slpextension.dll11.0.2214.072,60003-Apr-201211:04x86
Microsoft.sqlserver.configuration.smartsetupextension.dll11.0.2214.0240,53603-Apr-201211:04x86
Microsoft.sqlserver.configuration.smo.dll11.0.2100.603,599,44811-Feb-201217:05x86
Microsoft.sqlserver.configuration.sniserverconfigext.dll2011.110.2100.60294,48811-Feb-201217:05x86
Microsoft.sqlserver.configuration.sqlbrowserextension.dll11.0.2214.0138,13603-Apr-201211:04x86
Microsoft.sqlserver.configuration.sqlconfigbase.dll11.0.2214.068,50403-Apr-201211:04x86
Microsoft.sqlserver.configuration.sqlenum.dll11.0.2100.601,317,97611-Feb-201217:05x86
Microsoft.sqlserver.configuration.sqlserver_configextension.dll2011.110.2214.0695,70403-Apr-201211:04x86
Microsoft.sqlserver.configuration.ssisextension.dll11.0.2214.088,98403-Apr-201211:04x86
Microsoft.sqlserver.configuration.sstring.dll11.0.2100.6044,12011-Feb-201217:05x86
Microsoft.sqlserver.configuration.uiextension.dll11.0.2214.0109,46403-Apr-201211:04x86
Microsoft.sqlserver.configuration.utilityextension.dll11.0.2100.6044,12011-Feb-201217:05x86
Microsoft.sqlserver.configuration.wizardframework.dll11.0.2214.0220,05603-Apr-201211:03x86
Microsoft.sqlserver.configuration.wmiinterop.dll11.0.2100.60339,03211-Feb-201217:05x86
Microsoft.sqlserver.deployment.dll11.0.2100.60203,86411-Feb-201217:05x86
Microsoft.sqlserver.diagnostics.configuration.strace.dll11.0.2100.60130,13611-Feb-201217:05x86
Microsoft.sqlserver.discovery.dll11.0.2214.0371,60803-Apr-201211:03x86
Microsoft.sqlserver.interop.taskschd.dll11.0.0.064,40803-Apr-201211:05x86
Microsoft.sqlserver.interop.wuapilib.dll11.0.0.0101,46411-Feb-201215:48x86
Microsoft.sqlserver.management.controls.dll11.0.2100.60314,45611-Feb-201217:04x86
Microsoft.sqlserver.setup.chainer.workflow.dll11.0.2214.0109,46403-Apr-201210:59x86
Microsoft.sqlserver.sqm.dll11.0.2214.072,60003-Apr-201210:59x86
Microsoft.vc80.crt.manifestNot Applicable52811-Feb-201201:32Not Applicable
Msvcm80.dll8.0.50727.4027494,68011-Feb-201217:03x86
Msvcp100.dll10.0.40219.1421,20011-Feb-201201:33x86
Msvcp80.dll8.0.50727.4027554,83211-Feb-201201:33x86
Msvcr100.dll10.0.40219.1773,96811-Feb-201201:33x86
Msvcr80.dll8.0.50727.4027632,65611-Feb-201201:33x86
Package.xsdNot Applicable16,35002-Apr-201223:09Not Applicable
Patchwizard.xmlNot Applicable4,80511-Feb-201200:01Not Applicable
Pidgenx.dll14.0.466.4001,248,01610-Feb-201223:33x86
Pidprivateconfigobjectmaps.xmlNot Applicable21,50010-Feb-201223:30Not Applicable
Prepareclusterwizard.xmlNot Applicable9,77811-Feb-201200:01Not Applicable
Prodkey.dll14.0.466.40043,28010-Feb-201223:33x86
Removenode.xmlNot Applicable4,54211-Feb-201200:01Not Applicable
Removepatchwizard.xmlNot Applicable4,45411-Feb-201200:01Not Applicable
Repairwizard.xmlNot Applicable4,34311-Feb-201200:01Not Applicable
Runrulesui.xmlNot Applicable1,26711-Feb-201200:01Not Applicable
Scenarioengine.exe11.0.2214.076,69603-Apr-201211:06x86
Setup100.exe.configNot Applicable32910-Feb-201223:29Not Applicable
Sqlcab.dll2011.110.2100.6090,71211-Feb-201217:02x86
Sqlconf.dll2011.110.2100.6046,68011-Feb-201217:03x86
Sqlprocesssub.dll2011.110.2100.6062,04011-Feb-201217:00x86
Sqlsccn.dll2011.110.2100.6051,80011-Feb-201217:00x86
Sqmapi.dll6.0.6000.16386149,59211-Feb-201217:00x86
Uninstallwizard.xmlNot Applicable4,33911-Feb-201200:01Not Applicable
Upgradewizard.xmlNot Applicable11,78811-Feb-201200:01Not Applicable

x64-based version

Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Addnode.xmlNot Applicable7,70311-Feb-201200:01Not Applicable
Completeclusterwizard.xmlNot Applicable10,27111-Feb-201200:01Not Applicable
Componentupdate.xmlNot Applicable3,53011-Feb-201200:01Not Applicable
Configuration.uicfgNot Applicable6,92711-Feb-201200:01Not Applicable
Editionupgradewizard.xmlNot Applicable5,28611-Feb-201200:01Not Applicable
Fixsqlregistrykey_x64.exe11.0.2100.6056,40811-Feb-201215:54x64
Fixsqlregistrykey_x64.exe.configNot Applicable32910-Feb-201223:29Not Applicable
Fixsqlregistrykey_x86.exe11.0.2100.6060,50411-Feb-201217:11x86
Fixsqlregistrykey_x86.exe.configNot Applicable32910-Feb-201223:29Not Applicable
Fusioncheck.dll2009.100.2500.014,68810-Feb-201223:28x64
Installclusterwizard.xmlNot Applicable16,54311-Feb-201200:01Not Applicable
Installwizard.xmlNot Applicable16,57411-Feb-201200:01Not Applicable
Landingpage.exe11.0.2214.0449,43203-Apr-201211:06x64
Landingpage.exe.configNot Applicable32910-Feb-201223:29Not Applicable
Microsoft.analysisservices.sharepoint.integration.dll11.0.2100.60908,37611-Feb-201215:52x86
Microsoft.datawarehouse.sqm.dll11.0.2100.6080,98411-Feb-201217:07x86
Microsoft.netenterpriseservers.exceptionmessagebox.dll11.0.2100.60146,52011-Feb-201215:50x86
Microsoft.sql.chainer.package.dll11.0.2100.6060,50411-Feb-201215:49x86
Microsoft.sql.chainer.packagedata.dll11.0.2214.0146,32803-Apr-201211:01x86
Microsoft.sql.chainer.product.dll11.0.2214.0277,40003-Apr-201211:01x86
Microsoft.sqlserver.chainer.extensioncommon.dll11.0.2214.0121,75203-Apr-201211:01x86
Microsoft.sqlserver.chainer.infrastructure.dll11.0.2214.0404,37603-Apr-201211:00x86
Microsoft.sqlserver.chainer.workflowdata.dll11.0.2214.0695,19203-Apr-201211:00x86
Microsoft.sqlserver.configuration.agentextension.dll11.0.2214.0142,23203-Apr-201211:00x86
Microsoft.sqlserver.configuration.asextension.dll11.0.2214.0437,14403-Apr-201211:00x86
Microsoft.sqlserver.configuration.bootstrapextension.dll11.0.2214.093,08003-Apr-201211:00x86
Microsoft.sqlserver.configuration.cluster.dll11.0.2214.0715,67203-Apr-201211:00x86
Microsoft.sqlserver.configuration.configextension.dll11.0.2214.097,17603-Apr-201211:00x86
Microsoft.sqlserver.configuration.connectioninfo.dll11.0.2100.60171,09611-Feb-201215:49x86
Microsoft.sqlserver.configuration.distributedreplayextension.dll11.0.2100.6085,08011-Feb-201215:49x86
Microsoft.sqlserver.configuration.dll11.0.2214.0228,24803-Apr-201211:00x86
Microsoft.sqlserver.configuration.dmf.dll11.0.2100.60359,51211-Feb-201215:49x86
Microsoft.sqlserver.configuration.fulltext_configextension.dll11.0.2214.093,08003-Apr-201211:00x86
Microsoft.sqlserver.configuration.installwizard.dll11.0.2214.01,616,79203-Apr-201211:00x86
Microsoft.sqlserver.configuration.installwizardframework.dll11.0.2214.080,79203-Apr-201211:00x86
Microsoft.sqlserver.configuration.managementtoolsextension.dll11.0.2214.056,21603-Apr-201211:00x86
Microsoft.sqlserver.configuration.msiextension.dll11.0.2214.0338,84003-Apr-201211:00x86
Microsoft.sqlserver.configuration.packagechainerextension.dll11.0.2214.0162,71203-Apr-201211:00x86
Microsoft.sqlserver.configuration.powershellextension.dll11.0.2214.064,40803-Apr-201211:00x86
Microsoft.sqlserver.configuration.repl_configextension.dll11.0.2214.060,31203-Apr-201211:00x86
Microsoft.sqlserver.configuration.rsextension.dll11.0.2214.0408,47203-Apr-201211:00x86
Microsoft.sqlserver.configuration.rsshpextension.dll11.0.2100.60371,80011-Feb-201215:49x86
Microsoft.sqlserver.configuration.rulesengineextension.dll11.0.2214.0109,46403-Apr-201211:00x86
Microsoft.sqlserver.configuration.sco.dll11.0.2214.02,018,20003-Apr-201211:00x86
Microsoft.sqlserver.configuration.scoextension.dll11.0.2214.0244,63203-Apr-201211:00x86
Microsoft.sqlserver.configuration.setupextension.dll11.0.2214.01,153,94403-Apr-201211:00x86
Microsoft.sqlserver.configuration.sfc.dll11.0.2100.60506,96811-Feb-201215:49x86
Microsoft.sqlserver.configuration.slpextension.dll11.0.2214.072,60003-Apr-201211:00x86
Microsoft.sqlserver.configuration.smartsetupextension.dll11.0.2214.0240,53603-Apr-201211:00x86
Microsoft.sqlserver.configuration.smo.dll11.0.2100.603,599,44811-Feb-201215:49x86
Microsoft.sqlserver.configuration.sniserverconfigext.dll2011.110.2100.60331,35211-Feb-201215:49x64
Microsoft.sqlserver.configuration.sqlbrowserextension.dll11.0.2214.0138,13603-Apr-201210:59x86
Microsoft.sqlserver.configuration.sqlconfigbase.dll11.0.2214.068,50403-Apr-201210:59x86
Microsoft.sqlserver.configuration.sqlenum.dll11.0.2100.601,317,97611-Feb-201215:49x86
Microsoft.sqlserver.configuration.sqlserver_configextension.dll2011.110.2214.0726,42403-Apr-201210:59x64
Microsoft.sqlserver.configuration.ssisextension.dll11.0.2214.088,98403-Apr-201210:59x86
Microsoft.sqlserver.configuration.sstring.dll11.0.2100.6044,12011-Feb-201215:49x86
Microsoft.sqlserver.configuration.uiextension.dll11.0.2214.0109,46403-Apr-201210:59x86
Microsoft.sqlserver.configuration.utilityextension.dll11.0.2100.6044,12011-Feb-201215:49x86
Microsoft.sqlserver.configuration.wizardframework.dll11.0.2214.0220,05603-Apr-201210:59x86
Microsoft.sqlserver.configuration.wmiinterop.dll11.0.2100.60339,03211-Feb-201215:49x86
Microsoft.sqlserver.deployment.dll11.0.2100.60203,86411-Feb-201215:49x86
Microsoft.sqlserver.diagnostics.configuration.strace.dll11.0.2100.60130,13611-Feb-201215:49x86
Microsoft.sqlserver.discovery.dll11.0.2214.0371,60803-Apr-201211:00x86
Microsoft.sqlserver.interop.taskschd.dll11.0.0.064,40803-Apr-201211:05x86
Microsoft.sqlserver.interop.wuapilib.dll11.0.0.0101,46411-Feb-201215:48x86
Microsoft.sqlserver.management.controls.dll11.0.2100.60310,36011-Feb-201215:48x64
Microsoft.sqlserver.setup.chainer.workflow.dll11.0.2214.0109,46403-Apr-201211:04x86
Microsoft.sqlserver.sqm.dll11.0.2214.072,60003-Apr-201211:03x86
Microsoft.vc80.crt.manifestNot Applicable53011-Feb-201202:05Not Applicable
Msvcm80.dll8.0.50727.4027530,52011-Feb-201215:46x64
Msvcp100.dll10.0.40219.1608,08011-Feb-201202:05x64
Msvcp80.dll8.0.50727.40271,068,36811-Feb-201202:05x64
Msvcr100.dll10.0.40219.1829,26411-Feb-201202:05x64
Msvcr80.dll8.0.50727.4027802,62411-Feb-201202:05x64
Package.xsdNot Applicable16,35002-Apr-201223:09Not Applicable
Patchwizard.xmlNot Applicable4,80511-Feb-201200:01Not Applicable
Pidgenx.dll14.0.466.4001,463,56810-Feb-201223:28x64
Pidprivateconfigobjectmaps.xmlNot Applicable21,50010-Feb-201223:30Not Applicable
Prepareclusterwizard.xmlNot Applicable9,77811-Feb-201200:01Not Applicable
Prodkey.dll14.0.466.40048,40010-Feb-201223:28x64
Removenode.xmlNot Applicable4,54211-Feb-201200:01Not Applicable
Removepatchwizard.xmlNot Applicable4,45411-Feb-201200:01Not Applicable
Repairwizard.xmlNot Applicable4,34311-Feb-201200:01Not Applicable
Runrulesui.xmlNot Applicable1,26711-Feb-201200:01Not Applicable
Scenarioengine.exe11.0.2214.072,60003-Apr-201211:06x64
Setup100.exe.configNot Applicable32910-Feb-201223:29Not Applicable
Sqlcab.dll2011.110.2100.60109,14411-Feb-201215:44x64
Sqlconf.dll2011.110.2100.6054,36011-Feb-201215:44x64
Sqlprocesssub.dll2011.110.2100.6071,25611-Feb-201215:43x64
Sqlsccn.dll2011.110.2100.6058,45611-Feb-201215:43x64
Sqmapi.dll6.0.6000.16386182,87211-Feb-201215:43x64
Uninstallwizard.xmlNot Applicable4,33911-Feb-201200:01Not Applicable
Upgradewizard.xmlNot Applicable11,78811-Feb-201200:01Not Applicable

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 2685308 - Last Review: November 22, 2012 - Revision: 3.2
Applies to
  • Microsoft SQL Server 2012 Business Intelligence
Keywords: 
kbtshoot kbqfe kbfix kbexpertiseadvanced kbsurveynew kbhotfixserver KB2685308

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com