Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Out of Memory problems creating an SSAS Tabular Model Expand / Collapse
Author
Message
Posted Tuesday, March 12, 2013 10:24 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 7:42 AM
Points: 3,688, Visits: 72,435
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
For tips on how to post your problems
Post #1429939
Posted Tuesday, March 12, 2013 2:21 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, December 17, 2014 6:34 PM
Points: 1,846, Visits: 3,575
Did you install the 32 or 64-bit SSAS server in tab mode on your machine?


Steve.
Post #1430090
Posted Tuesday, March 12, 2013 2:24 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 7:42 AM
Points: 3,688, Visits: 72,435
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
For tips on how to post your problems
Post #1430092
Posted Tuesday, March 12, 2013 2:43 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, December 17, 2014 6:34 PM
Points: 1,846, Visits: 3,575
Could be. What's your estimated row count? Are you using partitions?


Steve.
Post #1430108
Posted Wednesday, March 13, 2013 7:03 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 7:42 AM
Points: 3,688, Visits: 72,435
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
For tips on how to post your problems
Post #1430357
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse