Friday, March 23, 2012

Report Model in VM environment

What are the limitation when creating report models in VM environment?

Not certain what you mean by "VM environment" but if you are referring to Virtual Machine/Server, yes report models are supported.

Hope that helps.

Thanks, Jon

|||

Jon - Correct, I was refering to "Virtual Machine/Server". When trying to create report models that sits on "Big" tables, it happens very often that I get "Timeout Error" which usually occurs after 5min. All the timeout parameters in Data Source are set to zero but it still happens.

Thanks

|||

I might suggest running with gather statistics=false. This should increase performance of model generation as it will not need to query the data.

Otherwise, in what context is the timeout error occuring. Does the error message denote a SQL or IIS timeout?

Thanks, Jon

|||

Jon - It's a SQL timeout and usually it occurs when column uniqueness is being calculated.

Thanks

No comments:

Post a Comment