Home Forums Data Warehousing Analysis Services Cube processing very slow - Profiler shows Discover XML metadata RE: Cube processing very slow - Profiler shows Discover XML metadata

  • the cube size is about 70 GB. it was running fine a few days ago and it is very slow now. We don't have a lot of aggregations. But it seems like it hangs at some point and just doesn't show any activity than discover_xml_metadata..

    <PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis">

    <LocaleIdentifier>1033</LocaleIdentifier>

    <DbpropMsmdActivityID>7da3ab8a-4e2a-4f7f-9b49-ece44fd427d8</DbpropMsmdActivityID>

    <DbpropMsmdRequestID>ac8bd221-07c9-4d44-8238-cd7c3e2e7c99</DbpropMsmdRequestID>

    </PropertyList>

    not sure what is going in the background. If the look at memory and CPU SSAS consumes at this point, Memory remains constant and is acceptable(we have 64 GB available and usage ie much lower). CPU shows 0.

    Not sure what could be blocking.

    Thanks.