This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Hi Expert,
is there any way to refresh the cubes rather than ssms .. it takes only memory and not cpu usage
any query that we can tracked /trace on database while running the query or refreshing the cubes .. if yes then help me with path or the query to get it
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @Shambhu Rai ,
Please refer to this document: Log operations in Analysis Services
You need to note that Query log can be enabled for Analysis Services multidimensional mode instances only. Query log cannot be enabled for tabular mode instances.
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Hi Expert,
Is there any way i can see the query log on db level
is there any way to refresh the cubes rather than ssms
You can use SSDT => Process or a SSIS package with Analysis Services Processing Task, that processing can also be scheduled using a SQL Server-Agent job.
it takes only memory and not cpu usage
On client or on server side? And what's the problem with it?
any query that we can tracked /trace on database
As in your post subject, with, see Log operations in Analysis Services
Hi @Shambhu Rai ,
Pleas read this blog: How to Refresh SSAS Tabular Cube?
Two methods are mentioned in the blog. One is done through a visualization tool such as SSMS or VS. Another one is Refresh with SQL Server Job.
In addition, please refer this related thread: https://dba.stackexchange.com/questions/232833/ssas-model-refresh-not-enough-memory-to-complete-this-operation-error
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".