cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vickyd Member
Member

Performance worse after increasing CPU Cores

We have Power BI Report server based reports that connect to SSAS Tabular Models (SQL Server 2017). 

 

We recently tried upgrading our VM , adding in more cores (4 to 😎 and RAM (64 to 128GB). This ended up making performance of reports/dashboards worse. When we reverted back the configuration things are fine again. 

 

We specifically noticed a strange scenario with the upgraded configuration. When I ran a certain MDX query as myself (I'm setup as an admin on the server) in SSMS Browser mode it ran in a 2 secs but the exact same query took >30secs when I was impersonating another user (we do have a fairly complicated row level security logic built into the models). With the older VM configuration it only took about 5-6 secs in impersonated mode.

 

Any reason why there is such a huge difference with the addition of cores/RAM? Any tips on how I can go about understanding this better?

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)