User Running Qlikview ontop of OLAP Tabular Cube as Source

Question

Good day,

I have a few users who recently joined the company and only wants to use qlikview which the company does not have and uses SQL OLAP & SQL OLAP Tabular
I recently (last week) completed a very detail Tabualr cube which contains thousands of records view

I noticed today the sql dw was struggling badly and the memory for DB and SSAS Tabualr was swapped around and went to 500mb whereas the tabular service memeory was at 34gb

and once tabular released the db engine service slowly regains back to 25gb normal/max allocated memory and tabular back to 2gb normal
I heard via rumour that these users have Qlikview running on top of the cube and the cube as a source

I cant allow this,

1. how do i see which users are running the particular tabular cube
2. which tabular cube is causing this, so that i can prove my theory
3. is there a way to prevent this?
4. How can i proof which application is accessing it?

Please help, thank you!

and how do

Answer 1

Hi,

Seems we could not from SSAS side know which kind of client tool is connecting to SSAS, neither we could block certain client tool like QlikView form SSAS side.

1. how do i see which users are running the particular tabular cube
2. which tabular cube is causing this, so that i can prove my theory

For this we could use SQL Profiler to monitor the SSAS tabular server, we could know which user is access which particular tabular. SSAS Tabular Logging Methods
For the memory monitoring you could using Server Performance Monitor

I noticed today the sql dw was struggling badly and the memory for DB and SSAS Tabualr was swapped around and went to 500mb whereas the tabular service memeory was at 34gb

Depends on you tabular size, this could be a normal behavior. Since SSAS tabular and SQL Server are both resource intensive software, normally we would suggest company to install them on two machines or add more RAM to the server (if you have to had them on one machine). This way these two server would not compete for hardware resource.
Notice that tabular server is especially RAM intensive app.

At last, my personal opinion, is that the client tool probably won't affect server performance. Whether they are using Power BI or Excel or QlikView, what critical is the query they made, not the tools.
(Also QlikView for personal is free to use, I noticed that you've asked this in another thread.)

Hope this helps a bit.
Regards,
Lukas

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November

Answer 2

Hi, Thank You for the assistance!

On my upgrade thread, my plan is 2 vm

• can you specify what infratrsuture RAM is recommneded to run presentation olap tabular, 2TB good ?
• instead of migrating to Qlikview as im not too confident its evolving > thoughts of PowerPivot

Answer 3

Hi,

It is recommended to have 2.5 - 3 times RAM sizes of the SSAS database size. For example the estimated size of SSAS databases are 1GB, you would need 3GB to maximize the RAM use. You could find the estimated size in SSAS database property.

Based on my limited exploration and research , I think when personal use Qlikview is good for data visualization. For this case , I think PowerPiovt and PivotChart could fulfill similar task.
Also use Qlikview in a company analysis scenario could hardly be treated as "personal use", I'm afraid your company would need to purchase its license, I am not sure on this. Better consult Qlik community or your legal support on this.

Reagrds,
Lukas

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November

Answer 4

Thank You very much LukasYu-msft
I cant seem to mark as answer