Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. BIDS can take minutes to load a project with above 100 dimensions

BIDS can take minutes to load a project with above 100 dimensions

Symptoms

When the BI Developer Studio (BIDS) for SQL Server 2008 and SQL Server 2008 R2 is used to load a SSAS project having more than 100 dimensions, the load could take several minutes.

↑ Back to the top

Cause

The issue is caused by a mismatch of two different existing Images of “Microsoft.DataWarehouse.VsIntegration.dll” and “Microsoft.AnalysisServices.Project.DLL”

The “Microsoft.AnalysisServices.Project.DLL” is successfully compiled to a Native Image (NI) “Microsoft.AnalysisServices.Project.NI.DLL” and the “Microsoft.DataWarehouse.VsIntegration.dll” does not exist as NI.

↑ Back to the top

Resolution

To fix this mismatch you can ran following command, which produces a NI using “ngen.exe” ("C:\Windows\Microsoft.NET\Framework\v2.0.50727\ngen.exe"):

ngen.exe install /ExeConfig:"C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\devenv.exe" “C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\Microsoft.DataWarehouse.VsIntegration.dll”

After this there will be created a NI “Microsoft.DataWarehouse.VsIntegration.NI.dll” in the native Image Cache.

↑ Back to the top

More Information

This behavior is a bug in .NET 3.5 and 4.0, which will be addressed in a future release of .NET.

Normally this kind of mismatch of IL (Intermediate Language) Assemblies and NI (native Images) does not matter and both can coexist without any issue. An IL-Assembly is just compiled during each first usage to x86/x64 code, which increases the Start time a little bit. But after this also native Code is running, as fast as NI’s, too.

This Compilation-Step can be omitted if an NI is available in the Cache.

But in this special Scenario within BIDS it leads to the situation that a “wrong” (too long) code path is used, which generates this huge amount of load time.

↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 2627092
Revision : 1
Created on : 1/7/2017
Published on : 10/7/2011
Exists online : False
Views : 174