Out of Memory problems creating an SSAS Tabular Model

  • I'm trying to design a Tabular Model but when I point the Table Import Wizard at my primary fact table, I get an out of memory error that says to try it with a 64 bit version of the product.

    Except that I'm working in Visual Studio/SSDT and there isn't a 64bit version of that that I am aware of.

    Is there a way to work around the fact that Visual Studio can't use more than 32 bits, but once I deploy the model I'll be ok?



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • Did you install the 32 or 64-bit SSAS server in tab mode on your machine?

    Steve.

  • 64-bit.

    The server instance I specified has 32 GB of Ram... I suppose that I'm actually exhausting ram on the server, and not my desktop?



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • Could be. What's your estimated row count? Are you using partitions?

    Steve.

  • I haven't gotten to the point where I could specify partitions...

    The estimaed row count is 650,135,000 rows.



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply