FIX: Poor performance in SSAS 2008 R2 when the number of concurrent users increases

Gilt für: SQL Server 2008 R2 Service Pack 2

Symptoms


When the number of concurrent users increases in Microsoft SQL Server 2008 R2 Analysis Services (SSAS 2008 R2), the execution time of each discover MDSCHEMA_CUBES request increases. You may experience poor performance in SSAS 2008 R2.

Resolution


The issue was first fixed in the following cumulative update of SQL Server.

Cumulative Update 13 for SQL Server 2008 R2 SP2

Status


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