Hi we run 2017 std, only ssas is running (not the engine) on the server in question. i ran something like what you see in the code block for sizing my model. The query returns 7,464,080,554.0 bytes.
I seem able to process my tables under vs. And see the data and calc'd measures in the grid view. my server has 32 gig of ram and only 5 of that was in use when I first attempted deployment.
my hard mem limit is 0 value,0 current value,0 default value. low mem limit (Will says not relevant to tabular, Himanshu seems to disagree at
https://blogs.msdn.microsoft.com/himanshu1/2013/04/15/understanding-memory-configuration-in-bi-semantic-model/) 65%,65%,65%. Total mem limit is 80%,80%,80%. vertipaq mem limit is 60%,60%,60%. whether those percents are against the 32 gig
or the 16 gig max for std or one of those values minus os ram reqmts is beyond me. And seemingly nowhere to be found online.
I got an error saying...
Failed to save modifications to the server. Error returned: 'There's not enough memory to complete this operation. Please try again later when there may be more memory available.
'.
...when I tried to deploy.
Even if I got zero compression wouldn't you think my model should have deployed?
;with cte as
(select 'dimA' t_name,count(*) countstar from star.dimA union all
select 'dimB' t_name,count(*) countstar from star.dimB union all
select 'dimC' t_name,count(*) countstar from star.dimC union all
select 'dimD' t_name,count(*) countstar from star.dimD union all
select 'dimE' t_name,count(*) countstar from star.dimE union all
select 'dimF' t_name,count(*) countstar from star.dimF union all
select 'factA' t_name,count(*) countstar from star.factA union all
select 'factB' t_name,count(*) countstar from star.factB --union all
)
select --*,storagesize * countstar extended--
sum (storagesize * countstar) totalreqmt --7,464,080,554.0
from
(
select table_schema,table_name,column_name,data_type, case when data_type='int' then 4
when data_type='bigint' then 8
when data_type='tinyint' then 1
when data_type in ('varchar','char') then CHARACTER_MAXIMUM_LENGTH
when DATA_TYPE in ('datetime2') then 8
when data_type='timestamp' then 8
when data_type = 'date' then 3
when data_type='smallint' then 2
when data_type ='bit' then .5 --i know there are 2 of these
when data_type ='datetime' then 8
when data_type = 'float' then 4
end [storagesize],
countstar
from information_schema.columns a
left join cte b
on a.table_name=b.t_name
where ...a bunch of predicate criteria that filter my schema and tables of interest
) x
