none
BIDS Query Designer very slow in VS 2008

    Question

  • I am in the process of upgrading my Report Server projects from 2005 to 2008.  These reports use an Analysis Services 2005 data source and have queries that are anywhere from 20 to 100 lines of MDX.  After upgrading a report, when I open or save a dataset in the Query Designer, it takes up to 20 seconds.  In 2005, this would happen almost instantly.

    Running SQL Server Profiler, I see that there is an extensive number (600+) of Discover events going on with the Analysis Services server while the Query Designer loads.

    My version of Visual Studio is 9.0.30729.1 SP and I am running Windows XP SP2.

    Thanks,
    Mitch
    Thursday, August 13, 2009 12:47 AM

All replies

  • I am still experiencing this with 2008 R2.
    Tuesday, July 6, 2010 8:10 PM
  • There are thousands of the following events that happen on the SSAS server when the Query Designer is opened or closed.

     

     

    <RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis">
      <CUBE_NAME>Cube Name</CUBE_NAME>
      <CUBE_SOURCE>3</CUBE_SOURCE>
      <MEASURE_VISIBILITY>3</MEASURE_VISIBILITY>
     </RestrictionList>
    
    <PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis">
      <Catalog>Database Name</Catalog>
      <LocaleIdentifier>1033</LocaleIdentifier>
      <ShowHiddenCubes>true</ShowHiddenCubes>
      <Content>Data</Content>
      <Format>Tabular</Format>
     </PropertyList>

     

    Thursday, August 19, 2010 5:36 AM
  • I'm experiencing the same thing!
    Thursday, September 2, 2010 12:43 PM